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.
Release: 8.5 RU3 and greater
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.
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
The built-in reports for Application Metering are located in Reports > Software > Application Metering > Underutilized Software