How to associate LogicMonitor Graph data with the grafana?
Is there any way to associate LogicMonitor datasource data or graph date with the grafana sampleJson Data source.
Using API, LogicMonitor graph data can get and how to associate with grafana data source.
Sample OutPut:
{“status”:200,“data”:{“timeScale”:“3hours”,“minValue”:0,“storageEngine”:“tsdb_v2”,“timeZone”:“PDT”,“endTime”:1447688214000,“id”:0,“startTime”:1447677414000,“title”:“Load Average (3hours)”,“height”:120,“endTZOffset”:-28800000,“name”:“Load”,“verticalLabel”:“Load”,“startTZOffset”:-28800000,“dsName”:“NetSNMPCPUwithCores-Core Count: 1”,“xmlVerticalLabel”:“Load”,“maxValue”:"",“xAxisName”:“2015-11-16 12:36 to 2015-11-16 15:36 PST”,“timestamps”:[1447677393000,1447677453000,1447677513000,1447677573000,1447677633000,1447677693000,1447677753000,1447677813000,1447677873000,1447677933000,144767799300,1447688193000],“base1024”:false,“width”:360,“rigid”:false,“displayPrio”:1,“xmlTitle”:“Load Average (3hours)”,“missingLines”:[],“base”:1000,“lines”:[{“min”:0.05,“colorName”:“purple”,“max”:0.06,“visible”:true,“color”:“80699B”,“description”:“15 minute load average”,“legend”:“15 min”,“std”:7.432941462471638E-4,“data”:[0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.06,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05.,0.05],“useYMax”:false,“label”:“15MIN”,“avg”:0.050055248618784506,“type”:“Line”,“decimal”:4},{“min”:0,“colorName”:“blue”,“max”:0.16,“visible”:true,“color”:“4572A7”,“description”:“1 minute load average”,“legend”:“1 min”,“std”:0.015849971872173223,“data”:[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.16,0.06,0.02,0.01,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.08,0.03,0.01,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0],“useYMax”:false,“label”:“1MIN”,“avg”:0.0037016574585635367,“type”:“Line”,“decimal”:2},{“min”:0.01,“colorName”:“green”,“max”:0.05,“visible”:true,“color”:“89A54E”,“description”:“5 minute load average”,“legend”:“5 min”,“std”:0.005850605840827677,“data”:[0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.05,0.04,0.03,0.03,0.02,0.02,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01],“useYMax”:false,“label”:“5MIN”,“avg”:0.011878453038674028,“type”:“Line”,“decimal”:3}],“exportFileName”:“172.31.36.125-NetSNMPCPUwithCore-Load-2015-11-16_12:36_to_2015-11-16_15:36_PST”,“step”:60},“errmsg”:“OK”}
Tom_Lasswell
@viresh18 this is a great question, you're referencing the RPC API however, I'm not sure about the data ingest portion of Grafana but REST is the way to go now for the data. The REST get data methods are far better and provides better JSON as well as a CSV output for processing.
Be aware there are limits on your API queries, so you'll want to define these in a way where you don't hit your limits.
these articles should give you some info:
https://grafana.com/plugins/grafana-simple-json-datasource
https://community.grafana.com/t/grafana-simplejson-dashboard/5627/2
I'd love to see if you end up with anything useful using Grafana.