Condividi tramite

DW Retention and Groom Settings

  • Articolo

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

  • Anonymous
    January 01, 2003
    첫번째 이야기 – SCCM 2012 SP1에서의 Unix/Linux 지원 SCOM에 이서 SCCM도 타 기종 지원을 시작하게 되나 봅니다. MMS 2011에서 첫 공식