Stack Overflow
Stack Overflow

Questions tagged [audit-trail]

An audit trail (also called audit log) is a security-relevant chronological record, set of records, and/or destination and source of records that provide documentary evidence of the sequence of activities that have affected at any time a specific operation, procedure, or event.

296 questions
3
votes
3 answers

Dynamic SQL - Picking the values from the temp table

I have a temp table that has the following information. TableName ColumnName PrimaryKeyColumnName Primarykey(A GUID) (4 columns) I need to include one more new column Value that should grab data based on the condition below "for each row in the…
vikram
  • 69
  • 6
3
votes
1 answer

How to add a User in Grails Bootsrap with Audit Trails on?

Hi I'm having a hard time trying to add the first user in my grails bootstrap. I've tried many different ways but all have failed since the Audit Trail plugin wants a user to stamp the createdBy and EditedBy fields but the first one doesn't exit…
Zaccak Solutions
  • 249
  • 3
  • 10
3
votes
1 answer

How does one display the time portion in the devexpress xaf audittrail module's listview

Adding the following code to the business object private XPCollection changeHistory; public XPCollection ChangeHistory { get { if (changeHistory == null) …
Eminem
  • 7,206
  • 15
  • 53
  • 95
3
votes
1 answer

ORM with built-in audit trail

I am designing an ASP.NET MVC web app with a database backend that requires a full audit trail for regulatory purposes. I've implemented audit trails in the past but it feels like I would be safer using an ORM tool with built-in features for this.…
alexsome
  • 463
  • 3
  • 16
2
votes
1 answer

Audit netlink response don't have the right packet length

I have been trying to read the linux audit logs from go using mdlayher/netlink. I am able to make a connection and set the PID as well to be able to receive logs from the netlink socket over unicast and multicast. The problem is, when the library…
prateeknischal
  • 752
  • 4
  • 12
2
votes
2 answers

How to redirect jenkins.security.SecurityListener logs to a log file on a linux host

I have setup a logger on my jenkins server for jenkins.security.SecurityListener logs. I can view the logs in the webportal but I cannot find where the are stored on the server. I want to be able access these logs on the server.
user1951756
  • 471
  • 1
  • 8
  • 23
2
votes
1 answer

Does CLOCK_TIMESTAMP from a BEFORE trigger match log/commit order *exactly* in PG 12.3?

I've got a Postgres 12.3 question: Can I rely on CLOCK_TIMESTAMP() in a trigger to stamp an updated_dts timestamp in exactly the same order as changes are committed to the permanent data? On the face of it, this might sound like kind of an silly…
Morris de Oryx
  • 1,857
  • 10
  • 28
2
votes
3 answers

Using DVCS for an RDBMS audit trail

I'm looking to implement an audit trail for a reasonably complicated relational database, whose schema is prone to change. One avenue I'm thinking of is using a DVCS to track changes. (The benefits I can imagine are: schemaless history, snapshots of…
Will Hardy
  • 14,588
  • 5
  • 44
  • 43
2
votes
2 answers

How can I retrieve an id from MongoDB create operation during a transaction?

I am trying to create an audit trail using Apollo Server and Mongoose. When a user initially registers, I create a document in the users collection and a document in the history collection for each piece of data they provided (username, password,…
gregg
  • 35
  • 3
2
votes
5 answers

Log inserted/updated/deleted rows in all tables for a given database in SQL Server 2008

Whats the best way to track/Log inserted/updated/deleted rows in all tables for a given database in SQL Server 2008? Or is there a better "Audit" feature in SQL Server 2008?
Sam P
  • 515
  • 4
  • 8
  • 23
2
votes
0 answers

Linq to Entities Auditing Relationship Updates

I am trying to implement generic auditing in my Linq to Entities Object Context. I have achieved this for the most part with the built in ObjectStateEntry approach, however with this I have identified a flaw and was wondering if there was a way…
Stuart Ferguson
  • 367
  • 3
  • 16
2
votes
1 answer

How can I audit the individual functions/procedures inside package

Im trying to set up some audit in our database to figure out which functions/procedures we use but have come to a stop when trying to audit the executions of my individual functions inside my packages. I can set up audit for various…
Brian Bjørngaard
  • 41
  • 5
2
votes
0 answers

How to log Jupyter notebook inputs for auditing purposes?

I'm working in an environment where, due to recent developments in auditing requirements, it has become necessary to log all Jupyter Notebook inputs when a user is accessing data, i.e. create an audit trail. The minimum requirement is to log all…
soolo
  • 31
  • 3
2
votes
1 answer

Audit table design suggestions

Is it the correct approach? Any suggestions to make it better? Below is screenshot of employee table and its shadow table where the tl_name and dept fields may change and currently using shadow table to track all changes. Records are…
Santosh
  • 12,175
  • 4
  • 41
  • 72
2
votes
0 answers

Alfresco audit: show user's OS

I want Alfresco's audit to show, for each logged action, what was the operating system of the user. For instance, if a user delete a document using Firefox on Ubuntu Linux 16.10, the audit line would have the information Ubuntu Linux 16.10. Showing…
Nicolas Raoul
  • 58,567
  • 58
  • 222
  • 373
1 2 3
…
19 20