Event 18054 errors in the SQL application log – in SCOM 2016 deployments

    When SCOM is installed – it doesn’t just create the databases on the SQL instance – it adds data to the sysmessages view for different error scenarios, to the Master database for the instance. This is why after moving a database, or restoring a DB backup to a rebuilt SQL server, or when…

0

How to create a SCOM group from an Active Directory Computer Group

    There have been a bunch of examples of this published over the years.  Some of them worked well, but I was never happy with many of them as they were often vbscript based, hard to troubleshoot, and required lots of editing each time you wanted to reuse them.  Many were often error prone,…

3

Monitoring for Time Drift in your enterprise

    Time sync is critical in today’s networks.  Experiencing time drift across devices can cause authentication breakdowns, reporting miscalculations, and wreak havoc on interconnected systems.  This article shows a demo management pack to monitor for time sync across your Windows devices. The basic idea was – to monitor all systems and compare their local…

0

Adding direct agent OMS Workspace and Proxy via PowerShell

  We have some REALLY good documentation on this here:  https://docs.microsoft.com/en-us/azure/log-analytics/log-analytics-windows-agents   PowerShell and the Agent Scripting Objects make it really easy to control the OMS direct agent configuration on thousands of agents, using SCOM.   Here are some PowerShell examples: # Load agent scripting object  $AgentCfg = New-Object -ComObject AgentConfigManager.MgmtSvcCfg # Get all AgentCfg…

0

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 is all the monitoring out of the box, plus all the Management Packs you import.  This has a cumulative effect, and over time, can impact the…

11

Creating a SCOM Service Monitor that allows overrides for Interval Frequency and Samples

    The “built in” service monitor in SCOM is hard-coded for how often it checks the service state, and how many service checks have to return “not running” before it alarms.  This is a bit unfortunate, as customers would often want to customize this.  This article will explain how.   All the built in…

4

Updated SQL RunAs Addendum Configuration MPs

    Just a quick note to let you know I updated these MP’s if you use them: https://blogs.technet.microsoft.com/kevinholman/2016/08/25/sql-mp-run-as-accounts-no-longer-required-2/   Updates include: 1.  Disabled the Monitor for SysAdmin check by default – you will need to enable this is you want to use it.  I have been recommending to use Low Priv since that is…

5

Reinstalling your SCOM agents with the NOAPM switch

  This one comes from collaboration with my colleague Brian Barrington. Because of the issues with SCOM 2016 and the default APM modules impacting IIS and SharePoint servers…..  (Read more about that issue HERE, HERE, and HERE)   Brian was looking for a way to easily remove the APM components from the deployed agents with…

12

What SQL maintenance should I perform on my SCOM 2016 databases?

    ***Note – The products and recommendations have changed over the years, so what applied to previous versions does not really apply today.  Make sure you read the entire article!   The SQL instances and databases deployed to support SCOM, generally fall into one of two categories:  1.  The SQL server is managed by…

2