Video Screencast Help
Protect Your POS Environment Against Retail Data Breaches. Learn More.

Create a Filter on Soundcards installed

Created: 02 Feb 2012 • Updated: 08 Feb 2012 | 2 comments
This issue has been solved. See solution.

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

Comments 2 CommentsJump to latest comment

mclemson's picture

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?

Mike Clemson, Senior Systems Engineer, ASC
Intuitive Technology Group -- Symantec Platinum Partner
intuitivetech.com

SOLUTION
BlueyX5's picture

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