Command Shell Examples
Useful SQL Queries
DW Retention and Groom Settings - Jonathan Almquist on Operations Manager - Site Home - TechNet Blogs

DW Retention and Groom Settings

DW Retention and Groom Settings

  • Comments 1
  • Likes

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

I do not moderate this blog anymore. If you have a question regarding this post, send me a message.

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

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