Posted on 10-13-2020 09:11 PM
I am trying to create a report to show vendor based with applications that we purchased (For Licensing purposes ). e.g: Microsoft: Outlook, Word, Excel, Powerpoint......
tried to use Search Inventory and Application Title but didn't get any results e.g: Application Title Adobe.
So I really appreciate if someone suggest some other way (scripting or something to get this going.
My aim is to see what applications I deployed through Jamf and from who (Vendor) to reporting purposes. I like to generate a report with following cells:
Vendor: Applications Name:
Number of installations
Computer Name (Tag)
Posted on 10-14-2020 04:52 AM
@raghdasi We were using the following SQL queries before our ServiceNow integration more than two years ago; they most likely need to be updated for schema changes (for which you should reach out to Jamf Support).
SELECT computers_denormalized.computer_name, computers_denormalized.computer_id, computers_denormalized.serial_number, computers_denormalized.email, application_details.version FROM computers_denormalized JOIN applications ON computers_denormalized.last_report_id = applications.report_id JOIN application_details ON applications.application_details_id = application_details.id ORDER BY application_details.version INTO OUTFILE '/var/lib/mysql-files/JamfProProductionApplications-`date '+%Y-%m-%d-%H%M%S'`.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY ' ';
SELECT DISTINCT a.computer_name AS 'Computer Name', a.username AS 'User Name', a.department_name AS 'Department', c.application_name AS 'Application Name', c.application_version AS 'Version' INTO OUTFILE ''/var/lib/mysql-files/Adobe_Apps-`date '+%Y-%m-%d-%H%M%S'`.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '' ESCAPED BY '\' LINES TERMINATED BY ' ' 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 '%Adobe%' ORDER BY a.computer_name, c.application_name, c.application_version #LIMIT 20 ;