Audit trail

Clicking the Audit log link in the top menu bar displays the audit trail. The most recent 100 lines are shown by default; click the Show all button to see the entire log. The audit trail is a plain text file which can be downloaded if required using the Download button. The log records all significant events and changes to the data including:

Data entry and editing of forms
Creation and adding messages to queries
Creation and editing of sites
Randomisations
Unblinding
Movement of blocks within code lists
Uploads
Downloads from the system such as reports in CSV format, CRF data, archives, code list and the audit trail itself

The audit trail

An example extract from a log is shown below. The items shown in each row of the log are (from left to right):

IP address of the user who initiated the event
Name and user ID of the user
URL
Server date and time (including GMT offset)
Notice level - usually this will be "INFO (6)"
Message

Where applicable, the message contains information on the data before and after the event. Some events might generate several related messages - such as an explanatory note

"Edited form Eligibility Criteria Check At Recruitment for Patient SDN01"

plus a change in the data:

"Row in crfBaselineEligibilityCriteria for: {"id" : "1"}, changed From: {"updated" : "2022-07-22 17:45:47","reasonForEdit":null ..."

Example extract

100.2.3.4 "Simon Admin (ID 2) (ID 11116)" "/redpill/demo/site/add" [2021-05-05T15:03:24+00:00] INFO (6): Added site 1: St Patrick's University Hospital, United Kingdom
100.2.3.4 "Simon Admin (ID 2) (ID 11116)" "/redpill/demo/crf/add/SubjectRegistration/0/f1779aa4a1b182bf42c5d419ae70420b" [2021-05-05T15:05:22+00:00] INFO (6): Row inserted to crfSubjectRegistration: {"id" : "1", "version" : "1", "subjectId" : "1", "siteId" : "1", "userIdentifier" : "Simon Admin (ID 2) (ID 11116)", "lastUserIdentifier" : "Simon Admin (ID 2) (ID 11116)", "created" : "2021-05-05 15:05:22", "updated" : "2021-05-05 15:05:22", "validationStatus" : "Not validated", "reasonForEdit" : null, "validationNotes" : null, "validationOverrides" : "{}", "uploadId" : null, "identifier" : "1-001", "PatientInitials" : "FN", "DateOfRegistration" : "2021-05-05", "Haemoglobin" : "20", "Gender" : "Female", "PregnancyTest" : "Yes", "Death" : "Yes"}
100.2.3.4 "Simon Admin (ID 2) (ID 11116)" "/redpill/demo/crf/add/SubjectRegistration/0/f1779aa4a1b182bf42c5d419ae70420b" [2021-05-05T15:05:22+00:00] INFO (6): Added form Subject registration for Subject 1-001
100.2.3.4 "Gemma Nurse (ID 59) (ID 59)" "/redpill/demo/crf/add/SubjectRegistration/0/c5c38b37660212864ffc03abff31009f" [2022-03-11T15:08:57+00:00] INFO (6): Row inserted to crfSubjectRegistration: {"id" : "2", "version" : "1", "subjectId" : "2", "siteId" : "1", "userIdentifier" : "Gemma Nurse (ID 59) (ID 59)", "lastUserIdentifier" : "Gemma Nurse (ID 59) (ID 59)", "created" : "2022-03-11 15:08:57", "updated" : "2022-03-11 15:08:57", "validationStatus" : "Not validated", "reasonForEdit" : null, "validationNotes" : null, "validationOverrides" : "{}", "uploadId" : null, "identifier" : "1-002", "PatientInitials" : "aa", "DateOfRegistration" : "2022-03-02", "Haemoglobin" : "12", "Gender" : "Male", "PregnancyTest" : null, "Death" : "No"}
100.2.3.4 "Gemma Nurse (ID 59) (ID 59)" "/redpill/demo/crf/add/SubjectRegistration/0/c5c38b37660212864ffc03abff31009f" [2022-03-11T15:08:57+00:00] INFO (6): Added form Subject registration for Subject 1-002
100.2.3.4 "Gemma Nurse (ID 59) (ID 59)" "/redpill/demo/query/create/2/" [2022-03-11T15:09:16+00:00] INFO (6): Row inserted to query: {"id" : "1", "subjectId" : "2", "created" : "2022-03-11 15:09:16", "title" : "test", "formName" : null, "formId" : null, "status" : "Open"}
100.2.3.4 "Gemma Nurse (ID 59) (ID 59)" "/redpill/demo/query/create/2/" [2022-03-11T15:09:16+00:00] INFO (6): Row inserted to queryMessage: {"id" : "1", "queryId" : "1", "userId" : 59, "userIdentifier" : "Gemma Nurse (ID 59) (ID 59)", "created" : "2022-03-11 15:09:16", "statusAction" : "Open", "comment" : "test"}