Command Shell Examples
Useful SQL Queries
Browse by Tags - Jonathan Almquist on Operations Manager - Site Home - TechNet Blogs

Browse by Tags

Related Posts
  • Blog Post: Top events collected (Report Dataset)

    /*Top events collected Jonathan Almquist (http://blogs.technet.com/b/jonathanalmquist/) 04-08-2011 */ DECLARE @ RowCount AS INT , @MGID AS INT , @TimeZoneOffset AS INT , @OffSetDays AS INT , @StartDate AS DATE , @EndDate AS DATE ...
  • Blog Post: Number of State Change Events Per Day (Report Dataset)

    /*Number of state change events per day (trending) Jonathan Almquist (http://blogs.technet.com/b/jonathanalmquist/) 04-08-2011 */ DECLARE @ RowCount AS INT , @MGID AS INT , @TimeZoneOffset AS INT , @OffSetDays AS INT , @StartDate AS DATE , ...
  • Blog Post: Top Active Repeating Alerts (Report Dataset)

    /*Top active repeating alerts Jonathan Almquist (http://blogs.technet.com/b/jonathanalmquist/) 04-08-2011 */ DECLARE @ RowCount AS INT , @MGID AS INT , @TimeZoneOffset AS INT , @OffSetDays AS INT , @StartDate AS DATE , @EndDate AS DATE ...
  • Blog Post: Heartbeat Failure and Failed to Connect Alerts with Duration

    I find this especially useful in determining out of box heartbeat settings, since the default 3 minutes is almost never an optimal setting.  Without the information returned from this query, I generally suggest 9 minutes out of box (adjusting the agent interval from 60 to 180 seconds). /* ...
  • Blog Post: Root Management Server Unavailable History with Reason

    /* RMS Unavailable History with Reason http://blogs.technet.com/b/jonathanalmquist/ 04-19-2011 Updated 04-20-2011 with outage durations dd:hh:mm */ SELECT ME. Path , HSO.StartDateTime AS OutageStartDateTime, CAST (DATEDIFF( SECOND , HSO.StartDateTime...
  • Blog Post: Top Rule Generated Alerts (Report Dataset)

    /*Top rule generated alerts report dataset Jonathan Almquist (http://blogs.technet.com/b/jonathanalmquist/) 04-08-2011 */ DECLARE @ RowCount AS INT , @MGID AS INT , @TimeZoneOffset AS INT , @OffSetDays AS INT , @StartDate AS DATE , @EndDate...
  • Blog Post: Top Monitor Generated Alerts (Report Dataset)

    /*Top monitor generated alerts Jonathan Almquist (http://blogs.technet.com/b/jonathanalmquist/) 04-08-2011 */ DECLARE @ RowCount AS INT , @MGID AS INT , @TimeZoneOffset AS INT , @OffSetDays AS INT , @StartDate AS DATE , @EndDate AS DATE ...
  • Blog Post: Number of Events Collected Per Day (Report Dataset)

    /*Number of events collected per day (trending) Jonathan Almquist (http://blogs.technet.com/b/jonathanalmquist/) 04-08-2011 */ DECLARE @ RowCount AS INT , @MGID AS INT , @TimeZoneOffset AS INT , @OffSetDays AS INT , @StartDate AS DATE , @EndDate...
  • Blog Post: Report Dataset Samples

    Putting this list of reporting dataset samples out here for your custom reporting needs or just to paste in for general purpose queries to the Data Warehouse. I’ll update this list when I have new datasets to share. Updated: 09-23-2011 · Top alert generating monitors (tuning) http...
  • Blog Post: Top Performance Samples Collected (Report Dataset)

    /*Top performance samples collected Jonathan Almquist (http://blogs.technet.com/b/jonathanalmquist/) 04-08-2011 */ DECLARE @ RowCount AS INT , @MGID AS INT , @TimeZoneOffset AS INT , @OffSetDays AS INT , @StartDate AS DATE , @EndDate AS DATE...
  • Blog Post: Number of Performance Samples Per Day (Report Dataset)

    /*Number of performance samples per day (trending) Jonathan Almquist (http://blogs.technet.com/b/jonathanalmquist/) 04-08-2011 */ DECLARE @ RowCount AS INT , @MGID AS INT , @TimeZoneOffset AS INT , @OffSetDays AS INT , @StartDate AS DATE , ...
  • Blog Post: Gray Agents With Reason

    /* Gray agents with reason http://blogs.technet.com/b/jonathanalmquist/ 02-26-2011 */ SELECT ME. Path , HSO.StartDateTime AS OutageStartDateTime, DATEDIFF (DD, hso.StartDateTime, GETDATE()) AS OutageDays, HSO.ReasonCode, DS.Name AS ReasonString...