Update: SSRS Report for Configuration manager 2012 (all Versions) is available on http://eskonr.com/2014/02/configmgr-ssrs-report-patch-compliance-statistics-last-30-days/ In my previous blogs,I posted couple of reports for Patch compliance status based on the KB/MS ID numbers . SCCM Patch Compliance Progress report:  http://eskonr.com/2009/10/patch-status-compliancesoftware-updates-report-in-sms-sccm/ Software Update Compliance Status on…

When you deploy software updates using SCCM/configmgr to clients ,patch status will be sent back to SCCM site.It is always good to know the Last state ID's and its state names for custom reporting. Below are the available Last state ID's…

  Collection to check if any of Primary or Secondary site not installed with SUP Role or any other Role? select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System where SMS_R_System.SystemRoles like "SMS Site System" and SMS_R_System.ResourceId not in (select ResourceID  from  SMS_R_System where SMS_R_System.SystemRoles…

  Getting Active Directory computer information into SCCM Database can be done by configuring Active Directory discovery Methods in SCCM Configmgr but there are cases, wherein some of the computers may not be discovered or Computers do not exist in…

Another interesting package replication problem.John Marcum posted solution on his blog with DB edit but that did not solve my problem though package issue is similar. I have to do couple of more things to fix the issue what John…

Recently I had major issue while replicating the patch packages to sites and they started experiencing the problem to process the patch information (CID and SDMpackages). I am really not sure if this is because of recent MS patch released…

SCCM report for Domain Controllers with RAM,Operating System,IP Address etc. Full Details : http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/0dedf567-7bbd-4c36-bc7a-12c409a79618 SELECT       sys.Name0 AS 'System Name',       os.Caption0 AS 'Operating System',       os.CSDVersion0 AS 'Service Pack',       PM.TotalPhysicalMemory0 /1024 as 'RAM in MB',       OS.InstallDate0 AS…

In My Previous post , we get to connect Resource Explorer of Computer without Using SCCM Console in SCCM 2007.http://eskonr.com/2012/12/sccm-configmgr-2007-open-resource-explorer-without-sccm-console/ You can use the same script for sccm 2012 but with littlie changes to the folder names and File names.…

I have seen this question asked and answered in some articles and blog posts, however, after teaching the Concepts and Admin Workshop for the new version of the product recently, and getting more familiar with the new Endpoint Protection feature…

  Connecting to Resource Explorer of Computer is always not good(takes time) to Search for computer in SCCM collection and move further.Some times you may not find the computer in the collection where you are looking at then you comeback…