SQL:

For a specefic project I was searching to get an overview of all the application supersedence in configMgr. I asked on the ConfigMgr Forum and that got me on the right track. (I was using the wrong relationType number).

I you a searching to get an application supersedence using SQL, you mostly want to focus on the vSMS_AppRelation_Flat. It will contain all the CIID’s of the applications and deployment types that are superseded.

Find below a query that I came up with. It will sum all this information into a single and easy to understand table. It will get the application supersedence of the latest applications that are not Tombstoned and not expired.

 

Comments are of course welcome 🙂

 

#Stéphane