The Scenario
You're an infrastructure engineer at a company running five Grafana instances — dev, staging, prod-us, prod-eu, and a sandboxed internal one that nobody quite remembers setting up. A quarterly infrastructure review is coming up, and your manager has asked for a single document showing the health and license status of each environment.
This isn't a fire-drill. Nothing is broken right now. That's almost what makes it more tedious — you're going to spend the better part of an afternoon doing the same three clicks five times.
The bad version:
- Open each Grafana instance in a browser tab, navigate to the admin panel, check the health status and the license page, then manually enter "ok" or "error" and "Enterprise" or "OSS" into a Google Sheet — five times, across five tabs, with five different login sessions.
- Discover that one of the instances uses a different admin URL format than the others, spend twenty minutes tracking down the correct endpoint, and realize the license page in that version of Grafana is nested three levels deeper than you remember.
- Submit the sheet to your manager, who asks whether "ok" in the health column means the database connection is also ok or just the server process — and you have to go back and check because you didn't capture that level of detail the first time.
A quarterly audit is not supposed to take most of your afternoon. You're supposed to be thinking about capacity planning, not tabbing through browser sessions and typing "ok" into cells.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads what's already in the sheet — like the list of environments you have in column A — connects to Grafana through its built-in integration, and checks instance health and license status for you.
For each Grafana environment listed in column A (dev, staging, prod-us, prod-eu, sandbox), check the health endpoint and license status for each instance and write the health status in column B and the license type (Enterprise or OSS) in column C.
What You Get
- Column B: health status returned by each instance's health endpoint ("ok" or "error")
- Column C: license type as reported by the license API ("Enterprise" or "OSS")
- If an instance is unreachable, column B shows "unreachable" rather than a blank, so gaps in coverage are explicit
- Database connection status is captured as part of the health check — if the DB is degraded but the server is up, that distinction appears in the result
What If the Data Is Not Quite Ready
You need the database connection status captured separately from the overall health status
For each environment in column A, check the Grafana health endpoint and write the top-level status in column B and the database connection result (ok/error) specifically in column C. If the health check returns additional sub-components, write each in its own column starting at D.
One of your instances is behind a different base URL and you need to handle it inline
Check health and license status for the Grafana environments in column A. The prod-eu instance uses the base URL in column D instead of the standard one — use that URL for that row only and use the default base URL for all others. Write results in columns B and C.
You want to flag environments that are running OSS where Enterprise was expected
For each environment in column A, check the Grafana license status and write it in column B. Then in column C, flag any row where the license is "OSS" with "REVIEW" if the environment name contains "prod". Leave other rows blank in column C.
Audit health, license, version, and flag anything out of policy in one pass
For each Grafana environment in column A, check the health endpoint, the license type, and the Grafana build version. Write health in column B, license in column C, version in column D. In column E, flag any environment where health is not "ok" with "DOWN", any where license is "OSS" and the name contains "prod" with "LICENSE", and any where the version is more than 2 major versions behind 10.x with "OUTDATED". Write a summary count of flagged environments in cell E1.
Cleanup, conditional logic, and the compliance flag — one prompt, one pass.
Try It
Open your infrastructure audit Sheet with your Grafana environment names in column A, then ask SheetXAI to check health and license status across all of them. Get the 7-day free trial of SheetXAI — the Grafana integration is included in every plan. If you also need to pull panel metrics for a performance baseline, the dashboard panel data spoke covers that workflow. See the Grafana hub overview for the full comparison.