• Home
  • Our Services
  • Presentations
  • About me
  • Links
  • Contact Us
  • Privacy Policy

Cloud and Datacenter Management

Cloud at your fingertips
  • Home
  • Our Services
  • Presentations
  • About me
  • Links
  • Contact Us
  • Privacy Policy
Home  /  SystemCenter • Uncategorized  /  Changing the ACS DataRetention Period for Opsmgr
19 September 2008

Changing the ACS DataRetention Period for Opsmgr

Written by alexandre@verkinderen.com
SystemCenter, Uncategorized acs, audit collection service, Operations Manager 2007, opsmgr, scom 4 Comments

Changing the Audit Collection Service DataRetention Period (based on the info found on the technet site)

Operations Manager grooms, or removes, data from its various databases at regular configurable intervals. For the Operations database, this is done in the Operations console. For the ACS database, these settings are configured during setup with a default value of 14 days. This means that every day, all database partitions (and their data) that are older than 14 days are dropped or deleted. Because of the volume of data that ACS can accumulate, 14 days is not an unreasonable setting. However, some companies might need to retain data for longer periods and they must have already planned for that when making the sizing and performance calculations for their environment. You can change the retention period for the ACS data by following this procedure.

To Change the ACS Data- Retention Period

1. Log on to the computer running SQL Server that hosts the ACS database with an account that has administrative rights to the ACS database.

2. Open the SQL Server Management Studio tool, and connect to the database engine.

3. Expand the Databases folder, and select the OperationsManagerAC database.

4. Right-click to open the context menu and select New Query….

5. Run the following query to see what your retention period is: SELECT * FROM dtConfig

clip_image002

Look for row 6. The result contains the days to retain + 1

6. In the Query pane, type the following, where number of days to retain data + 1 equals the number of days you want to pass before data that has aged past that point is deleted. For example, if you want to retain data for 30 days, type 31

USE OperationsManagerAC UPDATE dtConfig SET Value = <number of days to retain data + 1> WHERE Id = 6 and then click the Execute button on the toolbar. This will run the query and then open the Messages pane, which should read (1 row(s) affected).

clip_image004

7. To view the new setting, delete the previous query text from the Query pane and enter SELECT * FROM dtConfig. This will open the Results pane below the Query pane.

8. Look at the value in the sixth row; it should now equal the value you entered for <number of days to retain data + 1>.

9. Restart the Operations Manager Audit Collection Service for this to take effect.

 

Greetz,

Alkin

http://scug.be/blogs

 

Tags van Technorati: opsmgr,acs,scom,audit collection service

Related

Share On
Share on Facebook
Share on Twitter
Share on Google+
Share on LinkedIn
alexandre@verkinderen.com

 Previous Article Operations Manager/SSAS and PerformancePoint Scorecards
Next Article   Security Auditing & ACS Optimization Session recording

Related Posts

  • OpsMgr agents not showing up in pending management

    29/03/2015
  • Part 1: Bulk import server locations with PowerShell

    24/03/2014
  • Install OpsMgr Agent-less remotely with Powershell

    02/01/2014

4 Comments

  1. tennisville Reply to tennisville
    22/01/2009 at 9:16 pm

    Does anyone know if changing data retention period could create db corruption or db reset or db information erased ?

    Regards
    marie-anne

  2. tennisville Reply to tennisville
    22/01/2009 at 9:16 pm

    Does anyone know if changing data retention period could create db corruption or db reset or db information erased ?

    Regards
    marie-anne

  3. Pingback: Service Manager & Operations Manager DB Retention Periods « Simon's Lab
  4. Pingback: Service Manager & Operations Manager DB Retention Periods « Simon's Lab

Leave a Reply Cancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Recent Posts

  • Azure API Management Consumption Tier
  • Real Time Twitter sentiment analysis with Azure Cognitive Services
  • Move Managed Disks to another subscription
  • Download MSIgnite 2018 slides
  • Azure Files Updates from Ignite

Twitter

Goodreads

Tags

acs Advisor Agent Agents audit collection service azure Azure Cloud community cubesys end to end monitoring Essentials Events General hotfix HP Issue KB Management Pack manuals MVP Opalis Operations Manager 2007 Opmsgr 2007 R2 opsmgr opsmgr 2012 Opsmgr DB opsmgr R2 Performance powershell R2 reporting SCCM scom SCSM SCVMM service level dashboard Service Manager sql system center teched Uncategorized WAP web application monitoring Windows 2008

Categories

  • Azure
  • IOT
  • it camps
  • MAS
  • OMS
  • Powershell
  • Sharepoint
  • SystemCenter
  • Technet
  • Uncategorized
  • WAP
  • Windows 8

Archives

  • January 2019
  • November 2018
  • October 2018
  • September 2018
  • January 2018
  • December 2017
  • November 2017
  • September 2017
  • June 2017
  • May 2017
  • April 2017
  • March 2017
  • February 2017
  • January 2017
  • November 2016
  • October 2016
  • September 2016
  • July 2016
  • June 2016
  • January 2016
  • December 2015
  • November 2015
  • May 2015
  • April 2015
  • March 2015
  • February 2015
  • January 2015
  • December 2014
  • March 2014
  • January 2014
  • December 2013
  • November 2013
  • May 2013
  • April 2013
  • March 2013
  • February 2013
  • November 2012
  • June 2011
  • May 2011
  • April 2011
  • January 2011
  • December 2010
  • November 2010
  • October 2010
  • September 2010
  • July 2010
  • May 2010
  • April 2010
  • March 2010
  • February 2010
  • January 2010
  • December 2009
  • November 2009
  • October 2009
  • September 2009
  • July 2009
  • June 2009
  • May 2009
  • April 2009
  • March 2009
  • February 2009
  • January 2009
  • November 2008
  • October 2008
  • September 2008
  • August 2008
  • July 2008
  • June 2008
  • May 2008
  • March 2008
  • February 2008
  • January 2008
  • December 2007
  • November 2007
  • October 2007
© Copyright 2017. Alexandre Verkinderen