Category: Reporting Services

Posted on June 28, 2014 by | 4 Comments | 1,890 Views
Its always painful to check via reports for specific application if an assigned application successfully installed for Computer or User ,especially for GSD/helpdesk guys as they are the first point of contact for basic troubleshooting and they cannot always browse to default reports for such information and there is no straight report to give this…
Read more »
SCCM Configmgr 2012 SSRS Dashboard Client Health Summary Report

Posted on May 28, 2014 by | 47 Comments | 9,016 Views
Another Configmgr 2012 SSRS Report that brings Client Health Summary.This time,it will be a dashboard instead normal SSRS report.Dashboard is nice way to display multiple reports into one report.Dashboard reports are very helpful if you want to monitor the information about client health (mainly the Count),client hardware/software,operating system,IE versions etc.You can also link all these…
Read more »
SCCM Configmgr 2012 How to change Custom Data source to Shared Data Source for multiple SSRS reports

Posted on April 29, 2014 by | 2 Comments | 5,652 Views
Background: I had a requirement to not allow others except Configmgr admins to deny access to Configmgr 2012 Console, also to Configmgr SQL Database access (this can be done by revoking access from SSRS_Read Group.If the users are part of this group,they can install SQL and try to connect to configmgr database remotely to run…
Read more »
SCCM Report Applications packages assigned to specific collection with user experience settings

Posted on March 18, 2014 by | 2 Comments | 9,087 Views
Recently there was a question asked in the forum about 'How to get list of applications ,packages assigned to specific collection with its deployment settings like user experience ,Deployment action like install or uninstall etc' . If you are in need of identifying the list of applications or packages deployed to specific collection with its…
Read more »
Configmgr SSRS Report Patch Compliance Statistics Last 30 days

Posted on February 14, 2014 by | 7 Comments | 3,064 Views
Year ago,I created CM07 report to know the patch compliance stats for active patches last 30 days.More info can be found from here.But this report was for configuration manager 2007 which will not work with Configmgr 2012 due to the changes in storing the information in SQL tables/Views. I have created similar report for configuration…
Read more »

Posted on February 11, 2014 by | 10 Comments | 1,805 Views
This is updated post for long ago blogged post http://eskonr.com/2010/04/sccm-reportcollection-for-computers-with-internet-explorer-with-different-versions/. are you in search of getting summary of IE Versions ,so that you can plan for the migration of Old IE Versions to current version ? Below is the SSRS/SQL report which will help you to get count of IE Versions and total. SQL Query…
Read more »
SCCM 2012 SSRS report Site Servers and its assigned boundary information

Posted on December 6, 2013 by | 0 Comments | 1,935 Views
Quick post on the Boundaries and its assigned Site Servers which are nothing but Distribution Points.Simply creating boundaries does not make clients to get connected to DP and download the content. you will have create assign these boundaries to boundary group and boundary group to Site+Content location. Here is report to list all Boundaries and…
Read more »