Yes. Problem is several of these names aren't coming up when I search the Parameter Value under Computers with a specific product.
Example of a few include: HTMLDOC, Lotus Domino, ClearingHouse, CVE-2013-1347, ImageRight Desktop, ImageRightPrinter and more... Here is the SQL query I'm using: eclare @CollID char(8) Set @CollID = 'SMS00001' SELECT DisplayName0, Count(*) AS 'Count', Publisher0, Version0, @CollID as CollectionID FROM v_Add_Remove_Programs arp JOIN v_FullCollectionMembership fcm on arp.ResourceID=fcm.ResourceID WHERE fcm.CollectionID = @CollID GROUP BY DisplayName0, Publisher0, Version0 ORDER BY Publisher0, Version0 ________________________________ From: [email protected] <[email protected]> on behalf of Garth Jones <[email protected]> Sent: Wednesday, June 1, 2016 3:45:04 PM To: [email protected] Subject: [mssms] RE: Query Help Have you looked at the built-in reports for this yet? Garth Jones Chief Architect www.Enhansoft.com<http://www.enhansoft.com/> [Description: Description: cid:[email protected]]<http://www.enhansoft.com/> Enhancing Your Business [Description: Description: Description: Description: Description: Description: Description: cid:[email protected]]<http://www.enhansoft.com/blog>[Description: Description: Description: Description: Description: Description: Description: cid:[email protected]]<https://twitter.com/enhansoft>[Description: Description: Description: Description: Description: Description: Description: cid:[email protected]]<http://www.facebook.com/EnhansoftInc>[Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Enhansoft's YouTube Page]<http://www.youtube.com/user/Enhansoft/videos>[Description: Description: Description: Description: Description: Description: Description: cid:[email protected]]<http://myitforum.com/myitforumwp/community/groups/enhansoft/> Subscribe to Enhansoft's Newsletter!<http://www.enhansoft.com/register> From: [email protected] [mailto:[email protected]] On Behalf Of Brian McDonald Sent: Wednesday, June 1, 2016 4:02 PM To: [email protected] Subject: [mssms] Query Help Hello, Management has provided me a list of applications they're researching and would like to know which devices have these applications have. Is there a SQL query I could use as a template and re-use it by modifying the DisplayName? For example, one of the apps in question is 'AOL Toolbar'. Can someone provide an example of a query I could use for this task? And make modifications to the query based on the name? Thanks, Brian
