Share via

Scom Database Query

Seepala Manju 1 Reputation point
2021-06-09T10:25:39.017+00:00

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 ?

System Center Operations Manager
System Center 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.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. XinGuo-MSFT 22,271 Reputation points
    2021-06-10T07:28:22.217+00:00

    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

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.