Advanced Cloud Security Documentation
Index

Compliance Log

The Compliance Log provides a complete audit trail of all tracked field changes and approval workflow events. This guide explains how to access, use, and manage the log.

What is the Compliance Log?

The Compliance Log records:

  • All changes to tracked fields
  • Approval request events
  • Approval/rejection decisions
  • Who did what, when

Accessing the Compliance Log

From ACS Main Page

  1. Search for Compliance Log
  2. Or navigate through compliance menu

From Record Pages

If compliance indicators are configured:

  1. Open a compliance-tracked record
  2. Click the compliance indicator
  3. View log entries for that record

Log Entry Information

Each log entry contains:

Field Description
Entry No. Unique identifier
Date/Time When the event occurred
Table No. The table that was modified
Table Name Human-readable table name
Field No. The field that was modified
Field Name Human-readable field name
Old Value Value before the change
New Value Value after the change
User ID Who made/approved the change
Event Type Change, Approval, Rejection, etc.
Status Logged, Pending, Approved, Rejected
Comments Approver comments

Log Entry Types

Event Type Description
Change Field modification detected
Request Approval request created
Approved Change was approved
Rejected Change was rejected
Canceled Request was canceled
Escalated Request was escalated

Filtering the Log

By Date

  1. Set Date Filter field
  2. Enter date range
  3. View filtered results

By Table

  1. Set Table Filter
  2. Select specific table
  3. View only that table's entries

By User

  1. Set User Filter
  2. Enter user ID
  3. View only that user's changes

By Status

  1. Set Status Filter
  2. Select status (Pending, Approved, etc.)
  3. View filtered entries

Combined Filters

Apply multiple filters together:

  • Date range + Table
  • User + Status
  • Any combination

Common Log Views

Pending Approvals

Filter by Status = Pending to see:

  • All changes awaiting approval
  • Who requested them
  • How long they've been pending

Recent Changes

Filter by Date = Today or This Week:

  • Recent compliance activity
  • Quick audit of changes
  • Spot unusual activity

Specific Table Audit

Filter by Table = Customer:

  • All customer field changes
  • Complete audit trail
  • Track specific records

User Activity

Filter by User = specific user:

  • What changes they've made
  • What they've approved/rejected
  • Activity history

Drill-Down Capabilities

View Record

From a log entry:

  1. Click View Record action
  2. Opens the source record
  3. See current state

View Request Details

For approval entries:

  1. Click Request Details
  2. See full approval history
  3. View all approvers' actions

Log Reports

Generating Reports

  1. Click Print or Report action
  2. Set filter criteria
  3. Choose output format
  4. Generate report

Report Types

Report Purpose
Change Log All field changes for period
Approval Log All approval activity
Pending Report Current pending requests
User Activity Changes by user

Export Options

  • Print to PDF
  • Export to Excel
  • Send via email

Audit Requirements

Regulatory Compliance

The log supports:

Requirement Support
SOX Complete audit trail
GDPR Data change tracking
HIPAA Healthcare data audit
Industry-specific Configurable tracking

Audit Best Practices

  1. Review log regularly
  2. Export and archive periodically
  3. Maintain log integrity
  4. Document retention policy

Log Retention

How Long to Keep

Consider:

  • Regulatory requirements
  • Business policy
  • Storage capacity
  • Audit needs

Archiving

  1. Export old entries
  2. Store in secure archive
  3. Remove from active log (if policy allows)
  4. Maintain chain of custody

Retention Policy

Document your policy:

  • Minimum retention period
  • Maximum retention period
  • Archive procedures
  • Destruction procedures

Log Security

Access Control

Only authorized users should view the log:

  • Administrators
  • Compliance officers
  • Auditors
  • Security personnel

Permission Requirements

Users need appropriate permissions:

  • Read access to Compliance Log table
  • May need specific compliance role

Log Integrity

The log should be:

  • Append-only (no editing)
  • Protected from deletion
  • Backed up regularly

Using the Log for Investigation

Investigating Issues

When investigating a problem:

  1. Identify the timeframe
  2. Filter to relevant table/field
  3. Review sequence of changes
  4. Identify users involved

Example Investigation

"Customer credit limit was increased incorrectly"

  1. Filter: Table = Customer, Field = Credit Limit
  2. Date: Last 30 days
  3. Review all credit limit changes
  4. Find the problematic change
  5. See who made it, when, approval status

Log Metrics

Activity Monitoring

Track:

  • Changes per day/week
  • Approvals pending
  • Rejection rate
  • Average approval time

Review patterns:

  • Unusual activity spikes
  • Users with many rejections
  • Bottleneck approvers

Best Practices

Regular Reviews

  • Daily review of pending items
  • Weekly summary of activity
  • Monthly audit review

Alert Configuration

Set alerts for:

  • High-volume changes
  • Critical field modifications
  • Rejected requests

Documentation

Maintain records of:

  • Log review dates
  • Issues identified
  • Actions taken

Troubleshooting

Missing Log Entries

  1. Verify tracking is enabled
  2. Check compliance table configuration
  3. Confirm extension was regenerated

Incorrect Data in Log

  1. Check field configuration
  2. Verify capture timing
  3. Review event triggers

Log Performance

If log queries are slow:

  1. Use date filters
  2. Archive old entries
  3. Check database indexes