SQL Query to return collected filenames and titles

[IanLeach]

Hi there,

 

I'm trying to find a way to produce an extract of all inventoried executables and then tie them back to a common application name, for example;

 

WINWORD.EXE - Microsoft Office Word 2013

 

Has anyone any thoughts or queries they can share?

 

Ian.

[GarthMJ]

First off, I NEVER recommend using Software Inventory there are just too many problems with it!

What wrong with using the built-in Report for Add/Remove Programs information or AI data?

[IanLeach]

Hi Garth and thanks for your reply.

 

The built-in report for "Count of all instances of software registered with Add/Remove programs" returns the list of discovered apps but doesn't provide me with a corresponding exe. I'm trying to source them so I can run the PowerShell script to generate Software Metering rules.

 

I agree, SINV reports a load of chaff that you have to wade through but given that I've around 300 apps to establish rules for, I'm happy to locate each from the endless list of executables...

 

Any other thoughts?

 

Ian.

[GarthMJ]

So you really want 300 SWM rules?? Wow that is a lot. There is a limit to the number of rules that you can have and it is limited by the size of the policy rules that get download to the CM client. It is not a hard, fast limited as the more data you put in the less rules you can have, I have never hit it mostly because I have never had more than 25 rules. But the limit is approximately like 100, 250, or 500.

 

IMO, I would only write rules for that applications that require a license. I would also use the trick of using generic rule for an application and disabled SWM rules for reporting.

 

http://be.enhansoft.com/post/2014/07/17/Total-Usage-for-All-Metered-Software-Programs-Query-Matches-the-Executable-Name.aspx

http://be.enhansoft.com/post/2014/07/22/Disabled-Software-Metering-Rules-Are-a-Good-Thing!.aspx