on 12-12-2011 4:30 PM
Hi All,
Can you tell me the names of the table where Audit data is stored in Microsoft platform.
I think there are two tables ie Audit Activity table and Audit data table .
Thank you
Kind Regards
Abhinav Sona
Hi
Thanks for quick reply Roberto and Nilanjan.
I know the Audit related information is stored in Extra database . But I don't have access for Extra database at the moment, So it will be great if you can tell me the exact table names.
Kind Regards
Sona
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sona,
these are the table names:
AuditDtsLog
AuditActivityDetail<Appset>
AuditActivityDetail<Appset>Archive
AuditActivityHdr<Appset>
AuditActivityHdr<Appset>Archive
for each application:
AuditActivityDetail<Application>
AuditActivityDetail<Application>Archive
AuditActivityHdr<Application>
AuditActivityHdr<Application>Archive
AuditData<Application>
AuditData<Application>Archive
AuditDataTmp<Application>
AuditHdr<Application>
AuditHdr<Application>Archive
Comment<Application>Archive
Kind regards
Roberto
Edited by: Roberto Vidotti on Dec 13, 2011 10:34 AM
Hi,
Whenever you enable the audit (data or activity), SQL creates another database with the name <appset name>extra. All the audit related information is stored in this appset. The audit related information can grow quite a lot over a period of time, and this will impact the performance of the system. And hence, its maintained in a separate database.
Hope this helps.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
the audit data and activity are stored in another db named <Apsset>Extra, there are a lot of tables.
Kind regards
Roberto
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.