Stack Overflow
Stack Overflow

Questions tagged [audit-logging]

Audit-logging is the practice of keeping records of system activity

Audit-logging is the practice of keeping records of system activity. Audit logging does not contain information about the technical operation of a system, like print statements, but rather keeps track of discrete events that occur within a system. Examples are "User X accessed data Y at Time T", etc.

389 questions
1
vote
0 answers

Is it recommended to use write ahead logs instead of db triggers for audit logging of table changes?

In a microservices environment using postgresql, what would be the best method of capturing audit logs for table changes? Need to not impact too much of DB performance and also capture a reliable log of database table changes and/or DDLs and the…
Reivax
  • 33
  • 2
1
vote
2 answers

TypeORM / MySQL - Intercept Update/Insert Queries and set app user ID automatically on 'editedBy' column

I am using TypeORM with MySQL and am setting up automatic auditing of all columns and database tables via MySQL Triggers - not TypeORM's "Logger" feature (unless you have some extra info)... Without getting bogged down, the MySQL Triggers approach…
Chooka
  • 35
  • 1
  • 5
1
vote
0 answers

Audit log in spring boot

We have microservice architecture application in spring boot. We are planning to add an audit logs to our services. So that we can get the information like, Admin123 deactivated User123 User123 changed the password User123 logged in High…
Sangeeth
  • 335
  • 3
  • 13
1
vote
1 answer

Best way to audit of REST API

I am planning to implement audit trail of my incoming HTTP request . I was thinking of having some kind of gateway which will redirect every incoming call to 2 server i.e. one is where actual logic written and second will be pass each incoming…
Sudhanshu Agarwal
  • 11
  • 1
  • 5
1
vote
1 answer

Indexing In ElasticSearch For Auditing

There is a microservice-based architecture wherein each service has a different type of entity. For example: Service-1: { "entity_type": "SKU", "sku": "123", "ext_sku": "201", "store": "1", "product": "abc", "timestamp":…
User_Targaryen
  • 4,125
  • 4
  • 30
  • 51
1
vote
0 answers

Audit logging of various user operations in multiple microservices

I have 7 micro-services and web-app to access REST calls. I want to log the operations user performing for any backend call. I am thinking to implement audit-log micro-service which has just one DB table and just one RESTful operation. Every time…
Yeshwant KAKAD
  • 279
  • 1
  • 6
  • 16
1
vote
0 answers

What does this DDL Audit example provide

Can someone explain this code line by line? I would like to understand the purpose and effect of each line this code has. This code is from Microsoft and doesn't have the best description of what is going on. I plan to use this code and would like…
ERich
  • 21
  • 4
1
vote
0 answers

Compare two pojo and output difference to another pojo

I have a pojo class as follows. public class Person { private String name; private Address address; public String getName() { ... } public Address getAddress() { ... } //Address bean public void setName() { ... } public void…
smilyface
  • 5,021
  • 8
  • 41
  • 57
1
vote
1 answer

My query sys.database_audit_specification does't send back any record

I'm studying about SQL Server Audit. I have deployed Server Audit Specification. Now I want to query all the records but It doesn't return anything. I use Windows Server 2012 Datacenter - SQL Server 2014 Developer Version use master go select * from…
mtpumpkin
  • 21
  • 2
1
vote
1 answer

Fetching all changes made by a user in hibernate envers

In hibernate envers, I can get all changes made to an entity by using the following piece of code: AuditQuery aq = auditReader.createQuery().forRevisionsOfEntityWithChanges(DummyEntity.class, false); But is there a way to get all the changes made…
Kshitij Bajracharya
  • 811
  • 2
  • 14
  • 37
1
vote
1 answer

How to add audit logging with IdentityServer

We are creating an security token service using IdentityServer4. Due to audit requirements, we would like to log every succeeded (and failed) login attempt, together with information about the issued token, in particular: which claims the token…
Julian
  • 20,008
  • 17
  • 77
  • 108
1
vote
1 answer

How to add multiple filters on Server Audit of SQL Server?

I want to filter SQL Audits so that I do not want to capture events triggered by certain users and certain schema. In one of the existing Server Audit, I found the filter predicate as ( [schema_name]<>'sys' AND…
Merin Nakarmi
  • 3,148
  • 3
  • 35
  • 42
1
vote
1 answer

How to handle User Audit Logs (or other frequent client-side actions) in a Web App?

Architectural question here. I have a Web App (HTML5/Javascript/AngularJS) which logs user activity into a Backend DB via Web API. This function runs quite frequently on events such as Menu and button Clicks throughout the app. Making an API call…
kob490
  • 3,177
  • 4
  • 25
  • 40
1
vote
0 answers

How many sql audit files can function sys.fn_get_audit_file can read at once?

I know function sys.fn_get_audit_file can read multiple .sqlaudit files at once. But I could not find any information regarding maximum number of files this function can read. Any idea about the file number limitation? Also I need to monitor…
Merin Nakarmi
  • 3,148
  • 3
  • 35
  • 42
1
vote
1 answer

Track the changes of a few columns in an existing table leveraging primary keys?

I'm currently trying to track the changes of a few columns (let's call them col1 & col2) in a SQL Server table. The table is not being "updated/inserted/deleted" over time; new records are just being added to it (please see below 10/01 vs 11/01).…
Jeremie
  • 65
  • 1
  • 7
1 2 3
…
25 26