Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/238762

From BetaArchive Wiki
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