question

SeepalaManju-1084 avatar image
0 Votes"
SeepalaManju-1084 asked XinGuo-MSFT edited

Scom Database Query

Hello,

I'm working on the requirement to fetch the monitoring metrics from SCOM Database.

Need to pull report by using SQL query, the output should contain the fields that are mentioned below.

Fields include server name, monitor name override value, frequency, interval and alert name.


can anyone help on this ?

msc-operations-manager
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

XinGuo-MSFT avatar image
0 Votes"
XinGuo-MSFT answered XinGuo-MSFT edited

Hi,

We recommend you use the following statement to search the database by keywords to find relevant data.

 select * from INFORMATION_SCHEMA.COLUMNS where COLUMN_NAME like '%principalname%'
    
 select * from INFORMATION_SCHEMA.COLUMNS where COLUMN_NAME like '%alert%'
    
 select * from AlertView
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.