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



The information in this article applies to:

  • Microsoft Systems Management Server 2003

SYMPTOMS

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.

CAUSE

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.

RESOLUTION

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:

885643 How to obtain the latest Systems Management Server 2003 service pack

Update information

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

119591 How to obtain Microsoft support files from online services

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.
   Date         Time   Version            Size    File name
   --------------------------------------------------------------
   05-Jun-2005  06:16                        514  Smsconfig.inf
   25-Dec-2003  13:30  2.50.2726.154      40,960  Smsse.dll        
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:

STATUS

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.

MORE INFORMATION

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:

824684 Description of the standard terminology that is used to describe Microsoft software updates


Modification Type:MinorLast Reviewed:4/14/2006
Keywords:kbQFE kbHotfixServer kbfix kbExpertiseInter kbSMS2003spfix kbsms200sp2fix KB900401 kbAudITPRO