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 Troubleshoot Client software update issues

  One of most important and critically used feature in configuration manager 2012 is  Software updates .It is always challenging and import task for any sccm administrator to achieve good patch compliance success rate within the given SLA(Service level agreement).Patch compliance success rate is depends mainly on heath of your SCCM clients and some times…
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…
SCCM Configmgr 2012 SSRS Patch Compliance Report Per Collection Per Update Group

In order to check the Patch compliance/Deployment status,there are some default reports ,one of the widely used report to know the compliance status for specific Update group on specific collection is –>Compliance 1-Overall Compliance. But the sub report /drill down/Linked report to view the list of non complaint computers do not provide you the required…

This is quick post on how to get list of Applications that are deployed to users requires approval . more Details ,refer https://social.technet.microsoft.com/Forums/en-US/644ff540-4eb0-49b6-97f4-094cada74c6a/viewing-deployments-that-require-approval?forum=configmanagerapps Run the following SQL query to know apps that require Approval. select app.displayname [Application Name],app.manufacturer [Manufacturer],app.numberofdeviceswithapp [No of Devices with this App],app.numberofuserswithrequest [No of Requests] from fn_ListApplicationCIs(1033) app, v_UserTargetedApps uta where uta.ci_id=app.ci_id…