Kace Software Metering reports
I am trying to create a software metering report that will show me the unique active users of all of our versions of Visual Studio, excluding server operating systems. This is proving difficult as we have a lot of people that have multiple different versions installed. I can use a device report to narrow down machines that have something Visual Studio installed, but that does not give me any of the metering data. And a metering report will not give me usage data regardless of version. I am guessing this is going to need to be done with some custom SQL but I am at a loss on where to start with that. Does anyone have any insight they could provide to help me figure this out?
We don't meter Visual Studio, but here is my report for Acrobat Professional:
SELECT COUNT(SMD.ID) as 'Launches', SUM(SECONDS_USED)/3600 as 'Time Used (hours)',
MAX(END) as 'Last Used',
MACHINE.NAME as 'Computer', MACHINE.OS_NAME,
GROUP_CONCAT(DISTINCT(USER_DATA)) AS 'Users'
FROM ORG1.SAM_METER_DATA SMD
JOIN MACHINE on SMD.MACHINE_ID = MACHINE.ID
JOIN SAM_VIEW_TITLED_SOFTWARE SVTS on SMD.TITLED_APPLICATION_ID = SVTS.ID
WHERE SVTS.NAME like "%Acrobat%Professional%"
AND END > DATE_SUB(now(), INTERVAL 1 MONTH)
GROUP BY TITLED_APPLICATION_ID, MACHINE_ID
ORDER BY Launches DESC
This is limited to the last month.