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.