SCCM Configmgr 2012 Software update compliant non-compliant results for list of computers from collection for specific month

Few days ago ,I was working on request to get the software update compliance (compliant /Non-Compliant) for list of clients (Desktops or servers) from collection for specific month.I have posted lot of Configmgr 2012 SSRS reports on my blog http://eskonr.com/tag/sccm-patch-reports/about software update compliant but this is something different compared to other reports. Due to the…
SCCM Configmgr 2012 SSRS Report How to check content is used in what task sequences before cleanup using Cascading Parameters

Recently I was doing some content cleanup (mainly for images) in Configmgr 2012 R2 .I have found lot a images for each OS (windows 7,Windows 8 and Windows 8.1) with different versions ,especially for windows 10 .Before I delete ,I was looking for some default report to check if any of these old versions are…
SCCM Configmgr 2012 How to Extract information from XML file stored in SQL DB for application properties

  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…
SCCM Configmgr 2012 Report Application Deployment results for specific application for specific OU

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…
List of SCCM Configmgr Technical Preview Default reports

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…
SCCM 2012 SSRS Report Content Summary With distribution Status

  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…
SCCM Configmgr 2012 SSRS Report Count MS Office Versions

  Recently , I worked on MS Office upgrade project to 2013 and before I take any action on this,I need to identify /get count of all MS Office Versions installed on the computers that are managed by Configuration manager 2012. There is no default Configmgr report that provide you this information ,so you must…