Hey everyone,

I'm trying to run a report on usage of specific software such as Visio 2013, Project 2013, Creative Cloud, etc. I've gone through and created individual labels for each and applied those labels to the software and to the users. When I pull the report for Acrobat X Standard though, it shows that only 2 people have used it even though there are 57 that have it installed. Here's the SQL query I'm using:

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 "%Acrobat%X%Standard%"
GROUP BY TITLED_APPLICATION_ID, MACHINE_ID

ORDER BY Launches DESC

Any help at all is appreciated! Thank you.
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

There are no answers at this time

Answers

Answer this question or Comment on this question for clarity