Grafana + influxdb2 does not show data for host in default template

[ledvinap]

Expected Behavior

Host performance data are visible in graph

Current Behavior

Graph for Hosts displays "No data" (and does work for services)

var-service passed to grafana is passed as check_command for hosts. Icinga2 influxdb2 writer stores empty value in service for hosts, so default query can't find any data ( WHERE ("hostname" =~ /^$hostname$/ AND "service" =~ /^$service$/) ).

Possible Solution

Maybe pass new var-servicename that will contain real service name (empty for hosts).

Your Environment

• Icinga Web 2 Grafana version : 1.4.3 (master, 7e27158e181350a081822d4967dbf4dd83ae9c6a)
• icingadb 1.0.1 (master)
• Icinga Web 2 Version 2.11.1
• icinga2 - The Icinga 2 network monitoring daemon (version: r2.13.5-1)
• System information: Platform: Debian GNU/Linux Platform version: 11 (bullseye) Kernel: Linux Kernel version: 5.10.0-18-amd64 Architecture: x86_64 Enabled features: api checker command icingadb influxdb2 mainlog notification
• Config validation (icinga2 daemon -C): [2022-10-16 21:58:21 +0200] information/cli: Icinga application loader (version: r2.13.5-1) [2022-10-16 21:58:21 +0200] information/cli: Loading configuration file(s). [2022-10-16 21:58:21 +0200] information/ConfigItem: Committing config item(s). [2022-10-16 21:58:21 +0200] information/ApiListener: My API identity: bullseye [2022-10-16 21:58:21 +0200] information/ConfigItem: Instantiated 1 IcingaApplication. [2022-10-16 21:58:21 +0200] information/ConfigItem: Instantiated 268 Dependencies. [2022-10-16 21:58:21 +0200] information/ConfigItem: Instantiated 3 HostGroups. [2022-10-16 21:58:21 +0200] information/ConfigItem: Instantiated 137 Hosts. [2022-10-16 21:58:21 +0200] information/ConfigItem: Instantiated 1 FileLogger. [2022-10-16 21:58:21 +0200] information/ConfigItem: Instantiated 1 Influxdb2Writer. [2022-10-16 21:58:21 +0200] information/ConfigItem: Instantiated 1 CheckerComponent. [2022-10-16 21:58:21 +0200] information/ConfigItem: Instantiated 2 Notifications. [2022-10-16 21:58:21 +0200] information/ConfigItem: Instantiated 1 IcingaDB. [2022-10-16 21:58:21 +0200] information/ConfigItem: Instantiated 3 Zones. [2022-10-16 21:58:21 +0200] information/ConfigItem: Instantiated 1 IdoPgsqlConnection. [2022-10-16 21:58:21 +0200] information/ConfigItem: Instantiated 1 ExternalCommandListener. [2022-10-16 21:58:21 +0200] information/ConfigItem: Instantiated 1 Endpoint. [2022-10-16 21:58:21 +0200] information/ConfigItem: Instantiated 4 ApiUsers. [2022-10-16 21:58:21 +0200] information/ConfigItem: Instantiated 1 ApiListener. [2022-10-16 21:58:21 +0200] information/ConfigItem: Instantiated 1 NotificationComponent. [2022-10-16 21:58:21 +0200] information/ConfigItem: Instantiated 244 CheckCommands. [2022-10-16 21:58:21 +0200] information/ConfigItem: Instantiated 2 UserGroups. [2022-10-16 21:58:21 +0200] information/ConfigItem: Instantiated 3 TimePeriods. [2022-10-16 21:58:21 +0200] information/ConfigItem: Instantiated 6 Users. [2022-10-16 21:58:21 +0200] information/ConfigItem: Instantiated 549 Services. [2022-10-16 21:58:21 +0200] information/ConfigItem: Instantiated 2 NotificationCommands. [2022-10-16 21:58:21 +0200] information/ScriptGlobal: Dumping variables to file '/var/cache/icinga2/icinga2.vars' [2022-10-16 21:58:21 +0200] information/cli: Finished validating the configuration file(s).