Discussions – Community pioneers – Pandora FMS Community

Recursive WMI querries

Community pioneers

Recursive WMI querries

Posted by davidp on mayo 29, 2009 at 15:23
I’d like to be able to execute queries that returns multiple rows in Pandora in order to track changes and thus make sure workstations remain compliant.

One of such queries is
```
SELECT Name,IndentifyingNumber,Vendor,Version FROM CIM_Product WHERE __CLASS <> 'Win32_ComputerSystemProduct'
```
Which lists all installed softwares on a Windows box, or
```
SELECT Name,SID FROM Win32_Account WHERE SID LIKE 'S-1-5-21-%' to list human-created user account.
```
In short, a WMI multi_string data type would be nice. I don’t know the impact on code nor on SQL schema, but hopefully it wouldn’t be too difficult to implement.

Thanks in advance.
David
Sancho replied 15 years, 5 months ago 2 Members · 1 Reply
1 Reply

Sancho

Organizer
junio 1, 2009 at 04:44

2229 Karma points

Community awards: Bright ideas

Community rank: Tentacle Master

Like it
Up
0
Down
Drop it
::
This is exactly what inventory servers does now (but remotely). In addition, next agent for 3.0 or 3.1 version will also take information on systems to populate inventory. But inventory is a feature of Enterprise version, not the opensource.

Log In to Reply