Useful MOM 2005 SQL queries

SCDW/DTS:   Primary 6 tables that SCDW data is retained in: SC_AlertFact_Table SC_AlertHistoryFact_Table SC_AlertToEventFact_Table SC_EventFact_Table SC_EventParameterFact_Table SC_SampledNumericDataFact_Table Commands to execute to modify the data retention age:  Please run these commands changing the values from 385 to the number to the number of days of data to be retained: Exec p_updategroomdays ‘SC_AlertFact_Table’, 385 Exec p_updategroomdays ‘SC_AlertHistoryFact_Table’,…

2

Useful Operations Manager 2007 SQL queries

This post has been archived.  Please see the new posting for SQL queries for SCOM at: https://blogs.technet.microsoft.com/kevinholman/2016/11/11/scom-sql-queries/

104