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 and State Names. These state IDs do exist in SQL View called v_GS_PatchStatusEx .   LastState LastStateName…

  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 like "SMS Software Update Point") Collection can be modified to check if any of the…
How to get AD computer info into SCCM Configmgr 2007/2012 Database ?

Getting Active Directory 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 AD but do available in SCCM Database. I used MaikKoster Old blog post as reference and made some customization's/Updates…
SCCM Configmgr Failed to insert SMS Package because SDM Type Content is not present in the CI_Contents table. Will try later

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 in October 2012,More info can be found here  ,due to this,all the revised updates (which…

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 'Original OS Install Date',       os.LastBootUpTime0 AS 'Last Boot Time',       NAC.IPAddress0 AS 'IP Address',…

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. Here is the Batch script to connect to resource Explorer of Client Computer in SCCM…
#SCCM / #Configmgr 2012 Antivirus Exclusions End Point Protection

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 in System Center 2012 Configuration Manager, and I discoverd a feature in Endpoint Protection that…