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
1 answer

How can I turn off mysql audit log while server is running?

I do have a highly active server and can't restart it. Long back I have activated the audit log but due to space issue I need to turn it off. Below are my variables; audit_log_buffer_size | 1048576 | audit_log_connection_policy | ALL …
Kourosh Samia
  • 127
  • 3
  • 10
1
vote
1 answer

Application logging with object serialization

I'm implementing logging in web service application with following requirements: log should be stored in database log should be machine-readable (every bit of information should be stored in separate column) log should be extensible (client code…
Vitaliy
  • 702
  • 6
  • 19
1
vote
1 answer

tracking actual changes in rows when updating table

I have a table which i keep on updating, from the values of other source in my code. The value I update may or may not be same as the value already in the row. I need some kind of algorithm may be via mysql (db) or otherwise (part of code) so that I…
user1482800
  • 83
  • 2
  • 12
1
vote
1 answer

Audit Trails for Adding/Modifying Fields, Tables, Layouts, Scripts in Filemaker 13

Is there a way to implement audit trails eg. by scripting or 3rd-party plugin that track Adding Fields, Modifying Field Types, Adding Tables, Adding Layouts etc. in Filemaker 13, whichever the version - Prop, Advanced, or Server etc.?
forgodsakehold
  • 870
  • 10
  • 26
1
vote
1 answer

use of separate sequence for tables in hibernate envers

I know that hibernate envers uses same sequence for all the audit tables it generates but in my database there are more than 100 tables and they contain millions of data records so I want to use separate sequence for all the tables. Kindly suggest…
rishi
  • 1,792
  • 5
  • 31
  • 63
1
vote
1 answer

How to audit a trigger on DB2?

My question is very simple, i'm working with WebSphere Commerce and DB2 , i have my own trigger on db2 . I need to see on a log file when the trigger starts and when the trigger ends . Which log file have this information on DB2? Grettings from…
Diego
  • 13
  • 5
1
vote
1 answer

Making a Logback Audit Logger Wrapper

I'm working on writing a class that works as a wrapper for a Logback Logger. Specifically it is to facilitate Audit logging. It should be an independent library that people should be able to import and use. The problem I've having has to do with the…
1
vote
1 answer

Get reference to domain id in grails audit-logging plugin

I'm trying to use grails audit-logging plugin. It seems to do what I need to do. But, I'm having problem referencing id for a domain class where id is automatically generated. class Person { static auditable = true String name String email …
TheKojuEffect
  • 20,103
  • 19
  • 89
  • 125
1
vote
1 answer

How to Purge CQ Audit Log of Pages

The only reference I found online regarding purging audit log of CQ pages is here. However, it is not clear as to how do I go about doing it. Say .... purge audit log that are older than 60 days of pages in my repository. The audit logs are stored…
hko19
  • 1,054
  • 4
  • 16
  • 25
1
vote
2 answers

SQL trigger for audit table getting out of sync

I recently created a SQL trigger to replace a very expensive query I used to run to reduce the amount of updates my database does each day. Before I preform an update I check to see how many updates have already occurred for the day, this used to be…
bfritz
  • 2,416
  • 2
  • 20
  • 29
1
vote
1 answer

find past, *not current*, login information

I am aware of how to find info on current sessions and their users (sp_who2, sp_WhoIsActive, ...) How can I retrieve such info for the past? I could not find info on that. Simply put, my question is: Who was logged in? From when to when? What…
Der U
  • 3,192
  • 1
  • 12
  • 13
1
vote
1 answer

SQL Server Express 2012. Creating an audit using profiler

SQL Server 2012. Using SQL Server Profiler. How can I set the trace to only display to the results table audit type details? Such as whoever logged in, when a user makes a CRUD query, date and time etc. Just to be able to log and see who made…
user2173602
1
vote
2 answers

SQL Server Audit Logs - copy current log file

How do I get SQL Server to release the current audit log file and start a new one? We need to move our audit log files to another location, which we do nightly. However since there is little activity to log, the file rarely reaches the size at which…
Phaedrus
  • 793
  • 1
  • 10
  • 17
1
vote
0 answers

Audit log plugin - Log deleted object?

Great plugin, really helpful. http://grails.org/plugin/audit-logging However, I have a question on Delete events being logged, so currently if an object is deleted (hard delete) is there a way to track some of the attributes of the deleted object…
Abhay
  • 401
  • 3
  • 12
1
vote
1 answer

Addition of Audit Trails to a SaaS Platform

I am trying to add compliance mechanisms to a SaaS platform. I wanted to add audit trails in it. Well, the first thing I have decided is to log all the successful/un-successful attempts in authorization module. Then I need to audit all the…