/build/static/layout/Breadcrumb_cap_w.png

Best Practices Question


Metering Report with 0 launches

12/02/2014 1334 views
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?

Be the first to answer this question

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ