Welcome to TechNet Blogs Sign in | Join | Help

Browse by Tags

All Tags » TSQL » query   (RSS)
Thursday, June 11, 2009 5:48 AM

Outages and Maintenance Report

This is a little report I put together on request. This report will query the data warehouse, and show all the outages, and maintenance, for objects in specific groups. The outages look at all the “Failed to Connect to Computer” alerts, and list the start
Posted by kevinhol | 10 Comments
Filed under: , ,

Attachment(s): Outage and Maintenance Report.zip
Thursday, October 18, 2007 7:44 PM

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
Posted by kevinhol | 2 Comments
Filed under: , ,
Thursday, October 18, 2007 7:35 PM

Useful Operations Manager 2007 SQL queries

Last updated 11-9-09     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 so.name, 8 * Sum(CASE WHEN si.indid IN (0, 1) THEN si.reserved
Posted by kevinhol | 26 Comments
Filed under: ,
 
Page view tracker