 |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
Silver
Joined: 20 May 2009 Posts: 2 Country: United States |
|
Statistics |
|
On the Statistics page, there is a link to Schema Changes (DDL). This is great information - how do I get it in a report?
Thanks!
|
|
Wed May 20, 2009 3:29 pm |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
Do you have the System Audit enabled? Is it configured to audit schema changes? If yes and yes, and some changes have been made today, you should see the Statistics page filled with the data when you click on the Schema Change link. To view historical schema changes you can use reports in Reports menu, of course you would need to have System Audit running and auditing schema changes during the selected reporting period.
|
|
Wed May 20, 2009 4:49 pm |
|
 |
Silver
Joined: 20 May 2009 Posts: 2 Country: United States |
|
|
|
Thanks for replying so quickly!
Yes, I can see the Statistics page filled with the data. What I would like is a report that will provide this same information. I've looked through the reports in the Reports menu, and I'm not finding one that seems to provide the same information that's provided in Summary Statistics Schema Changes DDL. What is the name of that report?
Thanks!
|
|
Thu May 21, 2009 11:18 am |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
Please try Reports -> Compliance -> Recent Privileged Operations (Create, Drop, Alter)
|
|
Thu May 21, 2009 12:45 pm |
|
 |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|
|