Metering Report for Specific software not working
Hello,
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",
SVTS.NAME,
VERSION,
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
0 Comments
[ + ] Show comments
Answers (1)
Please log in to answer
Posted by:
h2opolo25
10 years ago
Test it by using just "%Ac%" and see if you see Acronis or Active listed. You'll probably have to sift throgh the Acrobat instances.
Also make sure that metering is enabled on the software AND machines that you are trying to get the info for.
Comments:
-
Also for the conversion for seconds to hours you need to divide by 3600 not 360. - h2opolo25 10 years ago
