Download SCCM Configmgr V1511 SQL Views documentation

  After the release of Configmgr V1511,really busy setting up the new lab,upgrading the stuff from Configmgr 2012 R2 SP1 to SCCM Configmgr V1511 (In Place) and doing things with it. This post is about,what are the SQL views in SCCM Configmgr V1511 that helps you to write custom SSRS /SQL queries. As you know,there…
Download and Install SCCM Configmgr V1511 RTM available

The latest version of Configuration manager which is V1511 (YY/MM) RTM for December 2015 from Microsoft is now available for download and ready to install to production Environment. We call this version as System Center Configuration Manager current branch (CB) and Microsoft has updated TechNet documentation on December 8 (Yesterday) for this version .The documentation…
SCCM Configmgr 2012 SSRS Report Content Status with Compliance – Console View

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…
SCCM 2012 SQL Query count updates from Software update groups if they are bigger than hard limit 1000 or not

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…
sccm 2012 SQL Query Get software updates that are downloaded but not in any software update group

Software update groups in Configmgr 2012 simplifies lot of administrative work ,which simply  contains list of updates (must be downloaded before you add any updates) merged to single deployment (can have multiple deployments for single software update group). Coming to the subject line, It is necessary (during cleanup activity) to find software updates that are…
SCCM Configmgr 2012 Create device collection using the User Department attribute

  Recently ,I have got a request from the business unit manager on the reboot of computers due to patch management (applicable to Applications as well) .The Custom client device setting ‘ Display temporary notification to the user ' (shown below) set with 480 minutes across the enterprise workstations but specific department (ex: Engineering), not…
Download and Install SCCM Configmgr Vnext Technical Preview 4

  Microsoft released Technical preview 4 (TP4) for Configmgr Vnext ( System Center Configuration Manager and Endpoint Protection ) .The previous technical preview was Technical preview 3 with updated version 1510 (YYMM). Microsoft haven’t updated the TechNet documentation with capabilities available with this release (TP4) for now but soon to be updated here on https://technet.microsoft.com/library/dn965439.aspx.…
SCCM CMtrace tool corrupt error message The file either does not exist or could not be accessed.Do you want to continue anyway

  Few days ago,I had an issue while reading log files using Configmgr CMTrace tool.I tried opening the .log file to read the content but it failed to display the content and instead,it keep prompting me error message ‘The file either does not exist or could not be accessed.Do you want to continue anyway’. for…