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

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.
  • Thank you. Any idea on how I would merge the two into one report?
    • This content is currently hidden from public view.
      Reason: Removed by member request
      For more information, visit our FAQ's.
  • 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.
  • 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?
Please log in to comment

There are no answers at this time

Answers

Answer this question or Comment on this question for clarity