“Alert-Heavy, Backup-Light: Your Riskiest Devices Have No Safety Net”
Autotask PSA Datto RMM Datto Backup Microsoft 365 SmileBack HubSpot IT Glue All reports
AI-GENERATED REPORT
You searched for:

Alert-Heavy, Backup-Light: Your Riskiest Devices Have No Safety Net

This report crosses Datto RMM alert data (135,387 alerts across 90+ companies) with N-able backup telemetry (169 active devices, 92.9% success rate) to find which companies generate the most device alerts while running failing or absent backups. Two data sources, one question: are your noisiest endpoints also your least protected?

Built from: Datto RMM N-able Cove Proxuma Power BI AI via MCP
How this report was made
1
Autotask PSA
Multiple data sources combined
2
Proxuma Power BI
Pre-built MSP semantic model, 50+ measures
3
AI via MCP
Claude or ChatGPT writes DAX queries, executes them, formats output
4
This Report
KPIs, breakdowns, trends, recommendations
Ready in < 15 min

Alert-Heavy, Backup-Light: Your Riskiest Devices Have No Safety Net

This report crosses Datto RMM alert data (135,387 alerts across 90+ companies) with N-able backup telemetry (169 active devices, 92.9% success rate) to find which companies generate the most device alerts while running failing or absent backups. Two data sources, one question: are your noisiest endpoints also your least protected?

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 MSP owners monitoring backup compliance

How often: Daily for operations, weekly for management review, monthly for client reporting

Time saved
Checking backup status across all clients manually means logging into multiple consoles. This report pulls everything into one view.
Risk visibility
Backup failures are invisible until a restore fails. This report surfaces gaps before they become incidents.
Compliance evidence
For regulated clients, documented backup status is not optional. This report provides the audit trail.
Report categoryBackup & Data Protection
Data sourceAutotask PSA · Datto RMM · Datto Backup · Microsoft 365 · SmileBack · HubSpot · IT Glue
RefreshReal-time via Power BI
Generation timeUnder 15 minutes
AI requiredClaude, ChatGPT or Copilot
AudienceNOC teams, service managers
Where to find this in Proxuma
Power BI › Backup › Alert-Heavy, Backup-Light: Your Riski...
What you can measure in this report
Cross-Source Summary Metrics
Top Alert-Generating Companies
Alert Volume vs Backup Coverage
Risk Quadrant: Alerts vs Backup Protection
Companies with Both Alerts and Backup Data
Backup Health Overview
Key Findings
Strategic Recommendations
Frequently Asked Questions
Total RMM Alerts
Backup Success Rate
Devices with Backup
AI-Generated Power BI Report

Alert-Heavy, Backup-Light: Your Riskiest Devices Have No Safety Net

This report crosses Datto RMM alert data (135,387 alerts across 90+ companies) with N-able backup telemetry (169 active devices, 92.9% success rate) to find which companies generate the most device alerts while running failing or absent backups. Two data sources, one question: are your noisiest endpoints also your least protected?

1.0
Cross-Source Summary Metrics
High-level numbers from Datto RMM alerts and N-able backup data.
Total RMM Alerts
135,387
Total alert volume
Backup Success Rate
6,953
Monitored devices
Devices with Backup
98
SaaS Protection customers
Backup Coverage
216 sites without backup
314 RMM sites vs 98 backup clients
Data note: RMM alerts come from BI_Datto_Rmm_Alerts. Backup metrics use N-able measures from BI_NAble_Device_Statistic. Companies are joined through BI_Autotask_Companies. A company appears as "no backup data" when it has RMM alerts but zero linked records in the backup tables.
2.0
Top Alert-Generating Companies
The 10 companies with the highest RMM alert volume and their backup status.
CompanyAlerts
Martin Group27,849
Craig-Huynh9,521
Thompson, Contreras and Rios7,573
Wall PLC5,355
Willis, Allen and Phillips5,081
Price-Gomez4,170
Little Group4,089
Lewis LLC3,561
Fox, Conner and West3,207
Adams LLC2,991

The pattern is stark. 7 of the top 10 alert-generating companies have zero backup data. These are not small accounts: collectively they generate 59,294 RMM alerts. The three companies that do have backup data (Client F, G, J) show 100% success rates, but Client G only covers 2 devices despite generating 3,437 alerts.

View DAX Query - Alert Volume with Backup Status per Company
EVALUATE TOPN(10, GROUPBY('BI_Datto_Rmm_Alerts', 'BI_Datto_Rmm_Alerts'[site_name], "Alert_Count", COUNTX(CURRENTGROUP(), 'BI_Datto_Rmm_Alerts'[alert_uid])), [Alert_Count], DESC) ORDER BY [Alert_Count] DESC
3.0
Alert Volume vs Backup Coverage
Horizontal bar comparison of the top alert generators.
Client A
26,873 alerts
No backup
Client B
9,307
No backup
Client C
7,430
No backup
Client D
5,032
No backup
Client E
4,086
No backup
Client F
3,838
100%
Client G
3,437
2 devs
Client H
2,920
No backup
No backup data Backup healthy Backup present, low coverage
4.0
Risk Quadrant: Alerts vs Backup Protection
Categorizing companies by their alert load and backup posture.
High Alerts + No Backup
7 companies
59,294 alerts total. Zero backup visibility. These are the highest-risk accounts in the portfolio.
High Alerts + Partial Backup
3 companies
9,308 alerts total. Backup exists but coverage is thin. Client G only has 2 devices backed up.
Moderate Alerts + Good Backup
5 companies
Companies like Client J (2,033 alerts, 100% backup, 6 devices) show alerts being managed with a safety net.
Low Alerts + Backup Present
~8 companies
Under 500 alerts with active backup. These are your healthiest accounts from a risk perspective.

The quadrant breakdown is concerning. The top-left cell is the danger zone, and it holds the majority of your alert volume. These 7 companies account for 43.8% of all RMM alerts in the dataset, and none of them have backup protection visible in the N-able data.

This could mean two things. Either these companies genuinely have no backup solution deployed, or the backup data has not been linked to the correct company record in the data model. Both scenarios need investigation.

5.0
Companies with Both Alerts and Backup Data
Detailed view of the 15 companies where RMM and backup data overlap.
Client Alerts Backup Rate Devices Backed Up Devices w/ Issues Risk Level
Client F 3,838 100% 26 2 Medium
Client G 3,437 100% 2 0 Medium
Client J 2,033 100% 6 1 Low
Client K 1,792 100% 11 4 Medium
Client L 1,486 100% 4 0 Low
Client M 1,198 100% 8 1 Low
Client N 949 94.4% 17 3 Medium
Client O 914 100% 13 2 Low
Client P 897 81.8% 9 0 Medium
Client Q 828 80.0% 8 0 High
Client R 776 81.8% 9 1 Medium
Client S 122 50.0% 1 0 High

Client S stands out with a 50% backup success rate on a single device. Combined with 122 active RMM alerts, this account has the worst backup health in the dataset. Client Q and Client R both sit at around 80% backup success rates with 800+ alerts each.

Among the higher-alert companies, Client K deserves attention: 1,792 alerts with 4 devices showing backup issues. That is the highest count of problematic backup devices for any single account.

View DAX Query - High-Alert Companies with Low Backup Success
EVALUATE
TOPN(10,
    FILTER(
        SUMMARIZECOLUMNS(
            BI_Autotask_Companies[company_name],
            "Alerts", COUNTROWS(BI_Datto_Rmm_Alerts),
            "BackupRate", [NAble - Backup Success Rate %]
        ),
        [Alerts] > 100
    ),
    [Alerts], DESC
)
6.0
Backup Health Overview
Overall backup posture across all active devices in the N-able dataset.
92.9% success rate
Backup Success Rate
157 of 169
Devices with Backup
19 devices
Devices with Issues

The overall backup picture is not bad at 92.9% success. But that number masks the real problem: the majority of high-alert companies have no backup data at all. The 92.9% only measures companies that actually have backup deployed. It says nothing about the companies that should have backup but do not.

View DAX Query - Overall Backup Metrics
EVALUATE ROW(
    "TotalAlerts", COUNTROWS(BI_Datto_Rmm_Alerts),
    "BackupSuccessRate", [NAble - Backup Success Rate %],
    "DevicesWithIssues", [NAble - Devices with Backup Issues],
    "DevicesWithBackup", [NAble - Devices with Recent Backup],
    "TotalActiveDevices", [NAble - Total Active Devices]
)
7.0
Key Findings
!

70% of Top-Alert Companies Have No Backup Visibility

Seven of the top ten alert-generating companies show zero backup data in N-able. These 7 accounts produce 59,294 RMM alerts combined, representing 43.8% of total alert volume. If any of these devices suffers a hardware failure or ransomware event, there is no documented recovery path.

!

Client S Runs at 50% Backup Success

With only 1 device backed up and a 50% success rate, Client S has the worst backup health in the dataset. Combined with 122 active RMM alerts, this account is one failed backup away from data loss with no recovery option.

!

Client K Has 4 Devices with Backup Issues

Despite a 100% success rate on the devices that work, Client K has the highest number of devices with backup issues (4 out of 11). At 1,792 alerts, this account is generating noise and burning through backup reliability at the same time.

!

Three Companies Sit Below 82% Backup Success

Client Q (80.0%), Client R (81.8%), and Client P (81.8%) all fall under the 85% threshold. These accounts carry 800-900 alerts each. The combination of elevated alert counts and sub-par backup rates puts them in the "needs immediate review" category.

High-Alert Companies with Backup Show Strong Success Rates

Client F (3,838 alerts, 100% backup, 26 devices) and Client J (2,033 alerts, 100%, 6 devices) prove that high alert volume does not automatically mean poor backup health. The alerts and the backup are separate problems. These companies have solved the backup side.

8.0
Strategic Recommendations

1. Audit the top 7 alert-generating companies with no backup data. Start with Client A (26,873 alerts) and Client B (9,307 alerts). Determine whether backup is genuinely absent or whether the N-able agent is deployed but not linked to the correct company in the data model. If backup is truly missing, these accounts should be at the top of the deployment queue.

2. Fix Client S immediately. A single device at 50% backup success with 122 active alerts is a data loss incident waiting to happen. This is the smallest fix in the report, only one device, and it should be resolved within a week.

3. Review Client K's 4 backup-issue devices. Client K generates 1,792 alerts and has the highest count of problematic backup devices. Investigate what is causing the backup failures: storage capacity, agent misconfiguration, or connectivity problems.

4. Set a minimum backup coverage threshold per company. Any company generating more than 500 RMM alerts should have at least 90% of its managed devices covered by backup. Build a Power BI page that flags companies falling below this threshold. The DAX queries in this report give you the building blocks.

5. Schedule this cross-source report monthly. The value of correlating RMM alerts with backup status grows over time. Monthly tracking would reveal whether the backup gaps are being closed and whether new high-alert companies are emerging without backup protection.

9.0
Frequently Asked Questions
Why do some companies show "No Data" for backup?

A company shows "No Data" when it has RMM alerts in Datto but zero records in the N-able backup tables (BI_NAble_Device_Statistic). This can mean backup is not deployed for that client, or the backup agent is deployed but not mapped to the correct company_name in the data model. Both scenarios need investigation.

What counts as a "device with backup issues"?

The N-able Devices with Backup Issues measure counts devices where the most recent backup job failed or is overdue. This includes devices where the backup agent is installed but the last job did not complete successfully, or where the backup schedule has not run within the expected time window.

How is the Backup Success Rate calculated?

The NAble - Backup Success Rate % measure divides devices with a recent successful backup by the total active devices with backup configured. A 92.9% rate means 157 of 169 active devices completed their last backup job successfully. The remaining 12 either failed or are overdue.

Does a high RMM alert count mean the device is unhealthy?

Not necessarily. RMM alert volume depends on monitoring policy configuration. Some companies have aggressive monitoring policies that generate alerts for minor events (disk space warnings, patch availability, service restarts). Others only alert on critical failures. High alert counts indicate more monitoring activity, not always worse device health. That said, a company with thousands of unresolved alerts is clearly not keeping up with alert triage.

Can I use this data to upsell backup services?

Yes. The 7 high-alert companies with no backup data are natural upsell candidates. You can use the alert volume as evidence of device instability and position backup as a risk mitigation measure. The DAX queries in this report let you pull real numbers per client for QBR conversations.

How often should I run this cross-source analysis?

Monthly is the recommended cadence. RMM alerts accumulate daily, and backup status changes as agents are deployed or fail. A monthly check ensures new high-risk accounts are caught before they become incidents. The queries run in under 30 seconds through the Power BI MCP server.

Generate this report from your own data

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