FOB Loading audit trail

Marko44

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

RockWithNAV

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.

Marko44

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

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

Regards,

parm

kriki

Best avoid SQL triggers. Better use Change Tracking on SQL Server (or Change Data Capture if you have Enterprise edition).