I think ,this post is going to be one of my Favorite on Configmgr 2012 SSRS report so far i created .Question from smsforum list asking,about if there is any pre-existing report that list all applications and its dependencies.There is none from the default reports(out of 400+) and not sure why Microsoft did not include this kind of report as part of default reports.
If you want to know all dependencies for specific application,you can directly get this from Configmgr 2012 console by right click on the application and choose view relationships——dependency but how to get list of applications that dependent on specific application.
For Ex: Get list of all applications who dependent on Microsoft .net Framework 4.5 or Microsoft Visual C++ 2008 etc.
Before you jump into creation of reports,i would recommend you to read deep technical drive on Application Model and its Internal how they stored in Database by Steve Rachui.
I would like to thank Todd for the original SQL Query that helped me to write this blog post.
So this blog post brings you ,3 different SSRS Reports named 1 ) List all applications and its count of Dependencies and 2) linked report to list Dependencies for Specific Application 3) List all applications that Dependent on specific application
1 )List all applications and its count of Dependencies:
2) List Dependencies for Specific Application
Click on any application that has dependencies ,it will show give you apps list.
For Ex; Interactive 6.2: You can see the parent application folder name where it resides, dependencies and its folders where do they locate.
3) List all applications that Dependent on specific application:
you can also use powershell script to change the Data source for multiple reports at one go instead one by one refer blog post.
Note: When you upload these .rdl files ,make sure 1st and 2nd reports should be in same folder as they both are linked each other.
Hope it Helps!