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

Comments

Please log in to comment

Answers

0
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.
Answered 11/19/2014 by: h2opolo25
Red Belt

  • Also for the conversion for seconds to hours you need to divide by 3600 not 360.
Please log in to comment
Answer this question or Comment on this question for clarity

Share