SCOM DB - OperationsManager

B Sandhya 1 Reputation point
2021-07-08T09:01:48.873+00:00

Hi,

I have a query which is running in SCOM 2019 OperationsManager DB, but same query doesnt run in SCOM 2016 version OP DB because that version doesnt have the table "MT_Microsoft$SystemCenter$Installed$OMProducts". This could be because of change in version. I tried finding if there is any other similar table but didnt find any.Please help. Below is the table and its column names. I m using this table to fetch agent health status

SELECT TOP (1000) [BaseManagedEntityId]
,[ComputerName_3F7BB403_5CBF_151A_434C_8C86820A93AE]
,[ObjectStatus_4AE3E5FE_BC03_1336_0A45_80BF58DEE57B]
,[KBNumber_4A01217C_0DF9_26FF_F61A_709E7ACD7DCF]
,[ProductDisplayName_B29D2312_FA16_2CE0_C7F3_E1A1DE7E3237]
,[Domain_709E49C4_8B5B_DC23_BE07_33A7725145C4]
,[InstallDate_930A41AF_B3BD_0349_9343_7C5A9CFBD873]
,[PatchInstalled_39748D50_2140_6EF1_9B95_460F96AA1D65]
,[AssetStatus_B6E7674B_684A_040D_30B8_D1B42CCB3BC6]
,[Version_2A6C94F4_810F_6E85_9CED_D3EC3F33685B]
,[DisplayName]
,[Notes_5CFC0E2A_AB82_5830_D4BB_0596CBED1984]
FROM [OperationsManager].[dbo].[MT_Microsoft$SystemCenter$Installed$OMProducts]

Thanks,
Sandhya

Operations Manager
Operations Manager
A family of System Center products that provide infrastructure monitoring, help ensure the predictable performance and availability of vital applications, and offer comprehensive monitoring for datacenters and cloud, both private and public.
1,419 questions
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. System Center guy 686 Reputation points
    2021-07-13T00:36:47.91+00:00

    MS document states that using SQL query to query SCOM db table is not official recommend. This is means that SQL query run on particular version SCOM e.g. SCOM 2019 does not guarantee it work normally on another version e.g. 2016 .

    Roger

    1 person found this answer helpful.
    0 comments
  2. System Center guy 686 Reputation points
    2021-07-14T13:31:25.207+00:00

    Moreover, MT_Microsoft$SystemCenter$Installed$OMProducts is refer to the new feature of SCOM 2019, Operations Manager product. As a result, there is no associate table in previous version of SCOM.
    114701-pict001.jpg

    1 person found this answer helpful.
    0 comments
  3. XinGuo-MSFT 14,621 Reputation points
    2021-07-09T07:09:00.04+00:00

    Hi,

    Maybe we could use the following query to search the table\column names in database. 

    select * from INFORMATION_SCHEMA.COLUMNS  
where COLUMN_NAME like '%installed%'

    113254-capture.png

    Edit：

    After my test , it seems that there is no relevant table in SCOM 2016 database.

    0 comments