/build/static/layout/Breadcrumb_cap_w.png

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
  • I just logged on to ask this exact question. Specifically, I need a report just like the "Metered Device Detail (Last 7 Days)" under a specific software catalog title, which includes total hours used, total launches, and last launch for each device. Even better, if I could get the SQL query KACE uses to display that data, I could edit it for another time frame, such as last 30 days.

    Glad I'm not the only one looking for this information. - quarles 6 years ago

Answers (1)

Posted by: chucksteel 6 years ago
Red Belt
1
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
 
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