FOB Loading audit trail

Marko44
Marko44 Member Posts: 2
in NAV Three Tier
Hi, does anyone know if internal to Nav 2016 there is a record of when fob files are loaded and by whom?

Many Thanks

Mark

Comments

  • RockWithNAV
    RockWithNAV Member Posts: 1,172
    Hey Marko44,

    There's a virtual table named Object which consist all the specific information's like Date Time Caption Version etc. But it wont show who imported. Secondly it shows the same information what you see on Object Designer.
    Thanks

    Blog - rockwithnav.wordpress.com/
    Twitter - https://twitter.com/RockwithNav
    Facebook - https://facebook.com/rockwithnav/
  • Marko44
    Marko44 Member Posts: 2
    Hi RockwithNav, thanks for the help, I knew Object Designer contains captions, dates time etc. I was hoping that username would be recorded somewhere as well but it doesn't look to be the case.

    Cheers

    Marko
  • parm
    parm Member Posts: 49
    Hi,
    If you are using sql server and need this kind of audit you can implement this with sql triggers.

    Regards,

    parm
  • kriki
    kriki Member, Moderator Posts: 9,121
    Best avoid SQL triggers. Better use Change Tracking on SQL Server (or Change Data Capture if you have Enterprise edition).
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

Categories