Kevin Holman's System Center Blog

Posts in this blog are provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified in the Terms of UseAre you interested in having a dedicated engineer that will be your Mic

October, 2007

  • 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...
  • Useful Operations Manager 2007 SQL queries

    Last updated 10-12-10     Large Table query .   (I am putting this at the top, because I use it so much – to find out what is taking up so much space in the OpsDB or DW) SELECT TOP 1000 AS [tablename], (a1.reserved + ISNULL(a4.reserved...