Hi all Believe we are seeing periodically problems with the data aggregation in the DW and that for days it can become backlogged.
I found a couple of good articles http://operationsmanager2012.blogspot.co.uk/2013/02/scom-availability-report-monitoring.html and http://blogs.technet.com/b/operationsmgr/archive/2011/09/06/standard-dataset-maintenance-troubleshooter-for-system-center-operations-manager-2007.aspx Which discuss at least some of these points. I was wondering how to automatically detect backlog in the Ops DW and alert for tis in SCOM. Any ideas how to turn the a SQL query output into an Alert in SCOM 2007 R2? Believe the query I need to use is:- DECLARE @DatasetId uniqueidentifier SELECT @DatasetId = DatasetId FROM Dataset d WHERE (d.DatasetDefaultName ='State data set') Select AggregationDateTime, AggregationTypeId >From StandardDatasetAggregationHistory Where DatasetId = @DatasetId And DirtyInd = 1 Peter Hakesley PJH2711-RIPE, CDCT, MBCS SCC Services Data Centre Operations - Service Implementation - Enterprise Systems Engineer SCC Cole Valley 1, 20 Westwood Avenue, Tyseley, BIRMINGHAM B11 3RZ Tel: +44 (0)845 351 0680 xtn 4006 eMail: [email protected]<mailto:[email protected]> Web : www.scc.com<http://www.scc.com/> [Description: Description: BCS_Logo]
<<inline: image001.jpg>>
