SCOM DB - OperationsManager

Question

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

Answer 1

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

Answer 2

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.

Answer 3

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%'  

Edit：

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