Software Update List - MySQL

[sgoetz]

Hey JAMFNationers!

My company is working on building compliance reporting for our upper management and we need to be able to query the MySQL database that JAMF runs on directly.

What we needs is to know where JAMF stores the list of Apple Software Updates (Table name) in MySQL for each client.

If you click on the details for a client in JAMF and than Click on Software Updates you will see a list of Software Updates that are needed for that particular machine. That is the information we need to pull directly from the JAMF Database.

Any help would be awesome!!

Thanks,

Shawn

[RobertHammen]

Take a look at:

https://your.casper.server:8443/apiIntro.rest

and

https://your.casper.server:8443/apiFrontPage.rest

(obviously replace your.casper.server with the URL for your server)

For API documentation/examples. Might answer your question...

[sgoetz]

I've already tried that. It list the servers, but not the updates per client.

[Achilles]

Has there been any solution for this. Im also being asked for a list of machines missing specific apple updates. Theres no extension attribute that will do this?

I cant seem to make a smart group based on clients missing critical updates. I can make one on clients needing more then x amount of updates but those could be just itunes and others not Security updates.
We have a SUS but there doesn't seem to be a way to leverage this using the JSS other then reporting who's on the sus..

Thanks for any help with this.

[bentoms]

You could make an extension attribute.

If could contain the output of ```
softwareupdate --list
```

Then some "grepping" to filter out what you need or just report on all needed updates & then manually generate the reports.