Hello there, How do you view and configure the SCOM 2007 R2 Datawarehouse database retention policy? I know this tool can be used for SP1: http://blogs.technet.com/b/momteam/archive/2008/05/14/data-warehouse-data-retention-policy-dwdatarp-exe.aspx Regards, Chris

Hi Chris The utility you mention works fine with R2 as well. If your prefer SQL to view data, then Kevin Holman has more infor here: http://blogs.technet.com/b/kevinholman/archive/2010/01/05/understanding-and-modifying-data-warehouse-retention-and-grooming.aspx Cheers GrahamView OpsMgr tips and tricks at http://systemcentersolutions.wordpress.com/

Here's a SQL query that will show the DW retention/grooming settings. http://blogs.technet.com/b/jonathanalmquist/archive/2009/11/28/dw-retention-and-groom-settings.aspx /*Data Warehouse retention settings*/ USE OperationsManagerDW SELECT Dataset.DatasetDefaultName AS Dataset, StandardDatasetAggregation.MaxDataAgeDays AS Days, CASE StandardDatasetAggregation.AggregationTypeId WHEN 0 THEN 'Raw' WHEN 20 THEN 'Hourly' WHEN 30 THEN 'Daily' ELSE 'Unknown' END AS Type, StandardDatasetAggregation.AggregationIntervalDurationMinutes AS AggInterval, StandardDatasetAggregation.GroomingIntervalMinutes AS GroomInterval, StandardDatasetAggregation.MaxRowsToGroom, StandardDatasetAggregation.BuildAggregationStoredProcedureName AS SPROC FROM Dataset INNER JOIN StandardDatasetAggregation ON Dataset.DatasetId = StandardDatasetAggregation.DatasetId ORDER BY Dataset HTH, Jonathan Almquist - MSFT

Hi Graham, That's a very useful article, thanks.Yog Li -- Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.