web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Audit Trail Database
Microsoft Dynamics GP (Archived)

Audit Trail Database

(0) ShareShare
ReportReport
Posted on by Richard Wheeler 75,848 Moderator

We have a client who installed Audit Trails for GP 2010 from a workstation. According to the Audit Trail manual the audit trail tables go into a separate database. When I look in SSMS I do not see any additional databases and when I look at what appear to be audit trails tables in their company database they are all empty even though tracking has been turned on. When I go to Install Audit Trail the Install button is dim so I assume this means the audit trail database has been created and code has been installed.

Does a separate database get created for Audit Trail tracking? Where are the tables? How do I run reports for Audit Trail Tracking? If I can find the tables where this data is kept I want to wrap SSRS reports around them.

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Community Member Profile Picture
    Community Member on at
    Re: Audit Trail Database

    Richard,

    Audit Trails is part of the Risk Managment Suite, which is an Ala Carte item on the price list.  

    Warren.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at
    Re: Audit Trail Database

    I will take what is behind door number 2)

    2) If you are logged in GP as 'sa' user and modul is not registered then message is displayed at

    the bottom of the window that module is not registered and install button is disabled

    So the question now becomes how do I register Audit Trails? I took them to CustomerSource and we entered their current registration keys.Under products registered their is no listing for Audit Trails. They purchased BRL AM and Audit trails is not an ALA Carte item and should be included.

  • Milan Simic Profile Picture
    Milan Simic 20 on at
    Re: Audit Trail Database

    Hello,

    I am sorry for jumping into middle of the discussion. I am not sure if both parties are talking about being logged in GP (not SQL Management Studio - SSMS) as 'sa'. I am saying this because on opening Audit Trails Install window 1 of 3 scenarios should occur:

    - If you are logged in GP as 'sa' user and modul is registered Install button is enabled

    - If you are logged in GP as 'sa' user and modul is not registered then message is displayed at the bottom of the window that module is not registered and install button is disabled.

    - if you are not logged in GP as 'sa' user then message is displayed displayed at the bottom of the window that only 'sa' user can install the modul and install button is disabled.

    By the way Audit Trails has its setup tables in company database while only audited tables have their mirroring tables created in additional database.

  • Community Member Profile Picture
    Community Member on at
    Re: Audit Trail Database

    Never having uninstalled, then I do not know the answer about deleting the AT tables.   You can probably reverse engineer tables.

    I too would be confused on this.   The install button will be greyed out if you are not logged in as "sa".    

    Are you sure that he really did the complete installation?   He may have installed the dex code but never got to the point where you name the AT db.    I can see where that could happen.   You would have all the windows to open, but no AT db created.    

    Warren

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at
    Re: Audit Trail Database

    This is why I am confused. When I go Tools->Setup->Company->Audit Trails->Install Audit Trails the Install button is dim and all it lists are version numbers. There are no database names listed. I do not how he got it this way. Is there a way to uninstall Audit Trails completely, including the SQL tables, where ever they are and start over? He did some kind of install from a workstation and there is no AT database anywhere to be found in the instance of SQL.

  • Community Member Profile Picture
    Community Member on at
    Re: Audit Trail Database

    You name it when you do the install.  

    On the Server

    1) Log into GP as sa, select the company you want to audit.

    2) Microsoft Dynamics GP menu >> Tools >> Setup >> Company >> Audit Trails.   On the window, there is a button for Install.   Opens the window where you name the Audit DB.  

    If you don't see the box to name the Audit DB and see db names already in boxes and un-available for edit then at least you will see what the name of the Audit DB is.

    As best practices, I always do the Audit Trails on the Server and logged in as "sa".   Also as best practice and name the Audit DB something reflective of the company audited.   Example: ABC as the company & company DB, then the Audit db I would name as AUDTABC.    If you were running Audit trails for more than one company, you would have a separate Audit db for each.  

    Warren

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at
    Re: Audit Trail Database

    I am sitting in SSMS as 'sa'. I do not see any other databases besides GP databases. What would be the name of this database? I was suprised when they told me they did it from a workstation. I did not think it could reach out to the server and create the database.

  • Community Member Profile Picture
    Community Member on at
    Re: Audit Trail Database

    Audit Trails does create a seperate db from the company db.    It should be in the same instance as the company db.    Are you logged in as 'sa" when you go into the Install Audit Trails?

    Warren.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans