Skip to main content
Question

Software Update List - MySQL

S
Forum|alt.badge.img+7

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

    4 replies

    RobertHammen
    Forum|alt.badge.img+28
    • RobertHammen
    • Esteemed Contributor
    • 1027 replies
    • August 20, 2013

    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...

    S
    Forum|alt.badge.img+7
    • sgoetz
    • Author
    • Contributor
    • 97 replies
    • August 20, 2013

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

    Achilles
    Forum|alt.badge.img+2
    • Achilles
    • New Contributor
    • 14 replies
    • September 13, 2013

    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
    Forum|alt.badge.img+35
    • bentoms
    • Legendary Contributor
    • 4331 replies
    • September 13, 2013

    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.

    Reply


    Most helpful members this week

    Terms & ConditionsCookie settingsAccessibility statement

    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