Symantec Management Platform (Notification Server)

 View Only
  • 1.  Create a Filter on Soundcards installed

    Posted Feb 02, 2012 11:01 PM

    Hi All,

      Can someone help me out in creating a filter on soundcards installed on PC's, I need to filter out a specific type of card.  I've tried to scan the DB for the table that holds this information but i'm still learning my way through it all.

     

    Cheers



  • 2.  RE: Create a Filter on Soundcards installed
    Best Answer

    Posted Feb 03, 2012 02:31 PM

    You will need to find the Vendor ID or Device ID from within Device Manager on a managed computer (Hardware Ids drop-down under Details tab when viewing the properties of a device.)

    For example, DEV_1984 is my High Definition Audio Device on an Optiplex 755.

    SELECT sd._ResourceGuid
    FROM Inv_HW_Sound_Device sd
    WHERE sd.[Device Id] LIKE '%DEV_1984%'

    By the way, if you're ever viewing information in the Resource Manager, the name of the data class in SQL is easy to figure out.  If you open Resource Manager, then choose View > Inventory, then expand Inventory > Hardware > Sound Device, you know that your data class will be called Inv_HW_Sound_Device.  Software condenses to SW, Operating System to OS.

    Does this help?



  • 3.  RE: Create a Filter on Soundcards installed

    Posted Feb 08, 2012 04:14 PM

    Your a champ, i've learnt something new and that little tib bit has helped a great deal.