/build/static/layout/Breadcrumb_cap_w.png

Software Question


Software Usage Questions

09/10/2015 1235 views
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


Be the first to answer this question

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

View more

Software Questions

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ