DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 900401 - Last Review: October 25, 2006 - Revision: 3.5

On This Page

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  (http://support.microsoft.com/kb/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:
Collapse this imageExpand this image
Download
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:
119591  (http://support.microsoft.com/kb/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://technet.microsoft.com/en-us/sms/bb676783.aspx (http://technet.microsoft.com/en-us/sms/bb676783.aspx)

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  (http://support.microsoft.com/kb/824684/ ) Description of the standard terminology that is used to describe Microsoft software updates

APPLIES TO
  • Microsoft Systems Management Server 2003
Keywords: 
atdownload kbqfe kbfix kbexpertiseinter kbsms2003spfix kbsms200sp2fix KB900401
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support