Background
One common request from customers is a Network Operations Center dashboard view for Cisco DNA Center. They would like this to be open-authentication (no need for credentials) and automatically refresh. Critical data from Cisco DNA Center, such as network device and user health can be displayed and updated for the operations team on a large screen.
Using common tools like Influx (time series), telegraf (agent) and Grafana (visualization) (TIG) it is trivial to build a small dashboard and expose it via HTTP. Many customers are already using these tools for other dashboards.
Telegraf-Influx-Grafana stack
The only real work I need to do is write a small python script to plug into telegraf to collect network and user health data from Cisco DNA Center and convert it to a simple JSON format.
For this script I am going to use the newly released Cisco DNA Center python SDK.
Getting started
The first step is to download the code from github and create a python virtual environment. The virtualenv is recommended, but optional.
git clone https://github.com/CiscoDevNet/DNAC-NOC.git
python3 -mvenv env3
source env3/bin/activate
Next install the python requirements (the dnacentersdk). It is a good idea to update pip first, as older versions may have issues installing the SDK.
pip install -U pip
pip install -r DNAC-NOC/requirements.txt
Now test the script to ensure it is working. By default the script will try to connect to the DevNet always on sandbox. The data collected includes device health and counts as well as user (wired and wireless) health and counts. There is more data that you can collect by modifying the script.
$ ./DNAC-NOC/dnac_assurance.py
{"Core.count": null, "totalcount": 14, "WIRELESS-client.count": 80, "WLC.count": null,
"WIRED-client.count": 2, "AP.count": null, "WIRED-client.value": 100, "Access.count": null,
"totalscore": 100, "WIRELESS-client.value": 25, "AP.score": 100, "Router.score": 100,
"ALL-client.value": 27, "Router.count": null,
"Access.score": 100, "Core.score": 100, "WLC.score": 100, "ALL-client.count": 82}
Script Detail
There are two APIs used to get this data seen in the code below.
“get_overall_network_health” returns the health (and count) of the network devices. They are broken into categories (WLC, router,AP, access etc). It requires a timestamp, but that can be left empty (returning the latest).
“get_overall_client_health” returns the health (and count) of clients. In this case I need to provide a timestamp. That is the current time (in epoch) converted to milli-epoch (i.e. multiply by 1000).
network_health= dnac.networks.get_overall_network_health(timestamp='')
timestamp = int(time.time() * 1000)
client_health= dnac.clients.get_overall_client_health(timestamp='{}'.format(timestamp))
Telegraf configuration
I am assuming you have telegraf setup and integrated into influxdb. As there are many blogs outlining how to install these components, I will skip over these basic steps.
The custom python script above will be run every minute and update a time series database in influxdb. The custom.conf file contains information on how to run the script. You need to edit this file to change the path for the python virtual environment and the script.
Once you copy the script, restart telegraf so the custom script will be executed. The script is called every minute as the client health score gets updated every minute.
sudo cp DNAC-NOC/telegraf.d/custom.conf /etc/telegraf/telegraf.d/
sudo systemctl restart telegraf
You will now see data being populated in influxdb.
$ influx
Connected to http://localhost:8086 version 1.7.8
InfluxDB shell version: 1.7.8
> use telegraf
Using database telegraf
> show field keys from "exec_dnac"
name: exec_dnac
fieldKey | fieldType |
ALL-client.count | float |
ALL-client.value | float |
AP.score | float |
Access.score | float |
Distribution.score | float |
Router.score | float |
WIRED-client.count | float |
WIRED-client.value | float |
WIRELESS-client.count | float |
WIRELESS-client.value | float |
WLC.score | float |
totalcount | float |
totalscore | float |
Grafana configuration
The final step is to import a json definition of the DNAC dashboard into gafana.
First browse to gafana homepage (typically port 3000). The select “+” -> create -> import
Import Dashboard
Next select “upload .json file”
Upload .json File
The select “grafana/dashboard.json” from the files you downloaded from GitHub.
select dashboard.json from the “grafana” directory
Then select Import.
import dashboard spec
Very soon you should see the dashboard being populated.
First data