Something I wrote to get a report on tasks being run on the OpsDB, and their output: select tv.Name as TaskName, bme.fullname as ObjectName, jsv.SubmittedBy, jsv.TimeStarted, jsv.TimeFinished, jsv.Output, tv.Description as TaskDescription from JobStatusView jsv inner join TaskView tv on jsv.MonitoringTaskId...

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 and end time of the outage, based on the...

I havent seen this discussed before – so I figured I would post this. In the OpsDB and DWDB – we keep some tables names MaintenanceMode and MaintenanceModeHistory. When you place an object into maintenance mode – we will log a row in the database for this object.  You could potentially write reports...

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...

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 a2.name AS [tablename], (a1.reserved + ISNULL(a4.reserved,0))* 8 AS reserved, a1.rows as row_count,...