Microsoft KB Archive/900401

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

Article ID: 900401

Article Last Modified on 10/25/2006

-

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.



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:

Download the SMS2003-Shttp://www.microsoft.com/downloads/details.aspx?FamilyId=4ADDA34D-E61D-4CF1-9968-C0C778AA01BB&amp;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:

http://www.microsoft.com/smserver/downloads/2003/tools/msupdates.mspx



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; 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

Keywords: kbqfe kbhotfixserver kbfix kbexpertiseinter kbsms2003spfix kbsms200sp2fix KB900401

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.