Tags: SSRS

SCCM Configmgr 2012 How to Extract information from XML file stored in SQL DB for application properties

Posted on May 21, 2015 by | 11 Comments | 11,210 Views
  Last week,I was working on request to get the application information which includes Application Name ,Deployment Type ,Content location,Command lines (install and uninstall),what type of deployment is it,detection type,user requirement  and other information. Since there are no default reports to get this kind of information ,you must consider writing new SQL/SSRS report else go…
Read more »
SCCM Configmgr 2012 Report Application Deployment results for specific application for specific OU

Posted on May 11, 2015 by | 40 Comments | 22,526 Views
Started rolling out MS office 2013 to Users few weeks ago.For this ,created collection to get computers with MS office 2010 ,created application for MS office 2013 upgrade and deploy to collection .This collection consists of computers from different departments,business units etc. Colleague of mine asked me if there is way to get report for…
Read more »
List of SCCM Configmgr Technical Preview Default reports

Posted on May 7, 2015 by | 0 Comments | 452 Views
Exploring the recently released Configuration manager Tech preview (60 days evolution ) by Microsoft in my lab.It has got some nice features like Management rotation,Auto Client upgrade to collection,OSD and other things. I was looking at reports what has been added extra compared to Configuration manager 2012 R2 CU4 (this my present CM level). Configmgr…
Read more »
SCCM 2012 SSRS Report Content Summary With distribution Status

Posted on May 4, 2015 by | 1 Comment | 1,714 Views
  This week SSRS report is about knowing the count of applications,packages,driver packages,SUP packages,boot images,OS images,Virtual packages etc into Nice Pie Chart also know about the Distribution status of each package . This report has 2 queries inside SSRS 1) for Pie Chart and 2)list the Distribution Status for each package with sorting order. Its…
Read more »
SCCM Configmgr 2012 SSRS Report Overall Compliance Per Update Group Per Collection will help to troubleshoot the clients

Posted on November 26, 2014 by | 1 Comment | 4,297 Views
Over the past few weeks,I posted several patch Compliance reports because ,the default report do not meet the requirements what I need thus ,created custom reports that would help the team to analyze the patch Statistics and troubleshooting non compliant machines. Software update compliance report month Wise: http://eskonr.com/2013/11/sccm-configmgr-2012-patch-compliance-summary-report-month-wise/ Software update Compliance report month Wise for…
Read more »
SCCM Configmgr 2012 Patch Report – OU based Compliance status per Update Group

Posted on November 4, 2014 by | 6 Comments | 10,822 Views
Question asked in the forum ,if it is possible to get patch compliance /deployment status report (installed,required,not applicable and unknown) based on OU for specific software update group instead of collection. Long ago,I posted patch compliance report for specific collection month wise http://eskonr.com/2014/09/configmgr-2012-summary-of-patch-compliance-status-report-month-wise-for-specific-collection-ssrs-report/ but it gives you overall compliance for each month for past 12…
Read more »