VPP Codes in JSS Dashboard

New Contributor

What does the "Clear VPP Codes" button (under Mobile Devices/apps in JSS Dashboard) do? Does it completely revoke all VPP codes from all devices, uninstall them, or void all of them so they are unusable? we are having trouble with installing iMovie on an iPad through Self Service and we wanted to know what this button did before clicking it.


New Contributor III

Never tried it, but as far as iMovie install goes, if you're still on iOS 6 it's gonna have a hard time redeeming the code since the current version of iMovie requires iOS 7. If you're on iOS 7 already, and you're getting a "that code has already been redeemed" message, run the following command on your Casper server (assuming you're running OS X, these are the commands we use to get in there and fiddle. they were given to me by a nice customer support person at JAMF over the summer)

Don't use the quotes...
0.) open terminal on your JSS server machine
1.) get into MySQL "/usr/local/mysql/bin/mysql -u root -p"
2.) use your database "use jamfsoftware;"
3.) run a command to clear the code already redeemed message filling in the app and the device ID "UPDATE mobile_app_volume_purchase_codes SET mobile_device_id="-1"WHERE mobile_device_id="587"AND mobile_device_app_id="114";" (replace the bolded items with the correct variables from your JSS. Find the device, look at the url. Navigate to the app in your catalog, and look at the URL. 4.) after running that command it should spit out something like "Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0"
5.) open the JSS Database Utility and reboot tomcat. Try redeeming again.

Good Luck.

New Contributor

This is very helpful. Thank you for posting this