I have had a search on the forum to see if there is a solution to this but haven't found one. Apologies if I'm covering old ground here.
I have looked at reporting and know that I can list ALL applications against a single device. But what I would like to do is simply return a count of how many applications are on a device. We are looking at rolling out windows 10 and I know that our current windows 7 standard build has about 40-45 applications, therefore, if I can list the data and sort it, i will be able to identify the "Quick wins" the devices/applications that will not require a new certification and tinkering for windows 10.
I know that this data should be really easy to extract using SQL queries.. What I don't know is, which tables I should be looking at and how would I formulate the SQL query.
I'd really appreciate a steer here.