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.

Answer Summary:
Cancel
1 Comment   [ + ] Show Comment

Comments

  • 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.
    • 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.
Please log in to comment

Answers

0

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

http://www.itninja.com/question/kace-reports-1

Answered 09/17/2013 by: cblake
Red Belt

Please log in to comment
0

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;

Answered 09/17/2013 by: rchung
Brown Belt

  • The above SQL got me the information I needed.
Please log in to comment
Answer this question or Comment on this question for clarity

Share