Fixing iOS icons in Self Service

[GSSRyan]

If anyone had issues recently where icons didn't make it into your app catalog when you added them from VPP, here's a MySQL query that will fix all the broken icon images in Self Service:

UPDATE `mobile_device_apps`
INNER JOIN `vpp_mobile_device_app_license_app` ON `mobile_device_apps`.`itunes_id` = `vpp_mobile_device_app_license_app`.`adam_id`
SET `mobile_device_apps`.`icon_attachment_id` = `vpp_mobile_device_app_license_app`.`icon_id`
WHERE `mobile_device_apps`.`icon_attachment_id` = -1;

[Emmert]

You double posted, but thank you, this is fantastic!

[jss5215]

Hi,

I was just wondering if this process needs to be done after the icon was manually uploaded, or if this process should fetch the icons from iTunes?

We tested one that we manually uploaded, and this seemed to refresh it on Self Service and the icon is there now. However we have far too many apps with no icons to manually upload each.

Thanks.

[GSSRyan]

@jss5215 This was actually to remedy an issue when the auto-VPP-to-catalog feature was first added to JSS. What you’re looking for wouldn’t be difficult using the iTunes api, however. I can help you out once I’m at my computer.