Recursive WMI querries

  • Recursive WMI querries

    Posted by davidp on May 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, 4 months ago 2 Members · 1 Reply
  • 1 Reply
  • Sancho

    Organizer
    June 1, 2009 at 04:44
    2214 Karma points
    Community awards: bulb Bright ideas
    Community rank: tentacle_master_icon 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.