SCOM OperationManagerDW database.

Nenad Andrejic 1 Reputation point
2020-05-19T12:19:23.057+00:00

Hi,

I have researched SCOM OperationManagerDW database.
I was exploring the database by performing a sql query over the Alert.vAlert table, which contains data about SCOM alerts.
I have two questions about Alert.vAlert table, because currently we have three Alert.vAlert tables in OperationManagerDW database. SCOM created automatically Alert.vAlert tables.

According to which principle Alert.vAlert tables are created?
What represent DBCreatedDateTime, DWCreatedDateTime, DWLastModifiedDateTime entries in the database and why they different?

Thanks for answers.

Best Regards,

Nenad

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
37,632 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. KarishmaTiwari-MSFT 18,867 Reputation points Microsoft Employee
    2020-06-04T23:01:20.733+00:00

    Hi,

    Q&A currently supports the products listed over here https://learn.microsoft.com/en-us/answers/products (more to be added later on).

    You can reach the experts in the dedicated Microsoft Sharepoint forum over here:
    https://social.technet.microsoft.com/Forums/systemcenter/en-US/home

    (Please don't forget to mark helpful replies as answer)

    Best regards,

    0 comments No comments