/bundles/itninjaweb/img/Breadcrumb_cap_w.png
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   [ - ] Hide Comment

Comments

  • 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.
Please log in to comment

Answer this question or Comment on this question for clarity

Answers

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

Answered 04/12/2018 by: chucksteel
Red Belt

  • This is perfect for me. Thank you
Please log in to comment