Category: SCOM

  • Event 4211 on SQL Sever 2016 (MSSQL 2016: Monitoring failed)

    So today I installed a new SCOM Environment and immediately after installing the SQL 2016 Management Pack the event log was littered with 4211 Errors and triggered the Alert Rule: MSSQL 2016: Monitoring failed. In the Operations Manager Event Log there was a lot of varied 4211 errors.    

  • Monitoring Windows Event Log Events (without SCOM)

    Today I was asked if there is any way of getting emailed if a particular Windows Event Log Event was generated on a server. “Of course” I said, “SCOM can easily do that!” “Oh we don’t have SCOM” was the reply. “What? You don’t have SCOM? Why are you even talking to me?”. Sadly this […]

  • What SCOM Objects are in Maintenance Mode (SQL Query)

    If you want to find out what objects are currently in Maintenance Mode, here’s a nice bit of SQL Code you can use for just that. I’ve added a more useful English Reason than just the code because SCOM stores the code itself in the Database. It’s a lot easier in my opinion to identify […]

  • SCOM Health Check SQL Report v1.0 (coming soon!)

    I’ve had so much positive feedback about my original SCOM Health Check Script and also the updated v2 one which a lot of people thanked me for updating it with the fresh new style. However I also got some great feedback asking if I could turn it into a SCOM Report that could be run, […]

  • Get alerts from Management Servers using SQL

    There’s a lot of ways we can retrieve a list of alerts from SCOM, but nothings quicker than going to the Database directly. So here’s a bit of SQL that can grab all alerts from a Management Server, but formats the output a bit nicer. So for example rather than outputting the severity as a […]

  • Get a list of SCOM Management Servers and Gateway Servers from SQL

    I recently received a question asking about getting some of the information from a table in my health check script directly from SQL. So in response to that, here’s some SQL code that will pull out the Management Servers and the Gateways from the SCOM Database, along with some performance collection data about each server.

  • How to get the number of alerts in the last 24 hours using SQL

    Here’s how to get the number of alerts in the last 24 hours using SQL. Thanks Michael for the question.   SELECT COUNT(*) AS [Number of Alerts per Day] FROM Alert WITH (NOLOCK) WHERE TimeAdded > dateadd(hh,-24,getutcdate())   Hope that helps.

  • New SCOM 2016 Video – Troubleshooting SCOM Agents

    In the previous video I ended with a short lecture on why it’s so important that you ensure that your agents work properly…in this video I pretty much start with the same lecture (haha). After that we begin to see how we can troubleshoot SCOM Agents. I talk about problems you might experience with manually […]

  • New SCOM 2016 Video – Windows Agents Part 2

    In this video I show you how you can set the Remotely Manageable flag on your agents to yes in the SQL Database. I also show you how to enable Agent Proxying for all agents but also how to configure SCOM so that all future agents you install also have the Agent Proxying feature turned […]

  • New SCOM 2016 Video – Installing Windows Agents

    Another video for you guys, this one shows you how to use the discovery wizard to install Windows Agents. We also unlock all of the required ports to use discovery in a firewalled environment. Next we install an agent manually and see how when we install an agent on a Domain Controller, the additional step […]