Skip to main content

Hi,

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?

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.

@KrisVermeulen,

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
 

@Scott Moseman  Thanks for bailing me out on this one 😀

I had this exact request in my notes for my one my customers. 😎

Thanks,
Scott

Reply


Terms & ConditionsCookie settings