22. 12. 2023 Giuseppe Di Garbo ITOA, NetEye

Hostgroup Ping Dashboard

Hostgroups are a grouping of hosts with similar characteristics such as geographical location, type, severity, environment, operating system, applications and much more.

Hostgroups can be created for multiple purposes such as:

  • Grouping hosts with common characteristics to view them as quickly as possible
  • Using them as filters to manage Roles with limited views and access to objects (RBAC)
  • Using them as notification filters
  • And much more

The default Host Group view is undoubtedly one of the most comfortable and useful ones in NetEye because, for each group, it immediately shows the status of all the hosts and their related services.

Since Hostgroups are so useful, why not also use them as a filter in an ITOA Dashboard?

In order to use HostGroups as filters we first need to create a variable Hostgroup using the icinga-mysql datasource as follows:

Next we need to create another variable that selects the hosts of the previously selected Hostgroup as the first parameter:

The query used is the following:

SELECT io.name1
FROM icinga_hostgroups ih
JOIN icinga_hostgroup_members ihm ON ih.hostgroup_id=ihm.hostgroup_id
JOIN icinga_objects io ON io.object_id=ihm.host_object_id
WHERE 
io.is_active = 1 AND 
ih.alias = '$Hostgroup';

Now we can create Dashboards that take advantage of these two filters.

In the example I am going to share, I had a customer whose request was: I need a dashboard that shows the host with the highest percent of packet loss of a selected Hostgroup, and a graph of the ping of all the hosts of a specific Hostgroup.

Example 1

Hostgroup: linux servers

Host: All

Example 2

Hostgroup: All Hosts

Host: custom selection

You can export this dashboard from our NetEye Demo. If you can’t remember how to export and import a dashboard into your NetEye, you can follow the instructions I included in this blog post.

These Solutions are Engineered by Humans

Are you passionate about performance metrics or other modern IT challenges? Do you have the experience to drive solutions like the one above? Our customers often present us with problems that need customized solutions. In fact, we’re currently hiring for roles just like this as well as other roles here at Würth Phoenix.

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. Required fields are marked *

Archive