Configmgr SSRS SQL Query How to check Client is member of what collections and its Maintenance Window

  This is quick post on How to check Client is member of what collections and display its Maintenance window . Maintenance Window information for collections are stored in view called v_ServiceWindow .Here is the excel spreadsheet that I always make it as reference for any custom queries always help to find right view. http://eskonr.com/2013/10/download-sccm-configmgr-2012-r2-sql-views/ …
SCCM Configmgr How to generate patch compliance report that shows all updates for specific collection ?

There are couple of posts on TechNet blog and other forums asking for ‘Is there any report that list all updates with compliance status for specific collection’ ? Read it once again ,A software update compliance report that list all updates whether Targeted, Installed, Missing for specific Collection. A collection may contain X number of…
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 Collection SSRS report with No SEP client or SEP Client is older version

Rolled out new Symantec endpoint Protection (SEP) Version to clients across all the sites. After few days ,report (All application deployment –Basic)  says ,around 100+ computers still running on old version which did not upgraded to deployed version.Out of these 100+ clients,some of them already have deployed version if I check via resource explorer (also…

Did you ever had difficulties importing, exporting or migrating the reports from Configuration manager 2007  (SSRS ) to Configuration manager 2012 ? If so,how do you migrate reports to Configmgr 2012 ? To get the SSRS Reports from Configmgr 2007 to Configmgr 2012,you will have to download each report (.RDL) manually and upload it your…
SCCM Configmgr 2012 way to find Who Created modified Deleted the collection using SSRS Reports

Quick Post: There was a question on TechNet forum asking,about who created the collection ,More read http://social.technet.microsoft.com/Forums/en-US/e5ea645e-84ec-49ce-82f5-e5d92b0f49a5/details-on-sccm-collection-creation?forum=configmanagergeneral I have seen few cases in Configmgr 2007 and less in Configmgr 2012 due to RBA ,that Configmgr guys will try to do something on collection but it ends at something that causes the resources to disappear from…