Grafana Excel Report Download — Part1

Grafana Excel Report Download — Part1

If you don’t have time to read but want to know what’s there in this post. Find the quick read 👇

In Grafana OSS(Open Source) we can’t download the reports in PDF or Excel format. but there are few plugins available for PDF which would take a snapshot of the panels.

But to download the report as excel we don’t have any option all we have is to download panel data as CSV.

Today, we are going to see how to download the data collected by InfluxDB as an excel report in Grafana using NodeJS.

Overall Flow

What we are going to do

In this series, we will see how to download the system metrics data which is stored in InfluxDB from Grafana using the NodeJS application.

Milestones

  1. Create a telegraf configuration to collect system metrics

  2. Run the telegraf agent to send system metrics

  3. Create a Dashboard in Grafana for system metrics using InfluxDB as a data source

  4. Create a NodeJS application to collect system metrics from InfluxDB using client libraries

  5. Create the Excel report using the collected metrics

  6. Configure Grafana to download the report

What we are going to do in Part 1

In this part, we will see how to

  1. Create a telegraf configuration to collect the system metrics

  2. Run the telegraf agent to send system metrics

  3. Create a Dashboard in Grafana for system metrics using InfluxDB as a data source

1. Create a telegraf configuration to collect system metrics

Before starting make sure you have telegraf installed in your system as well as InfluxDB running.If not kindly look at the above articles 👆.

Open InfluxDB and then click Data ➡️ Telegraf you could see a page like below

Create Configuration

Click Create Configuration and then select the bucket from the dropdown menu to which the metrics need to store.

Selecting the metric

Once the metric is selected click Continue and then you could receive a token like below (Copy it will use it later)

InfluxDB Token

Once the Token is copied click Finish and then download the configuration

Configuration File

Congrats on completing 1️⃣st milestone 👏 in this part

Milestone 1

Just take a quick break to know about Telegraf 👇

Quick Read #1

2. Run the telegraf agent to send system metrics

Once the configuration file is downloaded paste the InfluxDB token which you have copied earlier into telegraf.conf or you can export it is as an InfluxToken also. Once the token is added start the telegraf service and then use the following command to run telegraf like below

telegraf --config path-of-your-telegraf.conf

Telegraf command

Once you run the telegraf agent you could see an output like below

Congrats on completing the 2️⃣nd milestone 👏

Milestone 2

Just take a quick break to know about Grafana 👇

Quick Read #2

3. Create a Dashboard in Grafana for system metrics using InfluxDB as a data source

👆Click the button for download instructions

Once you have installed Grafana and started the Grafana instance in your machine. Open your browser and type localhost:3000 you could see the login page of Grafana like below

Grafana Login Page

If you log in for the first time then the username and password is admin and admin.If not log in with the credentials you have set earlier.

Now click on Settings ➡️ Datasource like below

Data source

Now Click Datasource ➡️ Add data source and type InfluxDB like below

InfluxDB Datasource

Now click InfluxDB and fill in the details like below 👇

InfluxDB Configuration

Now click Save & Test where you could see a result like below

Datasource connected

Now you have successfully connected with InfluxDB.Now we will create the dashboard for system metrics

Click on the ‘+’ icon to import a new dashboard.

Import Dashboard

Now copy the JSON 👇

Click the Copy Dashboard button 👆

Once you have copied the JSON paste the code into Grafana and click Load

Load Dashboard

Once you click the Load button select the folder in which you want to save the dashboard like below

Importing Dashboard

Once you import the dashboard you could see some errors in the dashboard 😨. Don’t get freaked out just click the Dashboard settings

Dsahboard settings

and then select Variables and click the hostname

Change the hostname to the one which you have seen in your InfluxDB and then click update

changing host name

Make sure the default dashbaord is InfluxDB

Once it is done you could see the dashboard like 👇

Congrats on completing the 3️⃣rd milestone 👏

Milestone 3

Congratulations 🏆

You have completed Part 1️⃣ milestones. Get ready for the Part 2 milestone. Till then Happy Learning 😄