Custom Application Metering Report for Specific Software for 8.5 RU3 and above

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

Release: 8.5 RU3 and greater

Cause

Application metering processing and reports changed with 8.5 RU3

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

Resolution

This is a simple example to show computers, users, software, and last start date starting with 8.5 RU3.

 

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)   --   In this case we needed to see 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 Reports > Software > Application Metering > Underutilized Software