SCOM Custom Report

Fneff-8591 255 Reputation points
2023-05-22T17:25:08.4966667+00:00

I am creating custom reports in SCOM. I need to find out the following information:

  • Shows me all the sent emails
  • Mailbox, Email Subject, Date/Time,.

Can anyone please advise that what tables the information can be found?

Any help will be appreciated.

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,601 questions
0 comments No comments
{count} votes

Accepted answer
  1. XinGuo-MSFT 22,226 Reputation points
    2023-05-23T09:19:16.29+00:00

    Hi,

    You can use the query below to search SCOM's database and find the related fields.

    select * from INFORMATION_SCHEMA.COLUMNS
    
    where COLUMN_NAME like '%%'
    
    select * from INFORMATION_SCHEMA.TABLES 
    
    where TABLE_TYPE='view' and TABLE_NAME like '%%'
    
    

    Also find a blog that may be relevant.

    https://techcommunity.microsoft.com/t5/core-infrastructure-and-security/get-a-list-of-email-addresses-used-in-scom-notifications/ba-p/365741

    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

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