Saturday, July 27

Browsing: SMS 2003

ConfigMgr(SCCM) report for subnets which are undefined

By Eswar KonetiJanuary 19, 3:50 pm SCCM 2007 1 Min Read352 Views

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

Comparison between SMS2003, SCCM 2007 and SCCM 2012 Beta 2

By Eswar KonetiMay 02, 4:40 pm SCCM 2007 1 Min Read429 Views

I started listing down comparative differences between SMS 2003, SCCM 2007 and SCCM 2012 and with the help of Wei…

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

By Eswar KonetiMarch 10, 4:18 pm SCCM 2007 2 Mins Read645 Views

There are many tools like SMS /SCCM or scripting to get list of applications installed on computers(you dont use SMS/SCCM only…

Batch file kickoff of multiple clients requiring HW inventory

By Eswar KonetiNovember 12, 11:28 am SCCM 2007 2 Mins Read521 Views

Having issues with hardware inventory in running on the machines ,there are several tools that does this job like Right…

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

By Eswar KonetiJune 12, 5:10 pm SCCM 2007 1 Min Read11,971 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…

Ports used by SMS 2003

By Eswar KonetiMay 18, 8:15 pm SCCM 2007 2 Mins Read448 Views

Below are some of the ports which are required to be open for proper communication. Port Requirements: -->SMS site server…