Best Practices Question
Metering Report for Specific software not working
11/19/2014 1766 views
I've been using a metering report for certain software. The report below has worked for me for other software, but for a select few like Acronis or Active@ disk it doesn't seem to display any output even though there are machines with the software installed. Is there something wrong with the report below or anything I can adjust to make it display machines with the specified software?
SELECT COUNT(SMD.ID) as "Launches",
SUM(SECONDS_USED)/360 as "Time Used (hours)",
MAX(END) as "Last Used",
MACHINE.NAME as "Computer",
GROUP_CONCAT(DISTINCT(USER_DATA)) AS "Users"
FROM ORG1.SAM_METER_DATA SMD
JOIN MACHINE on SMD.MACHINE_ID = MACHINE.ID
JOIN SAM_VIEW_TITLED_SOFTWARE SVTS on SMD.TITLED_APPLICATION_ID = SVTS.ID
WHERE SVTS.NAME like "%Acronis%"
GROUP BY TITLED_APPLICATION_ID, MACHINE_ID
ORDER BY Launches DESC