/build/static/layout/Breadcrumb_cap_w.png

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. 

2Q==


0 Comments   [ + ] Show comments

Answers (1)

Posted by: Hobbsy 2 months ago
Red Belt
0

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)

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

View more:

Share

 
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