• 0
Sign in to follow this  
viresh18

How to associate LogicMonitor Graph data with the grafana?

Question

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

Share this post


Link to post
Share on other sites

1 answer to this question

Recommended Posts

  • 0

@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. 

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this