This article has been archived. It is offered "as is" and will no longer be updated.
This article describes how to modify the number of days to retain data in the Microsoft Operations Manager (MOM) 2005 Reporting database that is named SystemCenterReporting.
The number of days to retain data in the MOM 2005 database that is named OnePoint can be modified in the Database Grooming properties that are in the Global Settings folder of the MOM 2005 Administrator Console.
However, there is no user interface to modify the number of days that data is retained in the SystemCenterReporting database. By default, the period to retain data in the SystemCenterReporting database is 395 days. For various reasons, the default value of 395 days may have to be changed in some installations.
When you install the MOM 2005 Reporting component, a stored procedure that is named p_updategroomdays is created in the SystemCenterReporting database. You can use this stored procedure to configure the number of days that data is retained in the SystemCenterReporting database.
The syntax of this stored procedure is as follows:
In this example, TableName is one of the six main tables, and DaysToRetainData is the number of days to retain data in that table. The following six main tables in the SystemCenterReporting database represent a different type of data that is collected by MOM 2005:
How to modify the number of days to retain data in the SystemCenterReporting database
To modify the number of days to retain data in the SystemCenterReporting database, follow these steps:
Click Start, point to Programs, point to Microsoft SQL Server, and then click Query Analyzer.
In the SQL Server box, type the name of the Microsoft SQL Server where the SystemCenterReporting database is installed, type the logon credentials, and then click OK.
On the toolbar, click SystemCenterReporting in the list of databases.
In the Query - ServerName - Untitled1 pane, type the following command, click Query, and then click Execute: