Custom Application Metering Report for Specific Software

Products

• Client Management Suite

Issue/Introduction

When setting up a custom report to look for computers that last used a specific application more than 90 days ago, there was no data returned when it was expected it would return data. 

 

Environment

ITMS 8.5 RU3 and greater

Cause

Application metering processing and reports were changed with 8.5 RU3

Two new tables include Inv_Product_Monthly_Summary and Inv_Software_Product_Usage were created to facilitate the new rules method used in Application Metering.

Resolution

This is a simple example to show computers, users, software, and last start date available with 8.5 RU3 and later versions:

select 
    vc.name as 'Computer',
    vc.[user],
    sp.Name as 'Software',
    ms.[Last Start] as 'Last Used',
    sp.CreatedDate
from Inv_Product_Monthly_Summary ms
join vcomputer vc on vc.guid = ms._ResourceGuid
join RM_ResourceSoftware_Product sp on sp.Guid = ms.ProductGuid
where ms.[Last Start] >= (GETDATE() - 90)   --   set to show computers that had used the software but had not used it in the last 90 days
and sp.name like '%acrobat%'   --   optional filter by a part of a name of the software

Additional Information

The built-in reports for Application Metering are located in the SMP Console under:

Reports > Software > Application Metering > Underutilized Software