Your company's ad could live here and reach over 50,000 people a month!

Share This Post

Removing Old (orphaned) Site Systems from the SMS and ConfigMgr 2007 Database

This method was developed for SMS 2.0 and 2003, but works equally well for Configuration Manager 2007.

  1. Open SQL Enterprise Manager
  2. Open the SMS Database and then go to Tables
  3. Select the Table: “Summarizer_SiteSystem”
  4. Right click on the table and select
    Open Table-Return All Rows
  5. Place a -1 in the Replicate Column for all instances of the specific Servers that no longer exist. 

This will effectively remove the server from the Site Systems Status messages in about 30 minutes.

You can also access and delete old Site Component Servers still found in the registry of the SMS site server under:


Delete the servers that are no longer defined as component servers (that is, not set in the MMC Site Settings/Site Systems as a CAP or DP). Eventually you will then have access to the DELETE function when accessing the entry under Site Settings/Site Systems in the SMS Admin console.

Extra Note: If you are simply wanting to change the status from critical to OK then change the status column for that site system from to 0

Share This Post

Ed is a 9-yr employee at 1E, working  8 of them in the pre-sales role as a Solutions Engineer, and the last as 1E’s Technology Enablement Lead. Working with the Business Development Team. He is also a 13 year Microsoft Enterprise Client Management MVP, multiple Industry Expert invited speaker at the Microsoft Management Summit series, and was a User Group founder and leader for many years. Ed is a founding member of, and still sits as, an Advisory Committee member supporting, the myITForum Systems Management community. He has been known to spend some time behind the wheel of his 475bhp 2010 Camaro, always cruising at or below the posted speed limit at all times of course! Ed, along with his wife MaryAnn and their three dogs are permanent residents of Prudence Island, RI.

Leave a Reply