Skip to Content

Audit data Tables

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Dec 13, 2011 at 08:58 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

  • Posted on Dec 12, 2011 at 04:34 PM

    Hi,

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

    Kind regards

    Roberto

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 13, 2011 at 01:20 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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.