Management Dashboard

⋮⋮
Active Tickets
-
New, In Progress, Awaiting
⋮⋮
New Tickets
-
Awaiting assignment
⋮⋮
Kill Rate (7 Days)
-
-
⋮⋮
Kill Rate (30 Days)
-
-
⋮⋮
Kill Rate (90 Days)
-
-
⋮⋮
Avg Resolution
-
Days to close (30d)
⋮⋮

Open Tickets by Status

⋮⋮

Active Tickets by Queue

Tickets with status: New, In Progress, Awaiting

⋮⋮

Kill Rate - Last 7 Weekdays

Daily kill rate % (excluding weekends)

⋮⋮

Top Ticket Creators - Last 30 Days

Click on a row to view tickets

Loading...

⋮⋮

Top Issue Types - Last 30 Days

Click on a row to view tickets

Loading...

⋮⋮

Tickets by Company (Top 5) - Last 30 Days

Click on a bar to view tickets

Dashboard Overview

Database: msp_dash

Tables in Database

Loading tables...

Database Tables

Select a table to view its data

Table Data

Select a table to view its data

Custom Query

Results

Run a query to see results

Settings

System configuration and deployment

🏢
Companies
-
👥
Contacts
-
🎫
Tickets
-
📋
Issue Types
-
📂
Queues
-

Last Sync Times

Loading sync status...

Database Setup

First time? Click this button to create the required database tables.

Test Autotask Connection

Test the connection to Autotask API to verify credentials work.

Manual Sync

Trigger a manual sync from Autotask. This will fetch the latest data.

Full Ticket Sync

Use this if you're missing tickets. Fetches ALL tickets from Autotask and marks deleted tickets.

Automatic Sync Schedule

🎫 Tickets (Full 2-day sync) Every 30 minutes
🏢 Companies Daily at midnight
👥 Contacts Daily at 1:00 AM
📋 Issue Types Daily at midnight
📂 Queues Daily at midnight
Scheduler Status: Stopped

Current Environment

Environment
-
-
Version
-
-

Deployment Actions

Pull latest changes, promote to production, or rollback if needed.

Pull Latest Changes

Pull the latest code from GitHub and restart this server.

Promote to Production

Merge dev branch into main, install dependencies, and restart production server.

Rollback Production

Revert production to a previous deployment. Select a version from history below.

Deployment History

Recent deployments to production. Click on a row to select for rollback.

Version Git Hash Environment Deployed By Notes Date Actions
Loading...

Database Information

Host
-
Database
-
Tables
-
Connection
-

User Management

Manage dashboard users and permissions

Users

Username Display Name Email Role Status Last Login Actions
Loading users...

Change Your Password