Software Usage Questions
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",
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.
Please log in to answer
Be the first to answer this question