How to associate LogicMonitor Graph data with the grafana SampleJson plugin?


#1

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.

Eg: curl “https://accountName.logicmonitor.com/santaba/rpc/getGraphData?c=accountName&u=user&p=password&graphName=graphName&dataSourceInstanceName=InstanceName&csv=trueOrFalse&hostDisplayedAs=displayName&time=timePeriod

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”}


#2

See Grafana simplejson dashboard

Marcus