Knowledge Base

SMS: How to Delete Inventory History That Has Accumulated Over Time

Article ID: 196229

Article Last Modified on 10/27/2006

APPLIES TO

This article was previously published under Q196229

SUMMARY

Over time, your SMS database may grow larger and larger because client inventory history is retained. You may not want to keep all this history information, and this article explains how to reduce the amount of information retained by deleting history records that are older than a date you specify.

MORE INFORMATION

Before removing old unneeded history records from the SMS database, you should check to see what the oldest history in the database is. To do this, you can either check the date stamp of the SMS directory, or you can run the following SQL statement: 
select min(timekey) from machinedatahistorytable

Then, after you know the appropriate date, you can perform the following steps:
  1. Open the Systems Management Server Administrator program and then open the Sites window.
  2. On the Edit menu, click Delete Special.
  3. Select Machine History Records, and then specify your date criteria (for example, dated before date or older than xxx days). This way, you can either use a specific cut-off date to determine which records to delete, or specify that records that are older than a certain number of days are to be deleted.

    NOTE: It is a good idea to start by only deleting 20 to 100 days and then increase this number based on performance monitoring.
  4. Run the Systems Management Server Database Manager (Dbclean.exe). To start Database Manager, on the Tools menu, click Delete Unused Common/Specific Records.
For more information, see the SMS Database Maintenance white paper, located at the following Microsoft Web site:

http://www.microsoft.com/technet/sms/


Additional query words: prodsms admin

Keywords: kbdatabase kbinfo kbsmsadmin KB196229


Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.