-
Touching a file using Windows PowerShell
Its been a little while since I’ve posted on my blog…it’s been a very hectic few months but I’m back and hopefully will be able to provide you guys with some more useful SCOM related things. Today though its Windows PowerShell as I was required to perform the equivalent of touching a file on a […]
-
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.
-
Merry Christmas!
Hello everyone, Thanks for your fantastic support and feedback this year, I really do appreciate it. I just wanted to say Merry Christmas and have a Happy and Safe New Year! I’ll take a very short break and I’ll see you early next year with some great new SCOM Posts and Training Videos! – Tim […]
-
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 […]