Download: https://gallery.technet.microsoft.com/SQL-Server-RunAs-Addendum-0c183c32 Over the years I have written many articles dealing with RunAs accounts. Specifically, the most common need is for monitoring with the SQL MP. I have explained the issues and configurations in detail here: Configuring Run As Accounts and Profiles in OpsMgr – A SQL Management Pack Example…
Useful Operations Manager 2007 SQL queries
This post has been archived. Please see the new posting for SQL queries for SCOM at: https://blogs.technet.microsoft.com/kevinholman/2016/11/11/scom-sql-queries/
OpsMgr: MP Update: New Base OS MP 6.0.6958.0 adds Cluster Shared Volume monitoring, BPA, new reports, and many other changes
***Note: This post is edited to reflect the newly shipped MP version 6.0.6958.0 Get it from the download center here: http://www.microsoft.com/download/en/details.aspx?id=9296 This really looks like a nice addition to the Base OS MP’s. This update centers around a few key areas for Windows 2008 and 2008 R2: Adds Cluster Shared Volume…
SNMP Trap monitoring with SCOM 2012 R2
There are several really good blogs out there which document some of the struggles and workarounds with getting SNMP TRAP monitoring to work. I’ll reference some of them at the bottom, but this will be mine to document what worked, what didn’t, and some MP authoring examples that don’t exist anywhere else on the…
Understanding and modifying Data Warehouse retention and grooming
You will likely find that the default retention in the OpsMgr data warehouse will need to be adjusted for your environment. I often find customers are reluctant to adjust these – because they don’t know what they want to keep. So – they assume the defaults are good – and they just keep EVERYTHING. This…
OpsMgr 2007 R2 CU3 rollup hotfix ships – and my experience installing it
****NOTE OpsMgr 2007 R2 CU5 is now shipped and this is an old article. http://blogs.technet.com/b/kevinholman/archive/2011/08/03/opsmgr-2007-r2-cu5-rollup-hotfix-ships-and-my-experience-installing-it.aspx ***Note: I recommend reading this article all the way through…. things didn’t go exactly as I’d expected, and there are some very critical order-of-operations steps to be aware of. There is a known issue where the SDK…
Event ID 129 – storachi – Reset to device, DeviceRaidPort0, was issued.
One of my Server 2012 machines kept hanging, and it was more than annoying. The system is a Dell Precision 690 Workstation, with dual Xeon CPU’s, and has the Hyper-V role installed. This machine uses an Intel storage controller and has an addition Dell SAS/SATA controller. Primarily, I use this machine as my…
OpsMgr 2007 R2 CU4 rollup hotfix ships – and my experience installing it
****NOTE OpsMgr 2007 R2 CU5 is now shipped and this is an old article. http://blogs.technet.com/b/kevinholman/archive/2011/08/03/opsmgr-2007-r2-cu5-rollup-hotfix-ships-and-my-experience-installing-it.aspx The KB article describing the fixes, changes, and instructions: http://support.microsoft.com/kb/2449679 Get it from the download Center: http://www.microsoft.com/downloads/details.aspx?FamilyID=39a871e0-d996-4568-be5d-2edb6f539330 List of all OpsMgr R2 Cumulative Updates: http://support.microsoft.com/kb/2453149 ***Caution: There is a known issue documented in the KB…
OpsMgr 2007 R2 CU1 rollup hotfix ships – and my experience installing it
****NOTE OpsMgr 2007 R2 CU5 is now shipped and this is an old article. http://blogs.technet.com/b/kevinholman/archive/2011/08/03/opsmgr-2007-r2-cu5-rollup-hotfix-ships-and-my-experience-installing-it.aspx ——————————————————————– The KB article describing the fixes and changes: http://support.microsoft.com/kb/974144 There are MANY fixes in this update for R2 – and I am not going to go through each one. Just understand – I…
UR7 for SCOM 2012 R2 – Step by Step
KB Article for OpsMgr: https://support.microsoft.com/kb/3064919 KB Article for all System Center components: https://support.microsoft.com/en-us/kb/3069110 Download catalog site: http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3064919 IMPORTANT Be aware that the SCOM Web Console package for UR7 includes an important security update (https://technet.microsoft.com/en-us/library/security/MS15-086) *** Take notice – this update is HUGE with LOTS of fixes, and also has an important security update…
OpsMgr 2007 R2 CU5 rollup hotfix ships – and my experience installing it
The Cumulative Update 5 (CU5) for OpsMgr 2007 R2 has shipped The KB article describing the fixes, changes, and instructions: http://support.microsoft.com/kb/2495674 Get it from the download Center: http://www.microsoft.com/download/en/details.aspx?id=26938 List of all OpsMgr R2 Cumulative Updates: http://support.microsoft.com/kb/2453149 Here are the high level fixes: Cumulative Update 5 for Operations Manager 2007 R2…
Which hotfixes should I apply?
This is updated as of 4-29-2018 In general – you should evaluate all hotfixes available, and only apply those applicable to your environment. However, some of these below I have seen impact almost every environment, and should be heavily considered. This list is nothing official…. this is just a general list of the…
I’m Back!
Well, after 3 years in the Microsoft Sales organization, I have decided to return to Microsoft Premier Field Engineering. As of today, I am back in PFE as a SCOM engineer. I had a great time in Technical Sales, and it was a fantastic learning experience for me. After almost three years, I decided that…
Agent Management Pack – Making a SCOM Admin’s life a little easier
Current Version: 7.0.0.54 5/16/2018 Download link: https://gallery.technet.microsoft.com/SCOM-Agent-Management-b96680d5 This is a Management Pack that eases the administrative burdens in SCOM. It allows you to have a lot of handy discovered properties, and includes tasks that allow you to delegate administrative actions to your users. It also serves as a good example MP on how…
Adding custom information to alert description (s) and notifications
Alert Description Variables: The following section contains variables for the Alert Description only. For event Rules (Alert Description): EventDisplayNumber (Event ID): $Data/EventDisplayNumber$ EventDescription (Description): $Data/EventDescription$ Publisher Name (Event Source): $Data/PublisherName$ EventCategory: $Data/EventCategory$ LoggingComputer: $Data/LoggingComputer$ EventLevel: $Data/EventLevel$ Channel: $Data/Channel$ UserName: $Data/UserName$ EventNumber: $Data/EventNumber$ Event Time: $Data/@time$ For event Monitors (Alert Description): EventDisplayNumber (Event ID): $Data/Context/EventDisplayNumber$…
Introducing Thing 1 and Thing 2
My blog has been silent for a bit lately. This is because of the birth of my first children. SCOM world – Meet Logan and Lexi Holman. I’ll be taking some time off work to spend with them during the next few weeks as well. Logan has already been discussing a management pack…
Configuring Run As Accounts and Profiles in OpsMgr – A SQL Management Pack Example
Update 11/29/2012: This article is current as of the 6.3.173.1 version of the SQL MP. Using RunAs accounts and profiles is an often poorly understood area of OpsMgr. As I began to investigate setting this up for the SQL MP, I quickly realized how little I understood it. Chatting with my PFE peers, I…
OpsMgr 2012: Configure notifications
Setting up notifications for email, IM, or command channels is almost identical to how this was configured in OpsMgr 2007 R2. This article will just serve as a walk through to the process, such as immediately after deploying OpsMgr 2012. The key difference here is that Notifications are now managed by a Resource Pool, instead…
Does your OpsDB keep growing? Is your localizedtext table using all the space?
This post is about an issue in OpsMgr SP1 AND R2 – where the localizedtext table in the database may fill and consume large amounts of space. OpsMgr 2007 no longer has a hard database limit of 30GB like MOM 2005 did. For this reason, most OpsMgr administrators don’t watch this very closely anymore, or…
OpsMgr 2012 R2 – QuickStart Deployment Guide
There is already a very good deployment guide posted on TechNet here: http://technet.microsoft.com/en-us/library/hh457006.aspx The TechNet deployment guide provides an excellent walkthrough of installing OpsMgr 2012 for the “all in one” scenario, where all roles are installed on a single server. That is a very good method for doing simple functionality testing and lab exercises. The…