Software

How would you represent "how often it is used"? Last launch? Launches in the past x number of days? - chucksteel 4 years ago

I would like to know the entire history if possible so that I can make a report on the need for this software to be installed on a new build - Sladey77 4 years ago

Can I suggest that you maybe then need to change your focus of the report? If, for example you need to justify buying the version of Office that has publisher included, you first need to understand how many Devices have publisher installed, and you may want to overlay information about how many of them have used publisher in the last 3-6 months from metering data?

If you want to know the entire history of Publisher usage then that needs to come from the data regarding metering only, with maybe some added machine data in? - Hobbsy 4 years ago

I have moved on and been able to use the following report to show some data but I need to know which individual device is used & how many times it has launched from a certain device & how many hours used on each device the report & output is shown below

SELECT SVTS.NAME AS PRODUCT_NAME,

SAM_METER_DATA.VERSION,

(SELECT COUNT(DISTINCT MACHINE_ID) from SAM_VIEW_MACHINE_DISCOVERED_SOFTWARE X

WHERE X.ID = SVMDS_APPS.ID OR X.ID = SVMDS_SUITES.ID) AS INSTALL_COUNT,

ROUND(SUM(SAM_METER_DATA.SECONDS_USED) / 3600.0, 3) AS TOTAL_HOURS_USED,

SUM(SAM_METER_DATA.LAUNCHES) AS TOTAL_LAUNCHES

FROM SAM_METER_DATA

LEFT JOIN SAM_VIEW_MACHINE_DISCOVERED_SOFTWARE SVMDS_APPS

ON SAM_METER_DATA.TITLED_APPLICATION_ID = SVMDS_APPS.ID

AND SAM_METER_DATA.MACHINE_ID = SVMDS_APPS.MACHINE_ID

AND SAM_METER_DATA.VERSION = SVMDS_APPS.VERSION

LEFT JOIN CATALOG.TITLED_SUITE_APPLICATION_JT TSAJT

ON TSAJT.TITLED_APPLICATION_ID = SAM_METER_DATA.TITLED_APPLICATION_ID

LEFT JOIN SAM_VIEW_MACHINE_DISCOVERED_SOFTWARE SVMDS_SUITES

ON SVMDS_SUITES.ID = TSAJT.TITLED_SUITE_ID

AND SAM_METER_DATA.MACHINE_ID = SVMDS_SUITES.MACHINE_ID

LEFT JOIN SAM_VIEW_TITLED_SOFTWARE SVTS

ON SAM_METER_DATA.TITLED_APPLICATION_ID = SVTS.ID

JOIN MACHINE M ON M.ID = SVMDS_APPS.MACHINE_ID OR M.ID = SVMDS_SUITES.MACHINE_ID

GROUP BY SAM_METER_DATA.TITLED_APPLICATION_ID

ORDER BY PRODUCT_NAME


Data pulled out
Product Name Version Install Count Total Hours Used Total Launches
Access 16.x 16.0.4639.1002 197 445.736 398
Access 2010 14.0.4750.1000 2426 114017.986 92439
Access 2010 Standalone 14.0.7104.5000 6 39.344 109
Access 97 8.0.4122 6 2.057 68
Acrobat Distiller 11.x (Adobe Acrobat) 11.0.0.379 3 40.257 1221
Acrobat Distiller X (Adobe Acrobat) 10.1.16.13 4 20.642 1354
Acrobat X Professional 10.1.16.13 3 5701.294 24310
Acrobat X Standard 10.1.16.13 1 150.178 1150
Acrobat XI Professional 11.0.0.379 3 5277.923 18795
Crystal Reports 2016 14.2.3.2132 11 819.176 463
Excel 16.x 16.0.4654.1000 856 78791.828 42107
Excel 2010 14.0.6117.5003 2426 1648023.31 1564881
Excel 2013 15.0.4420.1017 1 912.334 2342 - Sladey77 4 years ago