Activity Log
The Activity Log provides a comprehensive audit trail of all user actions and system events in DrillerDB. Use it for troubleshooting, compliance, and understanding how your team uses the system.
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:
- Go to Settings > Activity Log
- View recent activity in chronological order
- Use filters to narrow results
- 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
Useful for understanding 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
- Concurrent session monitoring
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.