SCCM 2007 – Page 30 – All about Microsoft Endpoint Manager

SCCM report to list All advertisements with specific status

Posted on June 12, 2009 by Eswar Koneti | 0 Comments | 805 Views

This report gives you all percentage count with specific status for all advertisement in your environment. In order to get the list of machines where it is advertised with specific status,this report has to be linked to default report i.e 106.It works with SCCM , if you want to run the report in SMS 2003…

SCCM report to list machines where and When RAM changed?

Posted on June 12, 2009 by Eswar Koneti | 0 Comments | 349 Views

This report will list the computers where and When the RAM is changed ? select CS.Name0, CS.UserName0, RAM.TotalPhysicalMemory0, RAM.TimeStamp, HRAM.TotalPhysicalMemory0, Max(HRAM.TimeStamp) from dbo.v_GS_COMPUTER_SYSTEM CS, dbo.v_GS_X86_PC_MEMORY RAM, dbo.v_HS_X86_PC_MEMORY HRAM Where CS.ResourceID = RAM.ResourceID and CS.ResourceID = HRAM.ResourceID and RAM.TotalPhysicalMemory0 != HRAM.TotalPhysicalMemory0 Group by CS.Name0, CS.UserName0, RAM.TotalPhysicalMemory0, RAM.TimeStamp, HRAM.TotalPhysicalMemory0

Ports used by SMS 2003

Posted on May 18, 2009 by Eswar Koneti | 2 Comments | 406 Views

Below are some of the ports which are required to be open for proper communication. Port Requirements: -->SMS site server to Active Directory Service Name UDP TCP LDAP 389 389 LDAP SSL N/A 636 RPC Endpoint Mapper 135 135 Global Catalog LDAP N/A 3268 Global Catalog LDAP SSL N/A 3269 Kerberos 88 88 --> SMS…

How to troubleshoot the systems which has WMI issues ? (Rebuild WMI Repository)

Posted on March 18, 2009 by Eswar Koneti | 16 Comments | 16,045 Views

Had several systems which had wmi issue in doing client /application installation.This is most common issue which we face if something happens to the system.To get solved,use the script which can be run remotely using psexec tool. http://blogs.technet.com/b/configmgrteam/archive/2009/05/08/wmi-troubleshooting-tips.aspx Note : The below script tested only on Windows XP ,not tested on higher versions like Windows…