/build/static/layout/Breadcrumb_cap_w.png
04/11/2018 560 views
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

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.

All 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

Don't be a Stranger!

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

Sign up! or login

Share