United Kingdom Endpoint Management User Group

 View Only

Application Metering usage data for a specifc file name 

Feb 12, 2014 03:27 PM

If you don't like drilling down into the usage report, here is a SQL query that you can run to find usage data either for all files that have been metered or for a specifc file:

SELECT rf.Name AS [File],c.Name AS Computer,wu.UserId,
ms.[Month Year],ms.[Run Count],ms.[Last Start]
FROM vAMMonthlySummary ms
JOIN vComputer c ON ms._ResourceGuid = c.[Guid]
JOIN Inv_Global_Windows_Users wu ON ms.UserGuid = wu._ResourceGuid
JOIN RM_ResourceFile rf ON ms.FileResourceGuid = rf.[Guid]
--WHERE rf.Name LIKE '%part of filename%' --provides data for specific file
ORDER BY c.Name,wu.UserId ASC

Statistics
0 Favorited
0 Views
0 Files
0 Shares
0 Downloads

Tags and Keywords

Related Entries and Links

No Related Resource entered.