Home > SCCM 2007 / 2012 > SCCM 2007: Remove obsolete PXE service point from ‘component status’

SCCM 2007: Remove obsolete PXE service point from ‘component status’

Recently I had an issue with a PXE service point which was always coming back in the component status with status critical. The component was already removed from the Site Systems and also from the registry but It didn’t want to go away from the Component Status.

CriticalPXEComponent

Firstly I tried to remove it by deleting the failed status records via an SQL query described in the following blog: http://oleskovgaard.blogspot.be/2011/10/eliminated-distribution-points-still.html

But it kept coming back after a while.

The solution here is to modify the record in the Summarizer_SiteSystem table.

  • Open the SQL Server Management Studio
  • Open the SCCM Database
  • Open the Tables
  • Right click on the table dbo.Summarizer_SiteSystem & select open table.
  • Change the Replicate value to -1 for the failing PXE Site System by right clicking the row.
  • Close the SQL Server Management Studio and wait for one hour. The failed PXE Service point will be disappeared from the Component Status.

Summarizer_SiteSystemTable

Please note that this is not supported by Microsoft and make sure that you have a proper backup before modifying the SQL Database.

 

Advertisements
Categories: SCCM 2007 / 2012
  1. June 11, 2013 at 10:39 am

    thanks this really helped me alot

  2. June 13, 2013 at 9:39 am

    hi.. I have checked today and these record come up again and replication value is also changed to 0.. what can be the issue ???

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: