Jump to content


IanLeach

SQL Query to return collected filenames and titles

Recommended Posts

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...