SMS 2003 – All about Microsoft Endpoint Manager

ConfigMgr(SCCM) report for subnets which are undefined

Posted on January 19, 2012 by Eswar Koneti | 0 Comments | 329 Views

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

Comparison between SMS2003, SCCM 2007 and SCCM 2012 Beta 2

Posted on May 2, 2011 by Eswar Koneti | 2 Comments | 408 Views

I started listing down comparative differences between SMS 2003, SCCM 2007 and SCCM 2012 and with the help of Wei King to finish off the list, here is what we came up with Via http://www.myitforum.com/myITToolbar/frame-click.asp?url=http://mymomexperience.blogspot.com/2011/04/comparing-sms2003-sccm-2007-and-sccm.html

VBscript to get list of add remove progams with product code install date

Posted on March 10, 2010 by Eswar Koneti | 2 Comments | 566 Views

There are many tools like SMS /SCCM or scripting to get list of applications installed on computers(you dont use SMS/SCCM only for this kind of information 🙂 ) but what if the clients are not reported back to site server for some other reason and there could lot of applications installed on computers then you will start troubleshooting the…

Batch file kickoff of multiple clients requiring HW inventory

Posted on November 12, 2009 by Eswar Koneti | 0 Comments | 455 Views

Having issues with hardware inventory in running on the machines ,there are several tools that does this job like Right click tools ,SMS collection commander from Zander and can use batch script given below. 1.Cretea a folder called Temp in C drive. 2.Crete a new notepad file ,add list of computers that you want to kick…

SCCM Report for computers with service status (started,stopped,disabled)

Posted on June 12, 2009 by Eswar Koneti | 7 Comments | 11,130 Views

select Distinct CS.Name0, SER.Displayname0, SER.Started0, SER.StartMode0, SER.State0 from dbo.v_GS_COMPUTER_SYSTEM CS, dbo.v_GS_SERVICE SER, dbo.v_FullCollectionMembership FCM where CS.ResourceId = SER.ResourceID and CS.ResourceId = FCM.ResourceID and SER.displayname0 like ‘%firewall%’ and (SER.State0 != ‘Running’ or Isnull(SER.State0,”)=”) and FCM.CollectionID = ‘SMS00001′

Ports used by SMS 2003

Posted on May 18, 2009 by Eswar Koneti | 2 Comments | 414 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…