Upgrade Configuration Manager client from SMS 2003

Create a report that counts all client versions. (This is optional, just for information purposes). Report query is: SELECT TOP (100) PERCENT Client_Version0 AS [ConfigMgr client version], COUNT(Client_Version0) AS Total FROM dbo.v_R_System GROUP BY Client_Version0, Client0 HAVING (Client0 = 1) ORDER BY Total DESC, [ConfigMgr client version] Create a collection (“Older Clients” for example) with … 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

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

All the Third-Party Solutions for SCCM & SMS

Web Sites: MyITForum is the premier online destination for IT professionals responsible for managing their corporations’ Microsoft Windows systems; it is especially useful for IT professionals working with Microsoft Systems Management Server. (https://www.myitforum.com) FAQshop endeavors to provide a “one-stop-shop” for systems management questions, answers, and utilities. (https://www.faqshop.com) SMS Alliance is a consortium of companies that … Read more

All the Third-Party Solutions for SCCM & SMS

Web Sites: MyITForum is the premier online destination for IT professionals responsible for managing their corporations’ Microsoft Windows systems; it is especially useful for IT professionals working with Microsoft Systems Management Server. (https://www.myitforum.com) FAQshop endeavors to provide a “one-stop-shop” for systems management questions, answers, and utilities. (https://www.faqshop.com) SMS Alliance is a consortium of companies that … Read more

SCCM Collection / Computer Delete and Delete Special Explanation

  Right clicking on a 'resource' and choosing 'Delete' will delete the resource from the SMS database   Right clicking on a 'Collection' and choosing 'Delete Special' will delete all objects in the Collection from the SMS database.   To restore the entry Again: If the Client software has been installed but the information reflected … Read more

SCCM Duplicate System Entries in the Console

SCCM Duplicate System Entries in the Console If your SCCM console has duplicated System entries in the Console, and you want to find it right? Below is the Query for this issue.   select R.ResourceID,R.ResourceType,R.Name,R.SMSUniqueIdentifier,R.ResourceDomainORWorkgroup,R.Client from SMS_R_System as r full join SMS_R_System as s1 on s1.ResourceId = r.ResourceId full join SMS_R_System as s2 on s2.Name … Read more

SMS/SCCM Command-line Actions – alternate to right click tools ?

SMS/SCCM Command-line Actions We can use WMIC tool to run on remote computers and get the client actions as we want Some examples to trigger SMS/SCCM Client Actions from command line: Disable Software-Distribution:WMIC /namespace:rootccmpolicymachinerequestedconfig path ccm_SoftwareDistributionClientConfig  CREATE ComponentName="Disable SWDist",Enabled="false",LockSettings="TRUE",PolicySource="local",PolicyVersion="1.0" ,SiteSettingsKey="1" /NOINTERACTIVE Re-Activate Software-Distribution:WMIC /namespace:rootccmpolicymachinerequestedconfig path ccm_SoftwareDistributionClientConfig  WHERE ComponentName="Disable SWDist" delete /NOINTERACTIVE Trigger Hardware Inventory:WMIC /namespace:rootccm path … Read more