Microsoft KB Archive/238762: Difference between revisions

From BetaArchive Wiki
(importing KB archive)
 
(No difference)

Latest revision as of 17:09, 18 July 2020

Knowledge Base


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