Cacti-Weathermap-Export

[pradeeps]

Hello Folks,
I would like to know if there is an option in cacti to export the weathermap (in html,csv,..etc) to list the graph IDs associated to it.

Code: Select all

Date 	Tue, 11 Jun 2019 19:44:35 +0000
Cacti Version 	0.8.8h
Cacti OS 	unix
SNMP Version 	NET-SNMP version: 5.7.2
RRDTool Version 	RRDTool 1.4.x
Hosts 	7540
Graphs 	75240
Data Sources 	Script/Command: 8681
SNMP: 70249
SNMP Query: 29930
Script Query: 3
Script - Script Server (PHP): 18
Total: 108881

[Howie]

1) Weathermap reads data sources, not graphs. (there is not a 1:1 mapping between the two - you can have a graph aggregating multiple data sources in Cacti, or two graphs showing the same data source in different presentations, or with different CDEFs)

2) It only reads what you tell it to. i.e. You already know "grep TARGET weathermap.conf" will tell you the involved rrd files, if that's what you are using (it's only one option of several). The filename usually will tell you the datasource ID, depending on how you configured Cacti.

I think maybe I'm missing the point... what's the application for this exported information?

[pradeeps]

The applications for the graphs id are it is fed into another script which is used to pull the traffic rate which eventually used for KPI.Saying that I have looked into the weather-map configs for the rrd files involved where i can get the graphs UID as-well. However, if its not too much asking, is there a way to get the graphs name associated with the UIDs?

[Howie]

No, you get Data Source IDs. Those are not the same. (But probably they ARE what you want for your other script - the graph ID is mainly useful for building a URL to show the graph, not so much for getting actual numbers).

If you really really want graph IDs (I still think you don't). There is some code in the weathermap random-bits/cacti-integrate.php script. That is basically the same as what the editor picker uses to find a graph related to a data source.

You might also want to look at the DATAOUTPUTFILE directive. Or look in the weathermap/output directory for the data files that Weathermap already saves, if all you need is the current value (the file named XXXXX.results.txt for each map).

[pradeeps]

Thank you. I will certainly check your suggestions. Just to be clear, incase if my reference name is misleading, I am looking the get the "graph_id" circled in the screenshot.In our current setup, to get the graph_id, we need to click each link in the weathermap manually which opens up a graph url with an id at the end.To avoid the manual process, I am trying to get it is as a report from weathermap itself . Please dont mind if my explanation looks silly.

Capture.JPG (14.41 KiB) Viewed 469 times

[Howie]

I still don't think that will get you traffic numbers from Cacti, but if you are doing this by clicking on links in weathermap, just do this instead:

Code: Select all

 awk  'BEGIN {FS="=" } /INFOURL/ {print $NF;}' < weathermap.conf > export.txt

[pradeeps]

Awesome Thanks. That works.