Metering Report with 0 launches
Hello,
I am running the report below, however, I'd like to also show software that has not been launched. Is there a way to do this?
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 "%Visio%"
GROUP BY TITLED_APPLICATION_ID, MACHINE_ID
ORDER BY Launches DESC
4 Comments
[ + ] Show comments
-
Since you are selecting from the metering data table this will only show titles that have been launched at least once. If you want to include all titles you'll need to start with the software table and then join to the metering data. - chucksteel 9 years ago
-
Thank you. Any idea on how I would merge the two into one report? - pregiec 9 years ago
-
Nice initial report, very useful. I too have a need to see the applications that have never been launched as well. Attempted to use the canned report "Software installed but not ran in the last X months" and was going to bump it up against the query above but, the output was a mess. Any help or guidance with joining the software and metering data together in one report would be greatly appreciated. - jwilliams 9 years ago
-
Would you really want a report of all software in the database? In most cases that will be huge. Or should the report only include titles that are marked for metering but include those that haven't been launched? - chucksteel 9 years ago
Answers (0)
Please log in to answer
Be the first to answer this question
