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:
Download these 3 reports .RDL files from TechNet Gallery and Uploaded to yours SSRS report folder. Don't forget to change the Data Source ,to know How refer Garth blog.
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!
14 Comments
I know this is an old article. But wondering if the report is valid for new version of SCCM. Appreciate if you could update the links as the old ones are dead.
hi Bob,
Here is how you can download the samples from Technet Gallery http://eskonr.com/2021/02/did-you-miss-to-download-your-samples-from-technet-gallery-here-is-how-you-can-do-it/
Thanks,
Eswar
Hello Eshwar,
The zip is not working after downloading. May i know if you have the SQl queries for those three reports, it will be helpfull if you share those.
Thank you
Hi,
you can download the technet gallery post using this link http://eskonr.com/2021/02/did-you-miss-to-download-your-samples-from-technet-gallery-here-is-how-you-can-do-it/
Thanks,
Eswar
Excellent Reports thank you Eswar:-). these reports are need of an hour for me today.
Hi,
Glad you found them useful.
Thanks,
Eswar
Eswar - I have imported the RDL reports into SCCM and update the Data Source. I get errors running all 3 reports. But here is the error when running "Applications that are Dependent on Specif App" I cannot run the dataset dependentapp. Any ideas on what might be missing?
An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'dependentapp'. ---> System.Exception: For more information about this error navigate to the report server on the local server machine, or enable remote errors
-------------------------------
Microsoft.ConfigurationManagement.ManagementProvider.SmsException
An error has occurred during report processing.
Stack Trace:
at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ParameterPresenter.GetParameters()
at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ParameterPresenter.LoadParameters(IReport report, Collection`1 navigationParameters, IResultObject resultObject)
at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ReportViewerPresenter.Worker_DoWork(Object sender, DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)
-------------------------------
System.Web.Services.Protocols.SoapException
An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'dependentapp'. ---> System.Exception: For more information about this error navigate to the report server on the local server machine, or enable remote errors
Stack Trace:
at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ParameterPresenter.GetParameters()
at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ParameterPresenter.LoadParameters(IReport report, Collection`1 navigationParameters, IResultObject resultObject)
at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ReportViewerPresenter.Worker_DoWork(Object sender, DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)
-------------------------------
did you put all the reports in same folder ? have you changed the datasource ? can you try to edit the RDL file using report builder or other tool to take the SQL query used in report, run it in SQL server management studio to validate it ?
Eswar,
Thanks for fantastic script.
It seems I can't chose application (it doesn't show any application)
What I'm do wrong?
Thanx for help
which part did not work ? first part to list all apps ? if so,do you have any apps 😉 ?
Thanks Eswar.. I used the views and tried to join the table PkgPrograms_G to get the value for Command line. But when I run the report it displays all of the command lines available. Not sure how to limit it to display the installcommand line used for only the child app.
I have very less knowledge on reporting, please pardon me.
Hi Sameer,
the report list the applications and dependencies .An application can contain multiple deployment types i.e multiple program command lines.so if you want to pull that information into this report,it would be messy and output of the report will differ.
These are very useful reports.. For the second report, how do I include few more columns like Install command, uninstall command, productcode(if it is a MSI) and estimate installation time?
you can have a look at the SCCM SQL views http://gallery.technet.microsoft.com/SCCM-Configmgr-2012-R2-SQL-5fefdd3b for the required information and add to the report using inner join conditions.