DOCUMENT:Q303417 02-AUG-2001 [sms] TITLE :SMS: Software_Inventory Table Grows to Very Large Size PRODUCT :Microsoft Systems Management Server PROD/VER::2.0 OPER/SYS: KEYWORDS:kbtool kbsms200 ====================================================================== ------------------------------------------------------------------------------- The information in this article applies to: - Microsoft Systems Management Server version 2.0 ------------------------------------------------------------------------------- SYMPTOMS ======== If multiple files with the same file name are found during a software inventory scan, these files are not necessarily treated as unique. Because of this, only a single instance of the file is reported with a creation date that corresponds to the last file found during the scan. This problem was initially reported and resolved prior to Systems Management Server (SMS) 2.0 Service Pack 2 (SP2). The fix was included with the client hotfix bundle for SMS 2.0 Service Pack 1 (SP1) as described in the following Microsoft Knowledge Base article: Q238762 SMS: Software Inventory Creation Date Is Incorrect in SMS Database MORE INFORMATION ================ After the fix for this issue was deployed, reports of using this fix in production indicated scalability concerns because of the software inventory database table growing excessively large. The problems that were created by the software inventory table growing to excessive size included delays in loading software inventory, delays processing software inventory queries, and so on. Because of scalability concerns, this fix was removed prior to the release of SMS 2.0 SP2. Because of this, for installations of SMS 2.0 SP2 or later (of those installations that are still running SMS 2.0 SP1 but without the client hotfix bundle installed), the misreporting of the file creation date for those files with the same name is to be expected. Additional query words: prodsms ====================================================================== Keywords : kbtool kbsms200 Technology : kbSMSSearch kbSMS200 Version : :2.0 Issue type : kbprb ============================================================================= THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY. Copyright Microsoft Corporation 2001.