Query Schema Drift History
joezimo
Posts: 2
We've been using the DLM Dashboard for nearly four months and feel this is a great product. What I'd like to know is can we query (via SSMS) the DLM database to view the history of schema changes? I see the table "DDL_Events" and can query this. However, we'd like to pull some reports on the overall history of schema changes for each database we monitor with the DLM Dashboard. This will help us review them with our Management and Audit groups.
Comments
The DDL_Events table is periodically emptied by DLM Dashboard so as to not fill up space on your server, so this isn't a reliable way of monitoring the history. It copies the information across to its own internal database, which is not a SQL database and at the moment there's no way to run reports on the data.
If you'd like to suggest this as a feature then I recommend that you post something on our UserVoice site - there you can make suggestions and vote on suggestions that other users have made.
Sorry.
Redgate Software