Search

Search for words used in entries on this website

Enter the words[s] to search for here:

Sponsors

Audit Collection Services: Change Retention

When you setup Audit Collection Services (ACS) - a part of Operations Manager 2007 - you configure the ACS database. One of the options is how long you want to store the collected data. Unfortunately, there is no easy way to change this. However, there is a table in the ACS database that holds this configuration options. Using the following query, you can specify - afterwards - for how many days ACS should maintain the data:

You can see current config by doing:

USE OperationsManagerAC
SELECT * FROM dtConfig

To update the data retention period:

USE OperationsManagerAC
Update dtConfig
SET Value = -- (number of days to retent data + 1), e.g. to retain 7 days of data, you need to set Value = 8
WHERE Id = 6

Use SQL management studio to execute this query against the ACS database.
Important: please handle this table with care! (Otherwise, ACS will break)

Name:			Remember personal info? Yes No
Email:
URL:
Comment:		Emoticons / Textile
Before sending a comment, you have to correctly answer a simple question you know the answer to. This is a countermeasure against automated spam bots. What are the first four letters of Techlog?     ( Register your username / Log in )
Notify:		Yes, send me email when someone replies.
Hide email:		Yes, hide my email address.
Small print: All html tags except <b> and <i> will be removed from your comment. You can make links by just typing the url or mail-address.