AnsweredAssumed Answered

Snow Inventory SQL query

Question asked by Snow-good on Jan 23, 2019
Latest reply on Jan 24, 2019 by Snow-good

Hello all.


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.