Has anyone been able to successfully run the management commands to delete pending and or failed commands for computers?

[msnowdon]

Whether I try running it from an individual computer's management tab or try a mass action delete, none of the commands get deleted. It only seems to work on IOS devices for me.

[jwojda]

I was able to run it in 9.97.1488392992 successfully about 2 or so weeks ago.

[bentoms]

@msnowdon We've seen this.

Ask support about:

PI-003158 - Cancel all Pending MDM Failed/Pending does not delete for commands generated for previous MDM user

[schauler]

Create a smart group like "no last updates", then go in the group and choose display, then action and you can also choose to delete all pending and failed commands (on JAMF 10.7).
For me it's working.

[Malcolm]

use jamfsoftware;
DELETE FROM jamfsoftware.mobile_device_app_deployment_queue where current_state!="Managed";
DELETE FROM mobile_device_management_commands where apns_result_status != 'Acknowledged';
quit;

should delete everything pending.
generally recommend backup up before doing so.