If you change the name of an SMS 2003 Advanced Client computer, a resynchronization or a full inventory occurs

If you change the name of a Microsoft Systems Management Server (SMS) 2003 Advanced Client computer, the delta hardware inventory that is subsequently created is rejected. This behavior causes a resynchronization or a full inventory to occur.

Additionally, all inventory history for the previous computer name is removed from the SMS site database.

Note SMS retains current inventory information for the new computer name. SMS removes only the inventory history.

This issue occurs because SMS sends a pragma delete statement in the initial delta inventory record that follows the client computer name change. This behavior is documented in the log information that is included in the "More Information" section.

Service pack information

To resolve this problem, obtain the latest service pack for Systems Management Server 2003. For more information, click the following article number to view the article in the Microsoft Knowledge Base:The hotfix that is described in this article prevents the pragma delete statements for the system architecture group from being processed for a specific client. If a class that contains the old computer name is being updated, the delta hardware inventory may still be rejected. However, a subsequent full inventory is accepted. Inventory history for the previous computer name is retained. If inventory history for a renamed computer was removed before this hotfix was applied, the inventory history is not automatically recovered.

This hotfix should be applied to any primary SMS site, child or parent, that might process inventory data for computers that are renamed.

Download information

The following file is available for download from the Microsoft Download Center:


Download the 903933 package now. (http://www.microsoft.com/downloads/details.aspx?FamilyId=CE42131D-C2A2-4D75-B4D8-2C623DEB9438&displaylang=en)

Release Date: October 3, 2005

For more information about how to download Microsoft support files, click the following article number to view the article in the Microsoft Knowledge Base: Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help prevent any unauthorized changes to the file.

Prerequisites

You must be running SMS 2003 Service Pack 1 to install this hotfix.

Restart requirement

You do not have to restart the computer after you apply this hotfix.

Hotfix replacement information

This hotfix does not replace any other hotfix. However, the following article in the Microsoft Knowledge Base also describes this hotfix:

File information

The English version of this hotfix has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time tool in Control Panel.

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section. This problem was first corrected in Systems Management Server 2003 Service Pack 2.

The following sample output is from the Dataldr.log file on the SMS site server that processes the delta hardware inventory. This output shows the sequence of events that occurs when the delta hardware inventory is processed. This log output has been edited for brevity.