Forum Discussion

viresh18's avatar
7 years ago

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.

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