DW Retention and Groom Settings

/*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

Back to SQL queries main menu