Software Metering report – Specific Application not used since last 90 days

In this post I am going to share SQL query (for reporting purpose). This can be used to fetch the data for applications which are not used for last 90 days.

I have used Microsoft Word as an example. You need to make sure the winword.exe is enabled as Software meter rule in your SCCM environment. You may modify based upon your requirement and better to use it with parameter so that you can have a more powerful way to select from list of application:

(more…)