The only issues I've had with he AI view, a long time ago, was Office inventory showed up funky and the cert expired. Those were both resolved in short time. There was an instance where I had to extended and use the ARP class to filter out systemcomponents (anything not explicitly show in the appwiz.cpl) due to a requirement. Concerning SQL instances, I've relied on creating custom classes for inventorying SQL instances using Sherry's tutorial.
-Stephen On Jun 3, 2016, at 3:39 PM, Garth Jones <[email protected]<mailto:[email protected]>> wrote: I will minus on that CM SQL view. The reason is simple, that V_GS_INSTALLED_SOFTWARE does not show everything that is possible installed, for that matter it will hide some software title which are listed within ARP like Microsoft SQL server 2014. You can read my blog on the subject. http://www.enhansoft.com/blog/configuration-manager-and-asset-intelligence Garth Jones Chief Architect www.Enhansoft.com<http://www.enhansoft.com/> <image001.jpg><http://www.enhansoft.com/> Enhancing Your Business <image002.png><http://www.enhansoft.com/blog><image003.png><https://twitter.com/enhansoft><image004.jpg><http://www.facebook.com/EnhansoftInc><image005.png><http://www.youtube.com/user/Enhansoft/videos><image006.png><http://myitforum.com/myitforumwp/community/groups/enhansoft/> Subscribe to Enhansoft's Newsletter!<http://www.enhansoft.com/register> From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Stephen Leuthold Sent: Friday, June 3, 2016 1:21 PM To: [email protected]<mailto:[email protected]> Subject: Re: [mssms] RE: Query Help PLUS ONE for V_GS_INSTALLED_SOFTWARE ! -Stephen On Jun 3, 2016, at 11:29 AM, Todd Hemsell <[email protected]<mailto:[email protected]>> wrote: V_GS_INSTALLED_SOFTWARE is far superior to any of that. On Thu, Jun 2, 2016 at 12:07 PM, Murray, Mike <[email protected]<mailto:[email protected]>> wrote: I think you'll want to look at Installed Applications instead. There's also an Installed Applications (64). <image007.png> From: [email protected]<mailto:[email protected]> [mailto:[email protected]<mailto:[email protected]>] On Behalf Of Brian McDonald Sent: Thursday, June 2, 2016 6:47 AM To: [email protected]<mailto:[email protected]> Subject: [mssms] Re: Query Help 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]<mailto:[email protected]> <[email protected]<mailto:[email protected]>> on behalf of Garth Jones <[email protected]<mailto:[email protected]>> Sent: Wednesday, June 1, 2016 3:45:04 PM To: [email protected]<mailto:[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/> <image001.jpg><http://www.enhansoft.com/> Enhancing Your Business <image002.png><http://www.enhansoft.com/blog><image003.png><https://twitter.com/enhansoft><image004.jpg><http://www.facebook.com/EnhansoftInc><image005.png><http://www.youtube.com/user/Enhansoft/videos><image006.png><http://myitforum.com/myitforumwp/community/groups/enhansoft/> Subscribe to Enhansoft's Newsletter!<http://www.enhansoft.com/register> From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Brian McDonald Sent: Wednesday, June 1, 2016 4:02 PM To: [email protected]<mailto:[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
