Skip to main content
Question

Modify MySQL Field Data in a Table

  • January 3, 2019
  • 1 reply
  • 0 views

Forum|alt.badge.img+4

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.

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

Forum|alt.badge.img+5
  • Contributor
  • 45 replies
  • January 7, 2019

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


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