Device with thousands of failed commands

[brownbe]

One of our devices has over 4,000 failed commands on it and I have to clear them without wiping the device. I've previously deleted a device from JAMF and reenrolled it by wiping the device, but that isn't an option here (it has student work on it). Is there anything that can be done?

[davidacland]

I think you can clear them out directly in the MySQL DB. I don't have access to the command at the moment but if you ask your JAMF support contact they will be able to help.

[brownbe]

I have heard that as well and when I spoke to our rep he wasn't sure of it either. Also, I am still a relatively new employee so I do not have direct access to the database. Is there a way within JAMF itself?

[davidacland]

I've had the problem a few times and its always been a command run on the mysql database.

If the JAMF support person your speaking to isn't sure I would ask if they can escalate it to someone else. They've told me how to do it in the past.

I could be wrong but I don't think there is a way in the JSS.

[brj]

Try this command within MySQL:-

delete from mobile_device_management_commands where apns_result_status != 'Acknowledged';