Category: SQL

  • Retrieving a list of all SCOM Management Servers

    If you want to grab a list of all of your Management Servers, you can do that a few ways. 1. In the console from the “Administration View”. 2. Use the “Get-SCOMManagementServer” cmdlet. 3. A SQL Query against the OperationsManager Database. useOperationsManager SELECT*FROMManagedEntityGenericView INNERJOINManagedTypeViewONManagedEntityGenericView.MonitoringClassId=ManagedTypeView.Id WHERE (ManagedTypeView.Name=’microsoft.systemCenter.managementserver’) orderbyManagedEntityGenericView.DisplayName  

  • Setting the SCOM Data Warehouse Retention Policies

    How long do we keep data for in the Data Warehouse and how can I change the values? That’s probably a common question, so if you don’t know you can use a couple of methods.

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