Has anyone got any pointers on querying my local iTunes database? I've got an original iPad, my daughter has an iPhone and son has an iPod Touch. Over the years there have been lots of inane apps downloaded and installed and I'd like to do some spring cleaning... I would like to be able to see: which apps are installed on which device which apps are not installed on any device when an app was last used and on which device and then I could go and delete those that I no longer want.
Why not just let the kids uninstall what they don't want (assuming the devices are theres of course). If you want to get crazy (but more designed for managing thousands of iOS devices/apps centrally), you could go all out and play around with Apple's iOS management systems for fun. http://www.apple.com/iphone/business/it-center/deployment.html http://www.apple.com/ipad/business/it-center/deployment.html https://itunes.apple.com/us/app/apple-configurator/id434433123?mt=12
That's fine for their devices but on the iPad there are tons of crappy games yet I know they actually play on some of them. Its not a space issue - I just get bugged by the constant update messages for apps that might be obsolete.
I say go crazy and use their enterprise deployment tools... if nothing else, it would be super geeky fun.