SCOM Custom Report

Question

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.

Answer 1

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