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?
-
Do you have metering enabled for all versions of Visual Studio software in the Software Catalog? - ondrar 6 years ago
-
Yep. Every entry I could find. - doctrinerenounce 6 years ago
Answers (2)
Top Answer
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',
SVTS.NAME,
VERSION,
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.
Comments:
-
That is pretty close to what I need. I can modify the application names to do what I need. Thanks. Once last question, Is it possible to modify the interval to report on any system that has not launched that in greater than a month? - doctrinerenounce 6 years ago
-
The interval can be changed, yes. This line:
AND END > DATE_SUB(now(), INTERVAL 1 MONTH)
sets the interval, you can change the 1 MONTH to another value. The designation for the kind of interval is always singular and upper case, e.g. 2 MONTH, 45 DAY, 1 YEAR, etc.
Your question says "not launched" in greater than a month. If you would like a report of machines that have the software installed but hasn't been launched, that would be a different query. - chucksteel 6 years ago-
I could see that being useful. If you have the time to throw up an example. - doctrinerenounce 6 years ago
-
I don't have a report for that. We use the licensing module to track licenses and it shows you the machines that haven't launched the software in the past 90 days. Even if you don't include the actual license information for a piece of software, you can add a "license" that is associated with the software catalog to get the information you need. - chucksteel 6 years ago
-
No problem. I can get at that information and I do not think management will really want that data very often anyway. Thanks again for all of the help. - doctrinerenounce 6 years ago
I'm new to reports. I'm trying to get to work but I always have "No results found". I've attempted to change SVTS.NAME to multiple different software and still no luck. Do the % need to exist and what are they for?
Do I have to setup metering for each software? If so, where?
Comments:
-
The percent symbol is the wildcard for SQL queries, so LIKE "%something%" will find strings that contain something.
Yes, metering must be enabled. That is done in the software catalog. - chucksteel 5 years ago