Posted on 09-12-2014 01:31 AM
Is there a way to produce a CSV/PDF report of Application usage by number of computers?
We want to start reporting on where we have applications deployed but I don't see any kind of export button in the JSS...
Posted on 03-30-2015 08:10 AM
Bumping this post, because I have been regularly frustrated with certain types of reporting in the JSS, especially with regards to applications. Assuming you are comfortable with direct queries of the database, here is a basic one that can report on installed applications. If you use MySQL Workbench, the results can easily be exported as CSV.
In this example, I am querying for the application SPSS, you can change that or leave out the WHERE clause to return all installed applications in your environment.
SELECT DISTINCT a.computer_name AS 'Computer Name', c.application_name AS 'Application Name', c.application_version AS 'Version'
From computers_denormalized a INNER JOIN reports b ON a.computer_id = b.computer_id
INNER JOIN applications c ON b.report_id = c.report_id
WHERE c.application_name LIKE '%SPSS%'
ORDER BY c.application_version, a.computer_name
Hope this helps.
Posted on 03-30-2015 07:17 PM
I have already put a feature request in for increased reporting in JSS.
https://jamfnation.jamfsoftware.com/featureRequest.html?id=3329