Adam Machin

Tech Blog

Cacti CSV automated export

Cacti is fantastic at collecting data from SNMP enabled devices and interpreting this data in the form of useful graphs. As Cacti collects and stores this data, you may have a use case to access this data for other means. This tutorial quickly explains how to enable automatic exporting of host data in the CSV format.

The good news is that there is a Cacti plugin called NmidDataExport that automatically can do just that. Download it from the Cacti plugins page. Be sure to activate it after installation, navigate in the web interface to Configuration and then Plugin management.

In the Cacti web interface click on Console.

Next under Management click on Graph Management.

This displays a list of all current graphs available that Cacti is graphing.

Find the Graph you wish enable the automated CSV export for. Example I have a graph called Cisco ASA 5505 – Traffic – Ethernet0/0. Select the check box next to this graph and scroll down to the bottom of the page.

 

Where it says, Choose an action, click the list where it says, Delete, change it to Automated Export – Add to Export. Press Go.

Where is my CSV data?
On the Cacti side bar, navigate to Configuration and click Settings.

Notice at the top you have a menu item named NMID. Here you have settings for json or csv. And the export directory can be set. You can change this to a more suitable web server directory for access via http easier than the default.

The CSV files have names that correspond to the IP/hostname/graph ID info, and are updated every 5 minutes over the last few hours, they contain the values for this period only as far as I can tell. This is useful as it gives near live data sampled over a recent period that is updated frequently.

Next Post

Previous Post

4 Comments

  1. wafa 22nd April 2015

    I have a problem when I use this plugin
    my problem is that the file .CSV is create but it doesn’t contains measurements
    this is the content of the file:
    date
    ######
    ######
    ##### ..etc
    please help

    • adam 17th April 2018 — Post author

      Hi, sorry it’s taken me 3 years to reply! You originally posted this on an old domain, have you checked the raw date in a text editor, ### looks like excel column needs expanding? thanks, Adam

  2. frankhui 31st August 2015

    Can you tell me why i cannot find the “Automated Export -Add to Export” in the drop down list ?

    • adam 17th April 2018 — Post author

      Hi – I know it’s 3 years later. Did you enable the plugin “NmidDataExport” after this it’s in Console -> Management -> Graph Management -> tick box select Graph, bottom of page is the drop down list to select with default value “delete”. thanks, Adam

Leave a Reply

© 2020 Adam Machin

Theme by Anders Norén