Microsoft KB Archive/238762

= SMS: Software Inventory Creation Date Is Incorrect in SMS Database =

Article ID: 238762

Article Last Modified on 10/25/2006

-

APPLIES TO


 * Microsoft Systems Management Server 2.0 Standard Edition

-



This article was previously published under Q238762



SUMMARY
Systems Management Server (SMS) Resource Explorer may display a created date for an inventoried file that is different from the created date listed in the file's properties in Windows Explorer. This problem occurs for two reasons:
 * The software inventory agent (sinv) did not use the file Creation Date as a key property. Therefore on a single client, files with the same name but with different created time stamps, were treated as the same and were not reported separately.
 * The stored procedure (sp_SoftwareInventory) that inserts software inventory information into the SMS database also did not use Creation Date as a key property. As a result, the time stamp that became associated with the file was simply the time stamp of the last reported instance across all clients.



MORE INFORMATION
Microsoft has confirmed this to be a problem in Systems Management Server version 2.0 This problem was first corrected in Systems Management Server version 2.0 Service Pack 2..

Additional query words: prodsms sinv sinvproc

Keywords: kbbug kbfix kbinfo kbinventory kbqfe kbsms200sp2fix KB238762

-

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

© Microsoft Corporation. All rights reserved.