Multi-tenant Grafana health scores for a managed IT services provider

Python collectors pull tickets, endpoints, backups, identity and network data from each client's tools and score them in Grafana, one view per tenant.

Client and industry

TWE Solutions

Managed IT services and endpoint management, United States

The problem

The client manages IT for many companies. The state of each customer was spread across a ticketing system, an endpoint platform, backup tools, identity providers and network monitoring. Account managers had no single, comparable answer to "is this customer healthy?"

What we did

Collectors for five areas. Python collectors run on a schedule and write to InfluxDB:
- service tickets by queue from Autotask
- endpoint inventory from the client's own endpoint platform, checked against Auvik
- backup jobs from Veeam, native Azure VM backups and Microsoft 365 backups
- identity from Active Directory, Azure AD and Okta
- network devices from Auvik
A score per area. Each Grafana dashboard turns the raw data into a 0 to 100 score with written rules. For example, endpoints score zero if any server is offline or antivirus is off on more than 10 percent of machines.
One tenant per customer. An installer creates the Grafana organisation, the InfluxDB bucket and a write-only token for each customer, then imports the chosen dashboards and alerts through the APIs.

Stack used

Python, InfluxDB and Grafana, with Autotask, Auvik, Veeam, Azure, Okta and Active Directory as data sources.

Duration

1 year

Outcome

Python collectors and Grafana dashboards that score each customer's IT security and backup compliance, now used by the client with its own paying customers