Best Practices Question
Metering Report with 0 launches
12/02/2014 1334 views
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",
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
Be the first to answer this question