Flush all failed MDM logs?

[Sonic84]

I deployed an update to our corporate WiFi profile to all our users and found it would fail on a large chunk of Macs. This caused the "failed" MDM logs in Casper to build up throughout the day. Once failed, the profile would not retry and this left some users with the old payload. The quick fix is to go into each computer record and cancel the failure. However this becomes untenable if the error counts are in the thousands. I think I found a way to "flush" failed MDM logs en masse: If I edit and save the MDM configuration in Casper, click "Distribute to newly assigned devices only" button, the "Failed" logs switch to "Cancelled" and no longer appears under the client inventory record as failed.

Is there a better way?

[jjones]

There is a mysql command that can be ran that will clear out pending/failed commands. However I would highly suggest calling your support contact in doing this, running commands directly to mysql can be very dangerous.

[etippett]

I've wondered about this myself. I've heard that this will be improved in upcoming versions of Casper, but for now, I'm not sure what the best solution is.

[Graeme]

There is a thread on this at https://jamfnation.jamfsoftware.com/discussion.html?id=15497

For mobile devices on our windows server running JSS we run a batch file with the following command:

mysql -u UserName -pPassword jamfsoftware -e"DELETE FROM mobile_device_management_commands WHERE apns_result_status = 'Error';" -v

Computers will be very simular but I cant see offhand which table is involved.
Running this command is something I don't like doing because I want to keep the history but without it deployment wont try again.

Hope this helps
Regards
Graeme