Modify MySQL Field Data in a Table

iPad_Sheriff
New Contributor III

Hello. Is there a way to view/edit an app record in the catalog through MySQL? Specifically, I want to uncheck the box in the app records that forces app updates from all the apps in the catalog where it shows up.d8fa66302c924bbcac7dd3e755482ed4

Does anyone know what that field is called?

mysql> describe mobile_device_apps;
-----------------------------------------------------------------------------------------
| Field | Type | Null | Key | Default | Extra |
-----------------------------------------------------------------------------------------
| mobile_device_app_id | int(11) | NO | PRI | NULL | auto_increment |
| app_name | varchar(255) | NO | | | |
| description | longtext | YES | | NULL | |
| bundle_id | varchar(255) | NO | MUL | | |
| current_version | varchar(255) | NO | | | |
| category_id | int(11) | NO | | -1 | |
| icon_attachment_id | int(11) | NO | | -1 | |
| provisioning_profile_id | int(11) | NO | | -1 | |
| itunes_store_url | varchar(2083) | NO | | | |
| all_mobile_devices | tinyint(1) | NO | | 0 | |
| deployed_via_self_service | tinyint(1) | NO | | 1 | |
| deploy_as_managed_app | tinyint(1) | NO | | 1 | |
| remove_app_when_mdm_profile_removed | tinyint(1) | NO | | 0 | |
| prevent_backup_of_app_data | tinyint(1) | NO | | 0 | |
| is_free | tinyint(1) | NO | | 1 | |
| hosting_location | tinyint(1) | NO | | 0 | |
| external_url | varchar(255) | NO | | | |
| itunes_id | varchar(255) | NO | | | |
| deleted | tinyint(1) | NO | | 0 | |
| ipa_name | varchar(255) | NO | | | |
| md5 | varchar(255) | NO | | | |
| per_app_vpn_name | varchar(255) | NO | | None | |
| per_app_vpn_uuid | varchar(255) | NO | | -1 | |
| featured | tinyint(1) | NO | | 0 | |
| keep_description_and_icon_up_to_date | tinyint(1) | NO | | 0 | |
| itunes_sync_time | int(11) | NO | | 0 | |
| itunes_region | varchar(2) | NO | | US | |
| vpp_admin_account_id | int(11) | NO | | -1 | |
| assign_vpp_device_based_licenses | tinyint(1) | NO | | 0 | |
| take_over_management | tinyint(1) | NO | | 0 | |
| available_after_install | tinyint(1) | NO | | 1 | |
| require_network_tethered | tinyint(1) | NO | | 0 | |
| available_in_appstore | tinyint(1) | NO | | 1 | |
| enabled | tinyint(1) | NO | | 1 | |
| keep_app_updated_on_devices | tinyint(1) | NO | | 0 | |
-----------------------------------------------------------------------------------------+
35 rows in set (0.01 sec)

1 REPLY 1

LRZ_Jamf
Contributor

To display a single record use: (123 being the ID you can see in the URL in your Browser)

SELECT * FROM mobile_device_apps WHERE mobile_device_app_id = 123;

To display all records use:

SELECT * FROM mobile_device_apps;

To disable it for a single record use: (123 being the ID you can see in the URL in your Browser)

UPDATE mobile_device_apps SET keep_app_updated_on_devices = 0 WHERE mobile_device_app_id = 123;

To disable it for all records use:

UPDATE mobile_device_apps SET keep_app_updated_on_devices = 0;

To enable it for a single record use: (123 being the ID you can see in the URL in your Browser)

UPDATE mobile_device_apps SET keep_app_updated_on_devices = 1 WHERE mobile_device_app_id = 123;

To enable it for all records use:

UPDATE mobile_device_apps SET keep_app_updated_on_devices = 1;

I'm sure this isn't supported by jamf, so you better call jamf support. I'd issue this, while jamfPro isn't running (= Tomcat Service is stopped)

Cheers,
lrz/bofh