SMS 2003 and System Center Configuration Manager (ConfigMGR) 2007 Offers below key features

SMS 2003 and System Center Configuration Manager (ConfigMGR) 2007 Offers below key features Systems Management Server (SMS) 2003 provides a comprehensive solution for addressing and resolving your change and configuration needs. SMS 2003 enables you to: • Deliver critical business applications reliably and easily to users in the right place at the right time. • … Read more

Reports: Search keys- SCCM 2007 Search keys in the reports more than %

SCCM 2007 Search keys in the reports more than % We're all familiar with the "%" wildcard, However if you want more search like google…. then.. here are the tipsCheck this out (from the Admin guide): % (percent sign)Any string of zero or more characters. For example:Mo% searches for all names that begin with the … Read more

Custom Error Codes for Configuration Manager 2007

Client Custom Error Codes   Error Code Description CCM_ERRORCODE(0x 80040200) NAMENOTFOUND2147746304 Name not found CCM_ERRORCODE(0x 80040201) BADNAMEFORMAT2147746305 Incorrect name format CCM_ERRORCODE(0x 80040202) SERVICESHUTDOWN2147746306 Service is shutting down CCM_ERRORCODE(0x 80040203) DATAEMPTY2147746307 No data supplied CCM_ERRORCODE(0x 80040204) DATATOOLARGE2147746308 Data too large CCM_ERRORCODE(0x 80040205) INVALIDPATH2147746309 Invalid path CCM_ERRORCODE(0x 80040206) INVALIDFILE2147746310 Invalid file CCM_ERRORCODE(0x 80040207) PARSE2147746311 Parsing error CCM_ERRORCODE(0x … Read more

State Messages in Configuration Manager 2007

Topic Type Description 200 NAP 300 SUM_ASSIGNMENT_COMPLIANCE 301 SUM_ASSIGNMENT_ENFORCEMENT 302 SUM_ASSIGNMENT_EVALUATION 400 SUM_CI_DETECTION 401 SUM_CI_COMPLIANCE 402 SUM_CI_ENFORCEMENT 500 SUM_UPDATE_DETECTION 501 SUM_UPDATE_SOURCE_SCAN 700 RESYNC_STATE_MSG 701 SYSTEM_HEARTBEAT 702 DDM ClientKeyData change 800 CLIENT_DEPLOYMENT 900 BRANCH_DP 1000 CLIENT_FRAMEWORK_COMM 1001 CLIENT_FRAMEWORK_LOCAL 1002 DEVICE_CLIENT_FRAMEWORK_COMM 1003 DEVICE_CLIENT_FRAMEWORK_LOCAL 1004 DEVICE_CLIENT_FRAMEWORK_CERTIFICATE 1100 CLIENT_FRAMEWORK_MODEREADINESS 1500 CAL_TRACK_UT 1501 CAL_TRACK_UL 1502 CAL_TRACK_MT 1503 CAL_TRACK_ML State Messages … Read more

Collection: List of all Virtual machines and their Physical host System Name

List of all Virtual machines and their Physical host System Name     This report lists all the virtual machines and also adds the PhysicalHostName0 property. This tells you the name of the host server the virtual system is sitting on. Here is the report syntax: SELECT distinct SYS.Netbios_Name0, Gvm.PhysicalHostName0, SYS.User_Name0, SYS.Resource_Domain_OR_Workgr0,OPSYS.Caption0 as C054, OPSYS.Version0, … Read more

Software Update Point on a Secondary Site

Software Update Point on a Secondary Site The client computers assigned to secondary sites will automatically be configured to use the software update point at the parent site until an active software update point site system is configured for the secondary site. Creating an active software update point at the secondary site is recommended when … Read more

Feature Comparison of MSDE and SQL Server 2005 Express

Feature Comparison of MSDE and SQL Server 2005 Express While the core database capabilities of MSDE and SQL Server 2005 Express are similar, the set of features and database capabilities of MSDE and SQL Server 2005 Express are different. The following table provides a feature comparison between MSDE and SQL Server 2005 Express. Feature MSDE … Read more

Systems part of what collections?

SELECT v_R_System.Name0, v_Collection.Name FROM v_FullCollectionMembership INNER JOIN v_R_System ON v_FullCollectionMembership.ResourceID = v_R_System.ResourceID INNER JOIN v_Collection ON v_FullCollectionMembership.CollectionID = v_Collection.CollectionID WHERE (v_R_System.Name0 = 'Systemname') for Webbased reports:– Here is the main section: SELECT v_FullCollectionMembership.Name as 'Computer Name', v_Collection.Name as 'Collection Name' FROM v_Collection v_Collection, v_FullCollectionMembership v_FullCollectionMembership WHERE v_FullCollectionMembership.CollectionID = v_Collection.CollectionID AND (v_FullCollectionMembership.Name=@prompt) Here is the "prompt" … Read more