Pandora FMS community forums
Recursive WMI querries - Printable Version

+- Pandora FMS community forums (https://pandorafms.org/forum)
+-- Forum: Pandora FMS (https://pandorafms.org/forum/forum-3.html)
+--- Forum: Suggestions and new feature request (https://pandorafms.org/forum/forum-12.html)
+--- Thread: Recursive WMI querries (/thread-845.html)



Recursive WMI querries - davidp - 05-29-2009

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

Code:
SELECT Name,IndentifyingNumber,Vendor,Version FROM CIM_Product WHERE __CLASS <> 'Win32_ComputerSystemProduct'

Which lists all installed softwares on a Windows box, or

Code:
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


Recursive WMI querries - slerena - 06-01-2009

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.