Author Archives: scompanion

Powershell to send Top 15 Critical Alerts email from Scom

Here is a nifty powershell script that you can use to send an email with the Top 15 Critical Alerts in your Scom Management group to recipients of your choice. NOTE:-Amend the addresses in the script with @mycompany.com suffix to … Continue reading

Posted in Powershell for SCOM | Tagged , , , , , , , , , , , , , | Leave a comment

What scom groups does a monitored server belong to?

If you wish to find out all the groups a particular server monitored by scom belongs to then you can run this handy little powershell script  (you need to amend the script by entering the FQDN of the monitored server … Continue reading

Posted in Powershell for SCOM | Tagged , , , , , , , , , , , | Leave a comment

Active alert in console but alert not found when selecting it

Came across a scenario whereby I had installed a Scom 2012 management group in a DMZ and hadn’t visited it for months after installing it. When I launched the console there was an alert was 100 days old :-0 The … Continue reading

Posted in SCOM 2012 SP1 | Tagged , , , , , , , , , , , , , , , , , | Leave a comment

SQL query to get alert history by severity and priority from scom datawarehouse

Below is a fantastic SQL query to run against your scom datawarehouse database which will output all alerts by source, category, severity and priority and will also give details of the monitor or rule that triggered the alert as well … Continue reading

Posted in SQL Queries | Tagged , , , , , , , , , , , , , , , , , , , , , , , , | Leave a comment

SCOM Performance:-Disabling workflows to optimize for large environments

The following article is an extract from Kevin Holman’s System Center Blog  https://blogs.technet.microsoft.com/kevinholman/2017/08/15/quicktip-disabling-workflows-to-optimize-for-large-environments/ One of the coolest things about SCOM is how much monitoring you get out of the box. That said, one of the biggest performance impacts to SCOM … Continue reading

Posted in Monitors and Rules | Tagged , , , , , , , , , , , , , , | Leave a comment

SQL query to produce number of alerts by Severity between 2 dates

Here is a useful SQL query that you can run against your scom datawarehouse database which will produce a total count of alerts from dates you specify in the query. NOTE:-The query below worked against my SQL Server 2008 R2 … Continue reading

Posted in SQL Queries | Tagged , , , , , , , , , , , , | Leave a comment

SCOM Top Microsoft Support Calls and Solutions

Microsoft have lots of customers that use SCOM for monitoring purposes therefore have lots of support requests from customers over the years. I wasn’t aware until recently that they have kindly compiled a list of the top support issues they … Continue reading

Posted in SCOM 2012 SP1 | Tagged , , , , , , , , , , , , , | Leave a comment

Powershell to reveal Resource Pool membership(s) of all management servers

Here is a useful Powershell script to reveal the Resource groups that every management server in your Scom Management group is a member of:- $Members = Get-SCOMManagementServer foreach ($member in $members) { write-host “” $Pools = Get-SCOMResourcePool -Member $Member write-host … Continue reading

Posted in Powershell for SCOM | Tagged , , , , , , , , , , , , , | Leave a comment

SCOM 2012 Percent Processor Time Report Blank

I couldn’t get the Microsoft Generic Report working for %processor time. No matter what I tried, this particular report always ended up blank. I was running it for a couple of servers that had the Windows Server 2008 R2 operating … Continue reading

Posted in Misc Stuff, SCOM 2012 SP1 | Tagged , , , , , , , , , , | Leave a comment

Error: An attempt was made to reference a token that does not exist.

Had this error on my windows 10 laptop when trying to run Active Directory User and Computer snap-in         Transpires that this issue may have occurred due to corrupt files.  To fix I did the following:- Opened … Continue reading

Posted in Misc Stuff, Non SCOM Techy Stuff | Tagged , , , , , , , , , , | 1 Comment