Kevin Holman's OpsMgr 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 Use

Are you interested in having a dedicated engineer that will be your Microsoft 'go to' technical resource, work with you on projects, provide training and also help troubleshoot problems that come up? Then Dedicated Support Engineering (DSE) is for you. Learn more at Microsoft Premier Services or contact your Technical Account Manager.

Browse by Tags

All Tags » 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 | 9 Comments

Filed under: query, reporting, TSQL

Attachment(s): Outage and Maintenance Report.zip

Friday, June 05, 2009 6:59 AM

Maintenance mode – tying the text of the category to the database

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

Posted by kevinhol | 0 Comments

Filed under: database, query, reporting

Friday, June 27, 2008 10:39 PM

Which servers are DOWN in my company, and which just have a heartbeat failure, RIGHT NOW?

In OpsMgr 2007, when a agent experiences a heartbeat failure, several things happen. There are diagnostics, and possibly recoveries that are run. Alerts, and possibly notifications go out. But what happens

Posted by kevinhol | 11 Comments

Filed under: query, agents, reporting, Authoring

Attachment(s): Servers_Down_Report.rdl

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: database, query, TSQL

Thursday, October 18, 2007 7:35 PM

Useful Operations Manager 2007 SQL queries

Last updated 7-24-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: query, TSQL

Kevin Holman's OpsMgr Blog

This Blog

Syndication

Search

Tags

News

Archives

OpsMgr Websites:

Other OpsMgr Blogs: