Installed vs. Used Report for the Real World in Application Metering 6.1 - Updated

A while ago I found a download Installed vs. Used Report for the real world. And like the author of the above download I was not happy with the Altiris provided Installed vs Used report.

I had a look at bkaulins report and changed it a bit more for our environment.

Modifications I did:

1. Report Target collections
      a. Collection contains Windows XP PCs with the particular application installed
      b. PCs have to report to NS in the last 90 days
      c. Each collection is filtered against Application Metering Agent presence; otherwise result will not be true: it will report as application is installed, but not in use.
2. Report
      a. All sub reports are opening in the new window
      b. Used/ Not Used reports show Last Logon user and Client PC date and time

To run it you need to do the following:

1. For each application in question create collection for PCs with that application installed see Collection MS Visio Professional 2003 Installed.xml as an example you can import it to your Notification Server and then clone it and change for the other applications.
2. Import a report and run it as per picture below

Then right click on the highlighted area and you can display Used and Not Used in the new windows.

Few tips for the application metering:

• Monitor only needed applications, if you monitor all .exe files, data base table will grow big very quickly which will decrease SQL performance and report may time out.
• Purge old data aggressively: configure purging maintenance to delete all not needed data from Altiris DB.
• Check table Inv_AeX_AM_Monthly_Summary_spt, it may be too big already and you will have clean it manually, if there are more than 2,000,000 rows more likely report will time out.

Feel free to use and modify it as you need to.