Tags: report

SCCM Configmgr 2012 SSRS Report Content Status with Compliance – Console View

Posted on November 23, 2015 by | 2 Comments | 1,482 Views
This post is an extension to my previous article to view the content status for the applications,packages,driver packages,software updates,windows images using SSRS report instead of Console. Few people contacted me ,if there is way to get the status /Report of all packages on all Distribution points with its compliance % and other information what is…
Read more »
SCCM 2012 SQL Query count updates from Software update groups if they are bigger than hard limit 1000 or not

Posted on November 17, 2015 by | 0 Comments | 2,741 Views
In Configuration manager 2012,the update limit per update-deployment group has been increased (hard limit) to 1000 where was in Configmgr 2007,it was just 500 updates.More information about the hard limit and further questions ,worth reading the blog post by Kevin http://blogs.technet.com/b/server-cloud/archive/2012/02/20/managing-software-updates-in-configuration-manager-2012.aspx The hard limit is --the list of software updates what you see in software…
Read more »
SCCM Configmgr 2012 Report Application Deployment results for specific application for specific OU

Posted on May 11, 2015 by | 40 Comments | 22,776 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 »

Posted on December 18, 2014 by | 3 Comments | 5,962 Views
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…
Read more »
Configmgr 2012 SSRS Report Count Client Versions

Posted on April 1, 2014 by | 4 Comments | 1,749 Views
We have been seeing many hotfixes and Cumulative updates for configmgr 2012 product .For each hotfix /CU level,the client version will get change. As you test and deploy these hotfixes /CU's in your environment ,you are also required to maintain the environment both clients and server client to the same level as your site running.…
Read more »
SCCM Report Applications packages assigned to specific collection with user experience settings

Posted on March 18, 2014 by | 2 Comments | 9,085 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 »

Posted on February 11, 2014 by | 10 Comments | 1,804 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 »