cancel
Showing results for 
Search instead for 
Did you mean: 

Audit data Tables

sona_a
Explorer
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

sona_a
Explorer
0 Kudos

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

former_member186498
Active Contributor
0 Kudos

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

Answers (2)

Answers (2)

Former Member
0 Kudos

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.

former_member186498
Active Contributor
0 Kudos

Hi,

the audit data and activity are stored in another db named <Apsset>Extra, there are a lot of tables.

Kind regards

Roberto