The Microsoft Systems Management Server (SMS) 2003 Administrator Console reports display incorrect data

If you view the software update reports under Reports in the Microsoft Systems Management Server (SMS) 2003 Administrator Console, some reports display incorrect data. For example, reports such as the Software updates for a specific computer report display incorrect data if a software update that applies to an SMS client computer no longer applies. In this example, you install the software update on the SMS client computer so that the software update is no longer applicable.

When this symptom occurs, the status information for the software update is deleted for all client computers when the updated SMS client computer reports inventory.

This problem occurs if the software update status table incorrectly deletes rows from the PatchStatusSummary table in the SMS database. In this case, when specific rows in PatchStatusSummary table no longer apply to a single computer, the rows are deleted. Therefore, the rows in the PatchStatusSummary table have been deleted for all SMS client computers.

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:

Update information

The following file is available for download from the Microsoft Download Center:
Download the SMS2003-Shttp://www.microsoft.com/downloads/details.aspx?FamilyId=4ADDA34D-E61D-4CF1-9968-C0C778AA01BB&displaylang=en-KB900401-X86-ENU.exe package now. (http://www.microsoft.com/downloads/details.aspx?FamilyId=4ADDA34D-E61D-4CF1-9968-C0C778AA01BB&displaylang=en) Release Date: September 12, 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

No prerequisites are required.

Restart requirement

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

Update replacement information

This update does not replace any other software updates.

File information

The English version of this update 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.Note The update that is described in this article is also included in the Microsoft SMS 2003 Inventory Tool for Microsoft Updates. For information about how to download the SMS 2003 Inventory Tool for Microsoft Updates, visit the following Microsoft Web site:

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.

For more information about the standard terminology that is used to describe Microsoft software updates, click the following article number to view the article in the Microsoft Knowledge Base: