Questions tagged [audit]
The audit tag has no usage guidance.
25
questions
0
votes
0
answers
123
views
Approach for comprehensive data/activity logging
I would like to be able to build up a log of user activities, capturing data such as who they were, where they logged in from, what activity did they take, and what data did they change (both before ...
1
vote
3
answers
203
views
What approach should I use for auditing config changes to achieve similar functions as Git blame?
We are storing our configuration files in S3. Each file is a JSON file. When config changes, the old file is backed up and a new file replaces it. These happen behind a service, where it also ...
3
votes
1
answer
353
views
How to maintain productivity while staying SOC 2 compliant?
I'm working for a software company (offering 99% SaaS stuff) that needs to be SOC 2 compliant – in my understanding simply because the company's clients require it. I've recently been told that (among ...
-1
votes
1
answer
422
views
Updating last resource access time when clients perform a GET
We have many clients which, upon start up, request a specific resource on the server using an HTTP API (not RESTful). This resource is - currently, identical for all clients.
Naturally, since the ...
1
vote
1
answer
2k
views
Simple Audit Logging Design
I have a C# MVC application. One of the requirements of the application is to maintain an audit log of everything that happens to a particular 'entity' page. To make the example concrete, lets say ...
6
votes
3
answers
2k
views
Database Auditing: "Updated At" Null or Not Null?
Currently, we've been working on the architecture team on defining the database models. What has been troubling me is my superior's advice when it comes to working with audit fields.
He advocates for ...
3
votes
2
answers
636
views
Should audit records have their own id?
I'm creating audit tables to track changes made to some of my crucial tables and I'm wondering whether there's a point to history rows having their own id. Here's how my interfaces look like:
public ...
1
vote
2
answers
3k
views
Auditing web application user changes
I have a web application written in Java, Oracle, and AngularJS. I want to save log in database when user changes, creates or updates something.
There are two way of implementing this:
1. Auditing ...
3
votes
1
answer
563
views
Where to store the "Who" and "When" of a Command and/or Event?
So much of the benefits around Event Sourcing apply to the being able to audit the system and show an aggregate's state throughout its life. However, I haven't been able to find any examples of where ...
2
votes
1
answer
260
views
Is taking a snapshot of UI to compare the data considered a good desicion?
If I have a complex attendance project to track the employees attendance and leaving, and according to that they get overtime money through a workflow.
The schedule is something like that :
6 weeks ...
1
vote
1
answer
2k
views
User-related logging in the microservices architecture
What is the best practice for logging user-related data in microservices architecture?
In example: I would like to audit/persist to database information on who deleted a resource.
I have user info on ...
0
votes
3
answers
167
views
Should an audit user column be nullable?
Consider following table structure, for the backend of a website:
[Article]
ArticleId
Text
TotalViews
AuditModifiedOn
AuditModifiedByUserId
[User]
UserId
An anonymous/not authenticated user visits ...
3
votes
2
answers
2k
views
Good practice to save the last time user accessed the app
Using a JWT authentication, the user doesn't have to log in each time he uses my app.
I would like to save in DB the last time the user used/opened the app.
Technically, I have a set of REST API ...
6
votes
0
answers
618
views
Audit trail for Rails app [closed]
I am looking to add an audit trail to our Rails app. At the moment, I am trying to lock down my requirements and determine the appropriate software architecture.
Our website gets about one hundred ...
4
votes
2
answers
417
views
Using audit trail as time machine?
I would like to do
SELECT * TABLE t (using data from 1st of march 2012)
I already have a nice audit trail of all tables in the database. It basically makes a copy of all rows that change, storing ...