This post is the updated version of http://blogs.technet.com/b/emreguclu/archive/2013/01/21/undiscovering-stop-monitoring-sql-2008-express-editions.aspx which adds SQL 2005 and SQL 2012 support to existing mp as per requests of my peers and customers. If you have the older version please just download and import this one. There is also a new explanation about the reason for this method. In this post…

In the main post (here) I published the SQL MP Extensions Management Pack and within this post series I will be providing an Authoring Tutorial explaining the MP. This first post of the tutorial series is focusing how to get ready to start authoring. To author an MP requires to be confident on the following…

Figuring out (monitoring) unused SQL databases using SCOM was one of the common requests I got from DBAs of enterprise customers. I authored a management pack (SQL MP Extensions – download available) to address this feature and also took this an opportunity to provide a tutorial for MP authoring with a real life scenario. I…

MP UPDATE: The updated MP for all sql versions plus new explainations can be found at http://blogs.technet.com/b/emreguclu/archive/2014/09/12/undiscovering-stop-monitoring-sql-2005-2008-2012-express-editions.aspx In this post I will try to cover an alternate method of undiscovering SQL Express editions other than using the ExcludeList Property where I have a decent reason to do so. The MP explained in detail is also attached to…

We can utilize Operations Manager Console to create attributes to existing classes (if you havent met Kevin’s great blog with a real life scenario please do so). Using SCOM console is great but when you need to add only ONE Property. Once you need a second or third property, advanced authoring MP is required. The…

As we all know, Operations Manager 2012 requires activation through entering the well-known powershell command “set-scomlicense”. This is documented in http://support.microsoft.com/kb/2699998 Even though the license isn’t entered, OM12 will let you work 180 days and at the end SDK service will not authorize the connections from ANY console including powershell – hey wait! how am…

We all know selecting the correct object type in the reports had been an issue since RTM till R2. With SCOM R2 Object Picker Control has a new feature that allows you to filter report author to put a filter so that the Report Operator does not need figure out which one is right. New…

As a SCOM engineer we face a common scenario when the Generic Report Library Availability Reports returns more than we expected. This is because the Generic Report returns the result for System.Health.AvailabilityState including the states that we don’t want to include in our reports. For example; Lets think of the scenario we are just…

Exchange 2010 mp 14.02.0071.0 You might be experiencing empty report issues for the following reports if the default log paths for exchange message tracking are changed. Daily Mailflow Statistics Hourly Mailflow Statistics Distribution Group Usage This post is covering the solution and the way that Exchange 2010 MP collecting the data for these Reports. Exchange…