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 =…

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…

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…

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…

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.…

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…

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…

 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…

SELECT b.Netbios_Name0, b.User_Name0, CASE WHEN a.FileVersion LIKE '11.%' THEN 'Office 2003' WHEN a.FileVersion LIKE '12.%' THEN 'Office 2007' WHEN a.FileVersion LIKE '14.%' THEN 'Office 2010' ELSE 'Udda Version' END AS 'Office Version', a.FileName, a.FileVersion, a.FilePath FROM v_GS_SoftwareFile a…

SELECT    COUNT(distinct ResourceID) as [Count],    IP_Subnets0 as Subnet FROM    dbo.v_RA_System_IPSubnets WHERE    IP_Subnets0 NOT IN (SELECT IPSubnet FROM dbo.v_SiteRoamingBoundary_IPSubnet) GROUP BY    IP_Subnets0 ORDER BY    IP_Subnets0