AuditSphere - User Guide
Table of Contents
- Introduction
- Getting Started
- Initial Setup
- Dashboard Overview
- Connecting Microsoft 365
- Monitoring Activity
- Anomaly Detection
- Compliance Monitoring
- Managing Alerts
- Access Reviews
- Reports
- Settings & Configuration
- Troubleshooting
Introduction
AuditSphere is a comprehensive security and compliance monitoring platform for Microsoft 365 SharePoint and OneDrive environments. It helps organizations:
- Monitor user activity and file access in real-time
- Detect anomalous behavior using machine learning
- Assess compliance against industry standards (CIS Benchmarks)
- Review and manage access permissions systematically
- Generate reports for auditing and compliance evidence
Getting Started
System Requirements
- Modern web browser (Chrome, Firefox, Edge, Safari)
- Microsoft 365 tenant with appropriate admin permissions
- Valid user account with assigned role (Admin, Analyst, or Viewer)
Accessing AuditSphere
- Navigate to your organization's AuditSphere URL
- Click Sign In to authenticate
- You will be redirected to your identity provider
- Enter your credentials and complete authentication
- Upon successful login, you'll be directed to the Dashboard
Initial Setup
First-Time Administrator Setup
If you're setting up AuditSphere for your organization for the first time:
Step 1: Environment Configuration
The following environment variables must be configured by your administrator:
| Variable | Description |
|---|---|
DATABASE_URL | PostgreSQL connection string |
AUTH0_CLIENT_ID | Identity provider client ID |
AUTH0_CLIENT_SECRET | Identity provider secret |
AUTH0_ISSUER_BASE_URL | Identity provider URL |
MICROSOFT_CLIENT_ID | Microsoft app registration ID |
MICROSOFT_CLIENT_SECRET | Microsoft app secret |
MICROSOFT_TENANT_ID | Your Microsoft 365 tenant ID |
NEXTAUTH_SECRET | Session encryption key |
NEXTAUTH_URL | Application base URL |
Step 2: Microsoft App Registration
- Go to Azure Portal > App Registrations
- Create a new registration for AuditSphere
- Configure the redirect URI to:
{YOUR_APP_URL}/api/microsoft/callback
Required API Permissions
Configure the following permissions in your app registration:
Microsoft Graph Permissions:
| Permission | Type | Description | Admin Consent |
|---|---|---|---|
AuditLog.Read.All | Delegated | Read audit log data | Yes |
AuditLog.Read.All | Application | Read all audit log data | Yes |
Directory.Read.All | Delegated | Read directory data | Yes |
Directory.Read.All | Application | Read directory data | Yes |
Files.Read | Delegated | Read user files | No |
Files.Read.All | Delegated | Read all files that user can access | No |
Files.ReadWrite.All | Application | Read and write files in all site collections | Yes |
GroupMember.ReadWrite.All | Application | Read and write all group memberships | Yes |
IdentityRiskyUser.Read.All | Application | Read all identity risky user information | Yes |
Mail.ReadWrite | Application | Read and write mail in all mailboxes | Yes |
Mail.Send | Application | Send mail as any user | Yes |
offline_access | Delegated | Maintain access to data you have given it access to | No |
SecurityAlert.Read.All | Application | Read all security alerts | Yes |
SecurityEvents.Read.All | Delegated | Read your organization's security events | Yes |
SecurityEvents.Read.All | Application | Read your organization's security events | Yes |
SharePointTenantSettings.ReadWrite.All | Application | Read and change SharePoint and OneDrive tenant settings | Yes |
Sites.FullControl.All | Application | Have full control of all site collections | Yes |
Sites.Manage.All | Application | Create, edit, and delete items and lists in all site collections | Yes |
Sites.Read.All | Delegated | Read items in all site collections | No |
Sites.Read.All | Application | Read items in all site collections | Yes |
User.Read | Delegated | Sign in and read user profile | No |
User.Read.All | Delegated | Read all users' full profiles | Yes |
User.Read.All | Application | Read all users' full profiles | Yes |
Office 365 Management APIs Permissions:
| Permission | Type | Description | Admin Consent |
|---|---|---|---|
ActivityFeed.Read | Application | Read activity data for your organization | Yes |
ActivityFeed.Read | Delegated | Read activity data for your organization | Yes |
SharePoint Permissions:
| Permission | Type | Description | Admin Consent |
|---|---|---|---|
Sites.FullControl.All | Application | Have full control of all site collections | Yes |
- Grant admin consent for all permissions in your organization
Expose an API Configuration
- Navigate to Expose an API in your app registration
- Set the Application ID URI (e.g.,
api://{your-client-id}) - Add a scope with the following settings:
- Scope name:
access_as_user - Who can consent: Admins and users
- Admin consent display name: Access AuditSphere API
- User consent display name: Access AuditSphere
- State: Enabled
- Scope name:
- If using a separate frontend client, add it under Authorized client applications with the scope selected
Authentication Configuration
- Go to Authentication in your app registration
- Add platform configuration for Web
- Add redirect URI:
{YOUR_APP_URL}/api/microsoft/callback - Enable Access tokens and ID tokens under Implicit grant
Create Client Secret
- Go to Certificates & secrets
- Create a new client secret
- Copy the secret value immediately (it won't be shown again)
- Add the secret to your environment configuration as
MICROSOFT_CLIENT_SECRET
Step 3: Database Setup
Run the database migration to create required tables:
npm run db:generate
npx prisma migrate deployStep 4: Start the Application
# Development mode
npm run dev
# Production mode
npm run build
npm startDashboard Overview
The Dashboard is your central hub for monitoring security status.
Dashboard Components
Quick Stats Cards
- Total Events (24h): Number of audit events in the last 24 hours
- Anomalies Detected: Open anomalies requiring attention
- Active Alerts: Security alerts requiring action
- Compliance Score: Overall compliance percentage
Connection Status
The Microsoft 365 connection indicator shows:
- Connected (green): Successfully connected to your tenant
- Disconnected (red): No active connection - action required
Activity Overview
Visual charts showing:
- Event trends over time
- Event distribution by type
- User activity patterns
Navigation Menu
| Menu Item | Description |
|---|---|
| Dashboard | Main overview page |
| Activity | Detailed audit event logs |
| Anomalies | ML-detected unusual behavior |
| Compliance | Compliance check results |
| Alerts | Security alert management |
| Access Review | Permission review campaigns |
| Sites | SharePoint site management |
| Reports | Generate and download reports |
| Settings | User and system configuration |
| Help | Documentation and support |
Connecting Microsoft 365
Initial Connection
- Navigate to Settings > Connections
- Click Connect Microsoft 365
- You'll be redirected to Microsoft's authentication page
- Sign in with an account that has admin permissions
- Review and accept the requested permissions
- Upon success, you'll be redirected back to AuditSphere
Connection Status
After connecting, the system will:
- Begin syncing audit events (every 15 minutes)
- Display your connected account information
- Show connection health status
Disconnecting
If you need to disconnect:
- Go to Settings > Connections
- Click Disconnect next to your Microsoft 365 connection
- Confirm the disconnection
Note: Disconnecting will stop event collection but will not delete historical data.
Monitoring Activity
Viewing Audit Events
Navigate to Activity to see all collected audit events.
Event Information
Each event displays:
- Timestamp: When the event occurred
- Operation: Type of action (e.g., FileAccessed, FileShared)
- User: Who performed the action
- Resource: File or site affected
- IP Address: Source IP of the action
- User Agent: Client application used
Filtering Events
Use the filter panel to narrow results:
| Filter | Options |
|---|---|
| Date Range | Custom date selection |
| Operation | FileAccessed, FileModified, Shared, etc. |
| User | Specific user email |
| Site | SharePoint site URL |
| User Type | Regular, Guest, Admin, System |
Searching Events
Use the search bar to find events by:
- File name
- User email
- Site URL
- Operation type
Exporting Events
Click Export to download filtered events as CSV.
Anomaly Detection
How Anomaly Detection Works
AuditSphere uses machine learning to identify unusual patterns:
- Access Patterns: Unusual file access behavior
- Timing Anomalies: Activity at unusual times
- Volume Anomalies: Unusually high activity levels
- External Sharing: Suspicious sharing with external users
Viewing Anomalies
Navigate to Anomalies to see detected issues.
Anomaly Details
Each anomaly shows:
- Type: Category of anomaly
- Severity: CRITICAL, HIGH, MEDIUM, LOW
- Confidence: ML model confidence score (0-100%)
- Status: NEW, INVESTIGATING, RESOLVED, FALSE_POSITIVE
- Related Event: The audit event that triggered detection
Managing Anomalies
Update Status
- Click on an anomaly to view details
- Select new status from dropdown
- Add notes if needed
- Click Update
Bulk Actions
- Select multiple anomalies using checkboxes
- Choose action from bulk menu
- Confirm the action
Status Workflow
Compliance Monitoring
Supported Standards
AuditSphere includes built-in checks for:
- CIS Microsoft 365 Foundations Benchmark
Viewing Compliance Status
Navigate to Compliance to see your compliance posture.
Compliance Dashboard
- Overall Score: Percentage of passing checks
- By Category: Breakdown by compliance area
- Check Results: Individual check pass/fail status
Compliance Categories
| Category | Description |
|---|---|
| Sharing | External and guest sharing policies |
| Access | Authentication and access controls |
| Data Protection | Data loss prevention settings |
| Security | Security configuration checks |
Check Severity Levels
| Level | Description |
|---|---|
| CRITICAL | Must fix immediately |
| HIGH | Should fix soon |
| MEDIUM | Recommended to fix |
| LOW | Nice to have |
Running Compliance Checks
- Click Run Compliance Check
- Select the compliance standard
- Wait for checks to complete
- Review results and recommendations
Viewing Check Details
Click any check to see:
- Check description
- Current status
- Evidence collected
- Remediation recommendations
Managing Alerts
Alert Types
| Type | Description |
|---|---|
| ANOMALY | ML-detected unusual behavior |
| COMPLIANCE | Compliance check failures |
| SECURITY | Security policy violations |
Alert Severity
- CRITICAL: Immediate action required
- HIGH: Urgent attention needed
- MEDIUM: Should be reviewed soon
- LOW: Informational
Alert Status
| Status | Description |
|---|---|
| NEW | Unreviewed alert |
| ACKNOWLEDGED | Under investigation |
| RESOLVED | Issue addressed |
| DISMISSED | No action needed |
Managing Alerts
Acknowledge an Alert
- Click on the alert
- Click Acknowledge
- Add investigation notes
- Alert moves to ACKNOWLEDGED status
Resolve an Alert
- Open an acknowledged alert
- Click Resolve
- Document the resolution
- Alert moves to RESOLVED status
Dismiss an Alert
- Click Dismiss for false positives
- Provide reason for dismissal
- Alert is removed from active view
Alert Configuration
Navigate to Settings > Alert Configuration to:
- Create custom alert rules
- Set notification preferences
- Configure severity thresholds
Access Reviews
Access Reviews help you systematically review and clean up permissions.
Creating a Review Campaign
-
Navigate to Access Review > Campaigns
-
Click Create Campaign
-
Configure the campaign:
- Name: Descriptive campaign name
- Description: Purpose of the review
- Scope: Select sites to include
- Reviewers: Assign reviewers
- Due Date: Review deadline
-
Click Create
Campaign Workflow
| Stage | Description |
|---|---|
| Draft | Configuration in progress |
| Scheduled | Waiting to start |
| Collecting | Gathering permissions from Microsoft 365 |
| In Review | Reviewers making decisions |
| Completed | All decisions made and executed |
Reviewing Permissions
As a Reviewer
- Navigate to Access Review > My Reviews
- See your pending review items
- For each permission, choose:
- Retain: Keep the access
- Remove: Revoke the access
- Provide justification for your decision
- Submit decisions
Bulk Decisions
- Select multiple items
- Choose bulk action (Retain All / Remove All)
- Provide common justification
- Submit
Designated Owners
Assign resource owners who are responsible for reviewing their resources:
- Go to Access Review > Designated Owners
- Click Add Owner
- Select the resource (site/drive)
- Assign the owner
- Optionally mark as primary owner
Scheduled Reviews
Set up recurring reviews:
- Go to Access Review > Schedules
- Click Create Schedule
- Configure:
- Frequency: Weekly, Monthly, Quarterly, Yearly
- Review Period: Days for completion
- Auto-execute: Automatically remove access on completion
- Notifications: Email reminders
- Save the schedule
Reports
Available Report Types
| Report | Description |
|---|---|
| Access Audit | Detailed permission inventory |
| Compliance | Compliance check results |
| Anomaly | Detected anomalies summary |
| Sharing | External sharing analysis |
| External Access | Guest user access report |
Generating a Report
- Navigate to Reports
- Click Generate Report
- Select report type
- Configure parameters:
- Date range
- Filters
- Include options
- Choose format: PDF, XLSX, or CSV
- Click Generate
Downloading Reports
- Wait for report generation to complete
- Click Download next to the report
- Report downloads in selected format
Scheduled Reports
Set up automatic report generation:
- Click Schedule Report
- Configure frequency
- Select recipients
- Reports will be emailed automatically
Settings & Configuration
Profile Settings
Navigate to Settings > Profile to:
- Update display name
- View account email
- See assigned role
Notification Preferences
Configure how you receive alerts:
| Channel | Options |
|---|---|
| On/Off for each alert type | |
| In-App | Desktop notifications |
Microsoft Connection
Manage your Microsoft 365 integration:
- View connection status
- Reconnect if needed
- Disconnect account
Alert Configuration
Create custom alert rules:
- Go to Settings > Alert Configuration
- Click Add Rule
- Configure:
- Name: Rule identifier
- Condition: When to trigger
- Severity: Alert priority
- Notification: How to notify
Troubleshooting
Common Issues
"Microsoft 365 Not Connected"
Problem: Dashboard shows disconnected status.
Solution:
- Go to Settings > Connections
- Click Connect Microsoft 365
- Re-authenticate with admin credentials
- Ensure permissions are granted
"No Events Appearing"
Problem: Activity page shows no events.
Solutions:
- Verify Microsoft 365 is connected
- Check that audit logging is enabled in your Microsoft 365 tenant:
- Go to Microsoft 365 Admin Center
- Navigate to Compliance > Audit
- Ensure auditing is turned on
- Wait 15-30 minutes for initial sync
- Verify the connected account has
AuditLog.Read.AllandActivityFeed.Readpermissions
"Compliance Checks Failing"
Problem: All compliance checks show errors.
Solution:
- Ensure Microsoft connection is active
- Verify admin permissions in Microsoft 365
- Check that the app has
SharePointTenantSettings.ReadWrite.Allpermission - Verify the connected account can access admin settings
"Access Review Not Collecting Permissions"
Problem: Campaign stuck in "Collecting" state.
Solutions:
- Verify
Sites.FullControl.Allpermission is granted - Check that selected sites are accessible
- Review error logs in campaign details
"Permission Removal Not Working"
Problem: Access review decisions to remove permissions are not being executed.
Solutions:
- Verify
Sites.FullControl.AllandSites.Manage.Allpermissions are granted - Check that
GroupMember.ReadWrite.Allis granted for group permission removals - Ensure the app has write access to the affected sites
Getting Help
If you encounter issues not covered here:
- Check the Help section in the application
- Contact your system administrator
- Review application logs for error details
Glossary
| Term | Definition |
|---|---|
| Audit Event | Logged activity from Microsoft 365 |
| Anomaly | ML-detected unusual behavior pattern |
| Campaign | Access review initiative with defined scope |
| Compliance Check | Verification of security configuration |
| CIS Benchmark | Industry standard security guidelines |
| Designated Owner | User responsible for resource permissions |
| Graph API | Microsoft's API for 365 services |
| Delegated Permission | Permission that acts on behalf of signed-in user |
| Application Permission | Permission that allows app to act independently |
Document Information
| Property | Value |
|---|---|
| Version | 1.0 |
| Last Updated | December 2025 |
| Audience | End Users & Administrators |