Tag: SQL

  • 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 […]

  • 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.

  • SQL MP Version 6.7.2.0

    Microsoft recently released a newer version of their SQL Management Pack. You can find it here: https://www.microsoft.com/en-us/download/details.aspx?id=10631

  • What happens behind the scenes when you run a PowerShell Command for SCOM?

    So have you ever wondered what happens when you run a PowerShell command against your SCOM environment? Of course you have or you wouldn’t be here. Well you probably wouldn’t be surprised to learn that behind the scenes a lot of PowerShell cmdlets are really only performing a SQL query against your SCOM Databases.

  • Querying the SCOM SQL Database using PowerShell

    Although directly editing the SCOM Databases isn’t something that Microsoft really support, we all know that accessing the SCOM Databases directly can be easier than mucking around in the console or trying to use or find a suitable PowerShell cmdlet. As much as I love using PowerShell wherever possible, I know that there are times […]