SCCM collection that returns all windows XP or Windows 7 machines which has 1 GB of RAM(1024*1024 KB) running with MS office products. select *  from  SMS_R_System inner join SMS_G_System_X86_PC_MEMORY on SMS_G_System_X86_PC_MEMORY.ResourceId = SMS_R_System.ResourceId inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceId = SMS_R_System.ResourceId inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceId = SMS_R_System.ResourceId where SMS_G_System_X86_PC_MEMORY.TotalPhysicalMemory = 1048576 and (SMS_G_System_OPERATING_SYSTEM.Caption =…
ConfigMgr (SCCM) 2012 what’s new in Software updates

Configuration Manager 2012 is introducing a lot of changes in update deployment procedures. Most of the changes are around the "HOW" part while there are some new concepts too. In this post I'll talk about what some of the changes are around: Configuration of Software Updates components Deployment of software updates to endpoints Monitoring and…
ConfigMgr (SCCM) 2012 site Maintenance Tasks

What are the site maintenance task and where are they in ConfigMgr 2012 and how do I configure them ? System Center 2012 Configuration Manager sites and hierarchies require regular maintenance and monitoring to provide services effectively and continuously. Regular maintenance ensures that the hardware, software, and the Configuration Manager database continue to function properly…
Installation of ConfigMgr(SCCM) 2012 RC2

After fixing SQL server Issue with the required patches , I have got installed configMgr 2012 RC2 on my lab after fixing the issue with SQL server 2008 R2 SP1 with CU4. This Guide assumes that you have Domain Controller with DNS,DHCP(Optional) and Member server with server 2008 R2 Operating system. Please go through the TechNet…

Configuration Manager uses site system roles to support management operations at each site. When you install a Configuration Manager site, some site system roles are automatically installed and assigned to the server on which Configuration Manager Setup has run successfully. One of these site system roles is the site server, which you cannot transfer to…

Here is a download for deploying a complete ConfigMgr 2012 RC2 (which was release recently http://eskonr.com/2012/01/configmgr-2012-rc2-released/)  infrastructure in either Hyper-V or VMware: One Domain Controller and one ConfigMgr 2012 RC2 member server – Including pre-requisites like .Net Framework, SQL 2008 R2 SP1 CU4 and IIS - all fully automated. Once configured, the total build time…
How to Fix WMI issues automatically

While Ago I have posted a solution on how to fix WMI(Windows Management Instrumentation) issues using simple batch script that stops WMI service and recompile all MOF files etc. http://eskonr.com/2009/03/how-to-troubleshoot-the-systems-which-has-wmi-issues-rebuild-wmi-repository/ While working with new windows 7 migration project, we had lot of computers with wmi issue but how to identify which has wmi and fix…

 Usually when applications are installed,they wont repot to site server with installed software and its details why because the value that should report to site server is not picked by sms agent by default and you should edit SMS_DEF.MOF file which you find it from your site server installed drive,inbox folder,clifiles,hinv . Below is the…