FOB Loading audit trail

Comments

• Options

  RockWithNAV Member Posts: 1,139

  2016-03-29

  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/

  1
• Options

  Marko44 Member Posts: 2

  2016-03-29

  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

  0
• Options

  parm Member Posts: 49

  2016-03-30

  Hi,
  If you are using sql server and need this kind of audit you can implement this with sql triggers.
  
  Regards,
  
  parm

  0
• Options

  kriki Member, Moderator Posts: 9,089

  2016-04-01

  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!
  
  

  0