Is it possible to make a Report that sends the Usage Recording of a software?
I want to make a report that sends monthly a record of all the users / notebooks that used a certain software. The question is this possible?
When going into the softwarekatalog you can search for the software and then see the Usage Record, look into the image below, this is a cool feature and I would love to have it as a report.
Answers (1)
This should be possible but you may need some clever SQL to add up fields, the data is held in the SAM tables, here is a quick bit of a report that will point you in the right direction to get started.
SELECT SAM_METER_DATA.MACHINE_ID,
MACHINE.NAME,
SOFTWARE.DISPLAY_NAME,
SAM_METER_DATA.LAUNCHES,
SAM_METER_DATA.SECONDS_USED,
SAM_METER_DATA.LATEST_ENTRY
FROM (SAM_METER_DATA SAM_METER_DATA
INNER JOIN SOFTWARE SOFTWARE
ON (SAM_METER_DATA.TITLED_APPLICATION_ID = SOFTWARE.ID))
INNER JOIN MACHINE MACHINE
ON (SAM_METER_DATA.MACHINE_ID = MACHINE.ID)
WHERE (SAM_METER_DATA.LATEST_ENTRY > DATE_SUB(NOW(), INTERVAL 31 DAY)
