How to run a report on metering?
I have a list of software being metered. I need to have a report that shows 1. The system 2. The user, 3. How long they used said software, 4. how many launches. When I open said software in software catalog I can see all the info I need. However, I can't export it to a PDF or CSV. With that being said, when I am at the home screen for Software Catalog and put a checkmark in the box next to the software I want to run a report on it gives me a full report on every software in the catalog NOT just on the one I have put a checkmark next to. Why? Why in the name of the Gods, the old and the new, does it do that?
1 Comment
[ + ] Show comment
Answers (1)
Please log in to answer
Posted by:
chucksteel
6 years ago
Here is the report I use:
SELECT COUNT(SMD.ID) as "Launches", SUM(SECONDS_USED)/3600 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%DC%"
AND END > DATE_SUB(now(), INTERVAL 1 MONTH)
GROUP BY TITLED_APPLICATION_ID, MACHINE_ID
ORDER BY Launches DESC
Comments:
-
This is perfect for me. Thank you - quarles 6 years ago
Glad I'm not the only one looking for this information. - quarles 6 years ago