22. 10. 2021 Giuseppe Di Garbo ITOA, NetEye

NetEye Problems Dashboard

Do you need a customizable dashboard to better track problems detected by NetEye? Here’s one:

WARNING

This dashboard does not take into account the user’s role and related permissions and it is intended for use by an administrator on an on-premise non multi-tenant installation of NetEye.

USE CASE

The standard Problems display (divided into two different menus, Hosts and Services) has often been found to be inefficient for situations where different operators need to be able to quickly detect problems and take charge of them.

The idea behind the Dashboard shown above is to help problem tracking on NetEye with a new (and beautiful) view and the ability to quickly filter existing events.

Starting from the latest 4.20 release this dashboard is available with our NetEye Extension Packs, but you can also try it on our NetEye Demo system as well as your own NetEye implementation.

This dashboard can help you by showing a quick summary of all problems (hosts down, services in critical, etc…) and two different tables focused on host and service problems.

The Hosts table shows hosts in the DOWN state, giving you the ability to filter for Handled/Not handled problems (Icinga uses the term “handled” for those objects that have an active acknowledge or downtime).

The Services table shows services in WARNING and/or CRITICAL, giving you the ability to filter problems with:

  • Problem handled filter: Handled/Not handled/All
  • Service state filter: WARNING, CRITICAL, All

Finally, each displayed host or service can be selected and via a link you will be redirected to the standard NetEye interface with focus on the selected problem.

How to Import the NetEye Problems Dashboard

Before downloading and importing the dashboard, ensure Grafana has access to the Icinga Database by creating a properly configured MySQL Data Source (if it doesn’t already exist):

  1. Access the DBMS and create a user having SELECT privileges on the Icinga Database
  2. Add a new MySQL Data Source to Grafana that connects to the DBMS using the user created in step #1

As already shared by my colleague Rocco Pezzani in his latest post we can proceed as follows using a bash script.

Just remember to set a proper password in the MYSQL_PASSWORD variable. The Data Source name is mysql-icinga2.

MYSQL_USERNAME='icingareadonly'
MYSQL_PASSWORD='<Change Me!>'
 
. /usr/share/neteye/scripts/rpm-functions.sh
. /usr/share/neteye/secure_install/functions.sh
. /usr/share/neteye/grafana/scripts/grafana_autosetup_functions.sh
 
cat << EOF | mysql
CREATE USER '${MYSQL_USERNAME}'@'%' IDENTIFIED BY '${MYSQL_PASSWORD}'; 
CREATE USER '${MYSQL_USERNAME}'@'localhost' IDENTIFIED BY '${MYSQL_PASSWORD}'; 
GRANT SELECT ON icinga.* TO '${MYSQL_USERNAME}'@'%';
GRANT SELECT ON icinga.* TO '${MYSQL_USERNAME}'@'localhost';
FLUSH PRIVILEGES;
EOF
 
datasource="mysql-icinga2"
datasource_type='mysql'
mysql_host="mariadb.neteyelocal"
mysql_port=3306
db_name="icinga"
grafana_host="grafana.neteyelocal"
 
datasource_data='"name":"'${datasource}'","type":"'${datasource_type}'","host":"'${mysql_host}':'${mysql_port}'","access":"proxy","database":"'${db_name}'","user":"'${MYSQL_USERNAME}'","password":"'${MYSQL_PASSWORD}'"'
create_datasource "${datasource}" "${datasource_data}" "${grafana_host}"

Now you can freely export the dashboard from our NetEye Demo environment: just access the Dashboard, click on Share dashboard or panel link and select the Export tab. Next, choose the format for your link after selecting Export for sharing externally.

Next, you can go to your own NetEye’s ITOA and Import the new dashboard.

Based on how the dashboard was previously exported, select Upload JSON file or directly paste the dashboard’s JSON data.
Don’t forget to select the Data Source created earlier to allow the dashboard to access the Icinga data.
Giuseppe Di Garbo

Giuseppe Di Garbo

Consultant at Würth Phoenix
Hi everybody. I’m Giuseppe and I was born in Milan in 1979. Since the early years of university, I was attracted by the Open Source world and operating system GNU\Linux. After graduation I had the opportunity to participate in a project of a startup for the realization of an Internet Service Provider. Before joining Würth Phoenix as SI consultant, I gained great experience as an IT consultant on projects related to business continuity and implementation of open source software compliant to ITIL processes of incident, change and service catalog management. My free time is completely dedicated to my wife and, as soon as possible, run away from Milan and his caotic time and trekking discover our beautiful mountain near Lecco for relax and lookup the (clean) sky.

Author

Giuseppe Di Garbo

Hi everybody. I’m Giuseppe and I was born in Milan in 1979. Since the early years of university, I was attracted by the Open Source world and operating system GNU\Linux. After graduation I had the opportunity to participate in a project of a startup for the realization of an Internet Service Provider. Before joining Würth Phoenix as SI consultant, I gained great experience as an IT consultant on projects related to business continuity and implementation of open source software compliant to ITIL processes of incident, change and service catalog management. My free time is completely dedicated to my wife and, as soon as possible, run away from Milan and his caotic time and trekking discover our beautiful mountain near Lecco for relax and lookup the (clean) sky.

Leave a Reply

Your email address will not be published.

Archive