Take Out the Trash | How to Clear Pending and Failed Commands in Jamf Pro 10

How to Clear Pending and Failed Commands in Jamf Pro 10 via MySQL

Jamf Pro is a powerful MDM tool. The larger your scale, the more you benefit from developing maintenance routines including clearing pending and failed commands. Even though these features are built into JamfPro’s GUI, I still like to execute the queries in MySQL to get feedback on how many commands and/or rows are affected. The path to execute these commands is intentionally left out. If you are unsure where to go, then you probably need to contact support for guidance before proceeding. Also, be sure to have a current backup saved before doing any commands directly in your database. This isn’t something you want to yolo.

View and clear pending commands:

Before clearing or viewing, select the database: use jamfsoftware;

To view Pending:

select count(*) from mobile_device_management_commands where apns_result_status !=’Acknowledged’;

To clear Pending codes:

delete from mobile_device_management_commands where apns_result_status !=’Acknowledged’;

View and clear failed commands:

To view Failed commands:

select count(*) from mobile_device_management_commands where apns_result_status !=’Error’;

To clear Failed codes:

delete from mobile_device_management_commands where apns_result_status !=’Error’;

 

 

MySQL 5.7 Reference Manual Tutorials

To learn about using common queries in MySQL, check out the handy tutorial in the MySQL 5.7 Reference Manual.(click here)

This chapter provides a tutorial introduction to MySQL by showing how to use the mysql client program to create and use a simple database. mysql (sometimes referred to as the “terminal monitor” or just “monitor”) is an interactive program that enables you to connect to a MySQL server, run queries, and view the results.

 

Featured image obtained from Google: https://goo.gl/images/Ba1wJ6

 

Additional Jamf Pro related articles you might find interesting include: 

Starting and Stopping Tomcat in macOS and Linux for Jamf Pro Server

Increase Tomcat Memory for Clustered Jamf Pro Web Apps in Linux

tvOS and iOS Restrictions Allowed by Apple for MDM

Resources for Mobile Device Management

Resources – DeMystifying iOS Deployment in K-12 Edu