+1Hi,
i have a Grafana monitoring setup i would like to expand with some Commvault stats.
https://grafana.com/docs/grafana/latest/datasources/mssql/
It’s possible to query SQL databases, like the Commvault DB.
Which query should i use to become the SLA % you see in the dashboard of the Commandcenter?
Best answer by Scott Moseman
Is Grafana able to pull the data and do some math on the results?
USE CommServ
SELECT * FROM [dbo].[RptSLAHistory]
WHERE days=-1 AND FullJobsOnly=0 ORDER BY date DESC
SLA % = nClientsMet / (nClientsMet + nClientsMissed) * 100
Thanks,
Scott
Good afternoon. There are a number of considerations that go into the SLA percentages, things included, excluded, etc. I will reach out to my resources and see if it is possible to pull that information from the CommServe database and update this thread once i have a response.
+18
Is Grafana able to pull the data and do some math on the results?
USE CommServ
SELECT * FROM [dbo].[RptSLAHistory]
WHERE days=-1 AND FullJobsOnly=0 ORDER BY date DESC
SLA % = nClientsMet / (nClientsMet + nClientsMissed) * 100
Thanks,
Scott
+18I had this exact request in my notes for my one my customers. 😎
Thanks,
Scott
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
