05-29-2009, 11:23 AM
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
Which lists all installed softwares on a Windows box, or
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
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