SMS SQL for Metering Data

Shows you the computer, file name, file path, usage count, and last usage. Must have metering enabled, with some valid rules defined.

----Begin SQL----

SELECT SYS.Netbios_Name0, SF.FileName, SF.FilePath,
MUS.UsageCount, MUS.LastUsage
FROM v_MonthlyUsageSummary MUS INNER JOIN v_R_System SYS
ON MUS.ResourceID = SYS.ResourceID INNER JOIN v_GS_SoftwareFile SF
ON MUS.FileID = SF.FileID
ORDER BY SYS.Netbios_Name0, SF.FileName, SF.FilePath

----End SQL----