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.
SCOM DB - OperationsManager
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
3 answers
Sort by: Newest
-
System Center guy 686 Reputation points
2021-07-14T13:31:25.207+00:00 -
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
-
XinGuo-MSFT 14,856 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%'
Edit:
After my test , it seems that there is no relevant table in SCOM 2016 database.