Skip to main content
Question

mysql command line to clear out pending/failed jss Computer commands


Forum|alt.badge.img+5

I have a rogue Remove Profile command that is being sent out to all our macbooks, but all of them are currently turned off. So before any of them are turned on, I need to know what the MySQL command is to clear out all of the pending/failed Computer commands in the JSS. I've reached out to my Support but since its the weekend, I couldn't get anyone. If any Users know what it is and are willing to post it that would be awesome.

9 replies

Forum|alt.badge.img+18
  • Honored Contributor
  • 486 replies
  • August 17, 2015

JAMF doesn't mind us messing around with the JSS, customizing it how we want, Messing around with the Self Service APP etc. But when it comes to the MYSQL database, thats where things get real dangerous. Your best bet is to wait for them to get back to you.

  • RD

bpavlov
Forum|alt.badge.img+18
  • Esteemed Contributor
  • 1206 replies
  • August 17, 2015

I know it won't help you right now, but please take the time to up vote these two feature requests so that something like this could easily be done without having to go into the database:

https://jamfnation.jamfsoftware.com/featureRequest.html?id=3619
https://jamfnation.jamfsoftware.com/featureRequest.html?id=3619


Forum|alt.badge.img+18
  • Honored Contributor
  • 486 replies
  • August 17, 2015

@bpavlov I already voted on those :)


Forum|alt.badge.img+5
  • Author
  • Contributor
  • 20 replies
  • August 17, 2015

I would like to say that their support got back to me mid morning Sunday and got the script we needed to us. Left them a voice mail, and was lucky enough to have my phone call returned within the hour. I wasn't expecting that type of turnaround, but have continuously been pleasantly surprised by Jamf's support service.


Forum|alt.badge.img+18
  • Honored Contributor
  • 645 replies
  • August 17, 2015

Here is what I got from JAMF when I pinged them with this question:

To view and clear pending commands:

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

elect 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';

I would definitely test these out in your dev environment first. They worked well for me!


Forum|alt.badge.img+7
  • New Contributor
  • 9 replies
  • September 18, 2015

If i'm not mistaken the command

delete from mobile_device_management_commands where apns_result_status != 'Acknowledged’;

Clears out Everything....Pending and Failed.

**There is a separate script if your just wanting to wipe out your Failed Commands.....

delete from mobile_device_management_commands where apns_result_status = 'Error';


Forum|alt.badge.img+8
  • Contributor
  • 56 replies
  • February 12, 2016

I am having issues with a ton of iPads not connecting back to JSS. The solution seems to be deleting the pending and failed commands, and sending a blank push. Has anyone ran this mysql command on the latest version of JSS? I just want to make sure before I nuke my database.

Thanks!


Forum|alt.badge.img+4
  • Contributor
  • 22 replies
  • March 8, 2016

@andy.cauble Can you please post the script? Also, are you running these on the MYSQL or JSS?


Forum|alt.badge.img+5
  • Author
  • Contributor
  • 20 replies
  • March 14, 2016

@cruess like @rderewianko said above. When a user is inserting, updating or deleting using MYSQL, its best that they go through their technical Account Manager. That was the same response I got from our technical account manager too.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings