Audit Logs

Overview

DB24x7 maintains detailed audit logs of all activities within your database infrastructure. These logs provide visibility into user actions, system events, and security-related activities, enabling compliance, troubleshooting, and security monitoring.

What is Logged

DB24x7 captures a comprehensive range of events across different categories to provide complete audit trail visibility.

Authentication Events

Authorization Events

Database Operations

API and Integration Events

Configuration Changes

Security Events

Log Entry Structure

Each audit log entry contains comprehensive metadata to provide context and enable effective analysis.

Standard Fields

Example Log Entry

{
  "id": "log_2kJ9xM5pQw1zN3R7",
  "timestamp": "2026-02-07T14:23:45.123Z",
  "event_type": "database.query",
  "action": "execute",
  "actor": {
    "id": "user_abc123",
    "email": "[email protected]",
    "type": "user"
  },
  "resource": {
    "id": "db_xyz789",
    "name": "production_analytics",
    "type": "database"
  },
  "result": "success",
  "ip_address": "203.0.113.42",
  "user_agent": "DB24x7-Client/2.1.0",
  "metadata": {
    "query_duration_ms": 1250,
    "rows_affected": 15420,
    "query_type": "SELECT"
  }
}

Accessing Audit Logs

DB24x7 provides multiple ways to access and analyze audit logs, from the web interface to programmatic access via API.

Web Dashboard

1. Navigate to Settings Organization Audit Logs
2. Use filters to narrow down logs by time range, event type, user, or resource
3. Click on any log entry to view full details
4. Export results as CSV or JSON for offline analysis

Search and Filtering

API Access

Programmatically retrieve audit logs using the REST API:

curl -X GET "https://api.db24x7.com/v1/audit-logs" \
  -H "Authorization: Bearer YOUR_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "start_date": "2026-02-01T00:00:00Z",
    "end_date": "2026-02-07T23:59:59Z",
    "event_type": "database.query",
    "limit": 100
  }'

Log Retention Policies

Audit logs are retained according to your subscription plan and compliance requirements.

Retention by Plan

Archival Options

For long-term storage beyond the retention period:

• Export logs regularly to your own storage (S3, Azure Blob, etc.)
• Configure automatic log forwarding to archive storage
• Use SIEM integration for centralized log management
• Export compressed log bundles for offline archival

Exporting Logs

Export audit logs in multiple formats for analysis, compliance reporting, or long-term archival.

Export Formats

Manual Export

1. Navigate to Settings Organization Audit Logs
2. Apply desired filters for the logs you want to export
3. Click "Export" button in the top right
4. Select export format (CSV, JSON, or NDJSON)
5. Download will begin automatically (large exports may be emailed)

Automated Export

Configure scheduled exports to automatically archive logs:

1. Go to Settings Organization Audit Logs Export
2. Click "Configure Automated Export"
3. Set export frequency (daily, weekly, monthly)
4. Choose destination (email, S3, SFTP, webhook)
5. Select format and filters
6. Save configuration

SIEM Integration

Stream audit logs in real-time to your Security Information and Event Management (SIEM) solution for centralized monitoring and correlation.

Supported SIEM Platforms

Setting Up SIEM Integration

1. Navigate to Settings Organization Integrations
2. Click "Add Integration" and select your SIEM platform
3. Configure connection details (endpoint, API key, etc.)
4. Select which log types to forward (all or specific event types)
5. Test the connection to verify logs are flowing
6. Enable the integration and monitor delivery metrics

Compliance Reporting

Generate compliance reports from audit logs to demonstrate adherence to regulatory requirements.

Pre-Built Report Templates

Generating Compliance Reports

1. Go to Settings Organization Audit Logs Reports
2. Select a pre-built report template or create custom
3. Choose date range (monthly, quarterly, annually)
4. Configure additional filters if needed
5. Generate report (PDF or Excel format)
6. Schedule recurring reports for automatic compliance tracking

Compliance Standards Supported

Related Documentation