This report provides a detailed breakdown of live noc dashboard — operational ticket monitor for managed service providers.
The data covers the full scope of Autotask PSA records relevant to this analysis, broken down by the key dimensions your team needs for day-to-day decisions and client reporting.
Who should use this: NOC teams, service managers, and operations leads managing alert workflows
How often: Daily for alert triage, weekly for noise reduction, monthly for monitoring optimization
EVALUATE
ADDCOLUMNS(
SUMMARIZE(
FILTER(BI_Autotask_Tickets, ISBLANK(BI_Autotask_Tickets[complete_datetime])),
BI_Autotask_Tickets[status_name]
),
"OpenCount",
CALCULATE(
COUNTROWS(BI_Autotask_Tickets),
ISBLANK(BI_Autotask_Tickets[complete_datetime])
)
)
ORDER BY [OpenCount] DESCEVALUATE
ADDCOLUMNS(
SUMMARIZE(
FILTER(BI_Autotask_Tickets, ISBLANK(BI_Autotask_Tickets[complete_datetime])),
BI_Autotask_Tickets[queue_name]
),
"OpenCount",
CALCULATE(
COUNTROWS(BI_Autotask_Tickets),
ISBLANK(BI_Autotask_Tickets[complete_datetime])
)
)
ORDER BY [OpenCount] DESC| Priority | Open Tickets | % of Total | Action Level |
|---|---|---|---|
| P1 - Critical | 5 | 0.6% | Immediate response |
| P2 - High | 19 | 2.3% | Same-day resolution |
| P3 - Medium | 90 | 10.7% | Planned this week |
| Service/Change | 174 | 20.6% | Scheduled |
| P4 - Low | 556 | 65.9% | Backlog |
EVALUATE
ADDCOLUMNS(
SUMMARIZE(
FILTER(BI_Autotask_Tickets, ISBLANK(BI_Autotask_Tickets[complete_datetime])),
BI_Autotask_Tickets[priority_name]
),
"OpenCount",
CALCULATE(
COUNTROWS(BI_Autotask_Tickets),
ISBLANK(BI_Autotask_Tickets[complete_datetime])
)
)
ORDER BY [OpenCount] DESCWith a PPU licence (from €20/user/month), you can use DirectQuery mode against supported data sources and get refresh intervals as short as 1 second. Import mode supports intervals from 30 minutes down to 1 minute with PPU. Most MSPs with Proxuma use Import mode refreshing every 15 minutes — more than sufficient for NOC operational awareness.
291 out of 844 open tickets sit in Technical Alignment. On a NOC dashboard, this stands out immediately. If that queue was 600 last week and is 291 today, the team knows something changed. Without the screen, this information sits invisible inside Autotask.
New tickets have not been assigned or acknowledged yet. On a NOC TV, a large "New" count is a visible signal that the triage process needs attention. A threshold alert (e.g., red if New > 50) can be configured directly in Power BI conditional formatting.
Automation-sourced tickets from Datto RMM make up just 1.3% of the open backlog. A NOC dashboard that segments these separately lets the team see whether automation is generating noise or actionable issues. If RMM tickets resolve faster than manual tickets, that data becomes visible too.
In Progress and Planned together account for 418 tickets — nearly half the open backlog. On a NOC screen, this is a healthy signal. If "In Progress" drops sharply, it may indicate a capacity problem or a system issue preventing ticket updates.
Connect Proxuma Power BI to your PSA, RMM, and M365 environment, use an MCP-compatible AI to ask questions, and generate custom reports - in minutes, not days.
See more reports Get started