Report for Last used in Metering
Is it possible to create a report in 5.4 that will report on Software Asset within Metering for a particular software that will also show when it was last used? For example I have Visio 2010 getting metered and would like to create a report that shows the computer name, user name, and the date it was last used. I do not see it as an option in the report wizard so I am wondering if this is possible and if anyone has done this before.
-
You may want to upgrade to 5.5. With that the software catelog will tell you what machine, product, user and last launched. That might be you what you are looking for. - nshah 10 years ago
-
Thanks we wanted to wait a little before upgrading just to make sure there aren't any major bugs reported. I am hoping I can make this work in our current version for now. - rchung 10 years ago
Answers (2)
Haven't tried it myself, but I think these will get you most or all of the way to what you are after:
http://www.itninja.com/question/a-report-on-software-metering-by-n-months
SELECT M.PROCESS_NAME AS METER_PROCESS,
S.NAME AS SOFTWARE_NAME,
MA.NAME AS MACHINE_NAME,
MC.TIMES_LAUNCHED,
MC.MINUTES AS MINUTES_USED,
MA.USER, MA.USER_FULLNAME,
MC.LAST_LOGGED
FROM METER M
JOIN METER_COUNTER MC ON MC.METER_ID = M.ID
LEFT JOIN ASSET S ON S.ID = M.SOFTWARE_ID
JOIN MACHINE MA ON MA.ID = MC.MACHINE_ID
ORDER BY MA.NAME;
Comments:
-
The above SQL got me the information I needed. - rchung 10 years ago