Posted on 05-10-2018 10:35 AM
I've been tasked with coming up with a list of our apps that are set to auto update, along with the sync times, so we can better spread out the updates overnight.
Is there a way to generate a report like this from the JSS or will I need to go app by app and check/record the sync time?
Thanks in advance!
Posted on 05-10-2018 08:27 PM
If you are comfortable working in the DB. You should be able to get that info from MySQL. This select statement will get you a list of apps that are set to auto update.
select mobile_device_app_id, app_name from mobile_device_apps where keep_description_and_icon_up_to_date=1 and deleted=0;
There may be a field for update time in the mobile_device_apps table. I will take a look in the AM if you are interested.
Posted on 05-11-2018 01:47 PM
Thanks dude! If you could please look into that field, that'd be awesome! :)
Posted on 05-12-2018 04:22 PM
Sorry, I did not get this yesterday things got busy at work. There is an itunes_sync_time field that gives you the sync time in epoch time. Such as 36300 is 10:05am. Here is a select statement that should get you what you need. If you are using workbench you can export the results to a spreadsheet. Please use with caution and if possible try it out in a test environment first. I hope this helps.
select mobile_device_app_id, app_name, itunes_sync_time from mobile_device_apps where keep_description_and_icon_up_to_date=1 and deleted=0;
Posted on 05-14-2018 06:19 AM
Awesome! Thanks so much, yeah I'll definitely run it in a test environment first.
Posted on 10-19-2018 07:38 AM
Did this work? I'm in need of the same type of thing.