This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(284.8, 88%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENA%3C/text%3E%3C/svg%3E)
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
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(118.4, 98%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
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,