/*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 SET @RowCount = 20 SET @MGID = 1 SET @TimeZoneOffset = 5 SET @OffSetDays = 60 SET @StartDate = DATEADD(hour, @TimeZoneOffset, DATEADD(day, -@OffSetDays, GETDATE())) SET @EndDate…
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 SET @RowCount = 20 SET @MGID = 1 SET @TimeZoneOffset = 5 SET @OffSetDays = 60 SET @StartDate = DATEADD(hour, @TimeZoneOffset, DATEADD(day, -@OffSetDays, GETDATE())) SET @EndDate =…
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 SET @RowCount = 20 SET @MGID = 1 SET @TimeZoneOffset = 5 SET @OffSetDays = 60 SET @StartDate = DATEADD(hour, @TimeZoneOffset, DATEADD(day, -@OffSetDays, GETDATE())) SET @EndDate…
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 AS DATE SET @RowCount = 20 SET @MGID = 1 SET @TimeZoneOffset = 5 SET @OffSetDays = 60 SET @StartDate = DATEADD(hour, @TimeZoneOffset, DATEADD(day, -@OffSetDays, GETDATE()))…
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 FROM vManagedEntity AS ME INNER JOIN vHealthServiceOutage AS HSO ON HSO.ManagedEntityRowId = ME.ManagedEntityRowId INNER JOIN vStringResource AS SR ON HSO.ReasonCode = REPLACE(LEFT(SR.StringResourceSystemName, LEN(SR.StringResourceSystemName) – CHARINDEX(‘.’, REVERSE(SR.StringResourceSystemName))), ‘System.Availability.StateData.Reasons.’, ”) INNER JOIN vDisplayString AS…
Management Pack Authoring Links
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.com/b/jonathanalmquist/archive/2010/04/28/how-to-create-a-computer-group-in-the-r2-authoring-console.aspx · How to create an instance group http://blogs.technet.com/b/jonathanalmquist/archive/2010/05/08/how-to-create-an-instance-group-in-the-r2-authoring-console.aspx · How to create a computer group based on properties of any class http://blogs.technet.com/b/jonathanalmquist/archive/2010/07/22/how-to-create-a-group-of-windows-computers-based-on-a-discovered-property-of-virtually-any-class.aspx…
Don’t sweat the small stuff
I attempted to open the Health Explorer and received the following message. The state of this object is unavailable at this time OMG! What to do? I tried opening the Operations Console with a clean cache. "C:\Program Files\System Center Operations Manager 2007\Microsoft.MOM.UI.Console.exe" /ClearCache ROFL! That was easy! The lesson here is, we need to choose…
Manually removing computers by editing the database
We received an important reminder today from the product group about manually editing the database, and I wanted to stress the importance of this on their behalf. The SCOM community and our customers need to know that doing so without the direct guidance and support of Microsoft is not supported, and may cause database corruption….
My plan to move the Report Server to a new computer
This procedure is fully documented on Technet, but it spans across two different articles, which might make it a little bit confusing putting together the order of execution. This is the reason I wanted to share the plan I used which resulted in a successful move, including the preservation of custom authored, favorite and scheduled…
Vote for what content would you like to see most?
Sorry, but I had to remove the voting widget I had on the main page. It was causing some problems…kind of buggy. But I did take note that custom report authoring accounted for 44% of the votes! I’ll keep that in mind for future posts and try to offer a little more on that subject. If…