SCOM Custom Report

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

Accepted answer
  1. XinGuo-MSFT 6,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