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

Someone asked today if there was a way to generate a report displaying inventory/configuration of SQL Server.  Chris Harris, SCOM Program Manager, answered the question with one of our built-in configuration reports.  He was so kind as to provide...

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

Since we migrated to a new platform in May, 2010, there are more options for us as bloggers to customize the readers’ experience.  I was making some changes to my blog recently and noticed we now have a translator widget available.  Not sure...

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

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

/*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 , ...

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

/*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 , ...

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

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

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

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

Just wanted to post this management pack authoring link list for easy reference.  I’ll add new authoring posts to this list when they become available. ·         How to create a computer group http://blogs.technet...

If you see these alerts generated by your Windows 2008 and Windows 2008 R2 servers with unusually high values, this is due to an issue with the RegQueryValueEx function , which is used in the Average Disk Seconds Per Transfer monitor. For Windows 2008...