Activity Log

The Activity Log provides a complete audit trail of all user actions and system events in DrillerDB. Use it for troubleshooting, compliance, and understanding how your team uses the system.

Quick Start: View Activity Log

1. Go to Settings > Activity Log
2. View recent activity (newest first)
3. Use filters to narrow by user, date, or type
4. Click any entry for full details
5. Export logs as needed for compliance

Step-by-Step Workflow

1. Go to Settings > Activity Log
2. View recent activity (newest first)
3. Use filters to narrow by user, date, or type
4. Click any entry for full details
5. Export logs as needed for compliance

Activity Overview

What Gets Logged

DrillerDB automatically tracks these activities:

User Actions

• Login and logout events
• Password changes
• Account modifications
• Role changes

Project Events

• Project creation and deletion
• Status changes
• Assignment changes
• Field updates

Financial Activities

• Invoice creation and modification
• Payment processing
• Down payment recording
• Refund transactions

Customer Interactions

• Contact additions and updates
• Customer portal access
• Quote views and clicks
• Proposal approvals

System Events

• Integration sync events
• Email delivery status
• Export operations
• Settings changes

Document Actions

• File uploads
• Document downloads
• PDF generation
• Report exports

Activity Retention

Activity logs are retained:

• Active Records: Indefinite retention
• User Actions: Minimum 1 year
• System Events: 90 days standard
• Compliance Logs: 7 years (financial activities)

Administrators can export logs for long-term archival.

Viewing Activity

Activity Log Interface

Access the activity log:

1. Go to Settings > Activity Log
2. View recent activity in chronological order
3. Use filters to narrow results
4. Click any entry for full details

Log Entry Details

Each log entry includes:

• Timestamp - Exact date and time
• User - Who performed the action
• Action Type - What was done
• Target - What was affected (project, customer, etc.)
• IP Address - Where action originated
• Details - Specific changes made
• Status - Success or failure

Real-Time Updates

Activity log updates automatically:

• New entries appear without refresh
• Live activity indicators
• Real-time user presence
• Streaming updates

Filtering Activities

Basic Filters

Narrow down log entries:

By User

• Show actions by specific user
• Include or exclude certain users
• Filter by role

By Date Range

• Last 24 hours
• Last 7 days
• Last 30 days
• Custom date range

By Activity Type

• Project activities
• Financial events
• User actions
• System events

Advanced Filters

Combine multiple criteria:

Multi-Filter Search

• User + date range + activity type
• Project-specific activities
• Customer-related events
• Failed actions only

Saved Filters

• Save frequently-used filters
• Quick access to common views
• Share filters with team
• Default filter preferences

Search Functionality

Searching Activity

Find specific events:

Search Fields

• User name
• Project number or name
• Customer name
• IP address
• Action description

Search Operators

• Exact match
• Contains text
• Starts with
• Date comparisons

Search Results

Search results display:

• Relevance-ranked entries
• Highlighted search terms
• Quick navigation to details
• Export search results

Activity Details

Detailed View

Click any entry to see complete information:

Action Details

• Full description of action
• Before and after values
• Related records affected
• Automatic vs. manual action

User Context

• User name and role
• Login session details
• Device and browser information
• Geographic location

Impact Analysis

• What changed
• Who was affected
• Related activities
• Reversal or undo information

Change Tracking

For modification events, see:

• Old Value - Previous state
• New Value - Updated state
• Field Changed - Specific field modified
• Change Reason - If provided by user

This helps you understand exactly what changed and why.

User Activity Reports

Activity Summary

Generate user activity reports:

Metrics Included

• Total actions per user
• Most common activities
• Login frequency
• Time spent in application
• Projects accessed

Time Analysis

• Activity by hour of day
• Busiest days of week
• Seasonal patterns
• Peak usage times

Feature Usage

• Most-used features
• Rarely-used features
• Feature adoption rates
• Training opportunities

Productivity Insights

Understand how team works:

• Projects created per user
• Invoices generated
• Reports run
• Customers added
• Time in specific modules

Use insights to optimize workflows and identify training needs.

Security & Compliance

Security Monitoring

Track security-related events:

Login Activity

• Successful logins
• Failed login attempts
• Password resets
• Account lockouts

Access Patterns

• Unusual access times
• Login from new locations
• Multiple concurrent sessions
• Suspicious activity indicators

Permission Changes

• Role modifications
• Permission grants
• Admin access usage
• Settings modifications

Failed Actions

Monitor failed attempts:

• Failed login attempts by user
• Unauthorized access attempts
• Failed API calls
• Error events

Multiple failures may indicate:

• Training needs
• System issues
• Security threats
• Integration problems

Compliance Auditing

Activity log supports compliance requirements:

Financial Compliance

• Who created/modified invoices
• Payment processing audit trail
• Refund authorization tracking
• Tax-related changes

Data Privacy

• Customer data access log
• Data export activities
• Customer portal access
• Email delivery tracking

System Integrity

• Configuration changes
• User management actions
• Integration activity
• Backup and restore events

Exporting Activity Data

Export Options

Export activity logs for analysis:

Export Formats

• CSV for spreadsheet analysis
• PDF for printed reports
• JSON for system integration
• Excel with formatting

Export Filters

• Export filtered results only
• Include all details
• Summary view
• Custom column selection

Scheduled Reports

Automate activity reporting:

• Daily activity summary
• Weekly security report
• Monthly compliance report
• Custom schedule

Reports can be:

• Emailed automatically
• Saved to cloud storage
• Sent to external systems
• Posted to internal dashboards

Notifications for Activity

Activity Alerts

Set up notifications for specific activities:

Alert Triggers

• Failed login attempts (threshold)
• Role changes
• Large data exports
• After-hours access
• Configuration changes

Alert Recipients

• Administrators
• Security team
• Specific users
• External monitoring

Real-Time Monitoring

For security-sensitive environments:

• Live activity dashboard
• Real-time alert feed
• Active user display

Privacy Considerations

What Users Can See

Regular Users

• Their own activity only
• Project activity they're involved in
• Cannot see other users' actions

Office Users

• Project-related activity
• Customer interaction logs
• Cannot see admin activities

Administrators

• All activity logs
• Security events
• Configuration changes
• Complete system activity

Privacy Controls

Protect sensitive information:

• Mask financial details for non-admins
• Hide customer data based on permissions
• Redact sensitive field values
• Comply with privacy regulations

Activity logging balances transparency with privacy protection.

Troubleshooting

Activity not showing?

• Verify date filter range includes event
• Check user filter isn't excluding entries
• Some actions may have slight delay

Export failing?

• Try narrower date range
• Check internet connection
• Try different export format

Related Topics

• Users & Access - User management
• User Roles - Permission levels
• Security Settings - Security features
• Notification Settings - Alert preferences