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

Comments (1)

  1. Anonymous says:

    첫번째 이야기 – SCCM 2012 SP1에서의 Unix/Linux 지원

    SCOM에 이서 SCCM도 타 기종 지원을 시작하게 되나 봅니다. MMS 2011에서 첫 공식