Skip to main content
Question

Reporting installed apps for computer group

  • February 17, 2016
  • 1 reply
  • 0 views

Forum|alt.badge.img+15
  • Valued Contributor
  • 78 replies

I've been asked to pull a report for all apps installed on Macs in our India office. I created a mySQL query which pulls based on computer name, but can't figure out how to clump the data - like apps, computername, and version together (i'm not a mySQL expert - or even close). I can export it to Excel and do it there, but I'm wondering if there is a way to do it directly from the query.

My syntax:
SELECT DISTINCT a.computer_name AS 'ComputerName', 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 a.computer_name LIKE '%MHYD%'
ORDER BY c.application_name, a.computer_name

1 reply

Forum|alt.badge.img+15
  • Contributor
  • 589 replies
  • February 17, 2016

I don't think I'd go to the database to get this info. I agree it's difficult to get out of the web GUI, but have you thought about the API? You should be able to write a script to get the info, then do some sort magic to count things up.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings