Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 1931939

Summary: [RFE] Add the engine FQDN to dwh
Product: [oVirt] ovirt-engine-dwh Reporter: Aviv Litman <alitman>
Component: SetupAssignee: Aviv Litman <alitman>
Status: CLOSED CURRENTRELEASE QA Contact: Pavel Novotny <pnovotny>
Severity: medium Docs Contact:
Priority: medium    
Version: 4.4.4CC: bugs, didi, emarcus, mperina, sradco
Target Milestone: ovirt-4.5.0Keywords: FutureFeature
Target Release: 4.5.0Flags: mperina: ovirt-4.5+
alitman: planning_ack?
mperina: devel_ack+
gdeolive: testing_ack+
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: ovirt-engine-dwh-4.5.0 Doc Type: Enhancement
Doc Text:
Feature: add engine fqdn column to dwh Reason: to be able to link to the admin portal when dwh is on separate machine Result: the engine fqdn is available in dwh, in the history_configuration table.
Story Points: ---
Clone Of: Environment:
Last Closed: 2022-05-23 06:21:25 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: Metrics RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On:    
Bug Blocks: 1925878, 1927175    

Description Aviv Litman 2021-02-23 15:49:07 UTC
Description of problem:

we want to add the engine fqdn to the history db under history_configuration table, in order to use it in Grafana links.

In Grafana we can create a link based on a cell in a table,
Link to the admin portal in Grafana (example):
/ovirt-engine/webadmin/?locale=en_US#hosts-general;name=${__cell}

When DWH and the engine are in different machines, a problem arises in adding links to Grafana- the link leads to the DWH machine FQDN and not to the engine machine FQDN.

Comment 1 Pavel Novotny 2022-05-06 22:17:28 UTC
Verified in
ovirt-engine-4.5.0.6-0.7.el8ev.noarch
ovirt-engine-dwh-4.5.2-1.el8ev.noarch

The engine FQDN is stored in the history_configuration table under var_name = 'EngineFQDN'.
It is used as a parameter in all dashboards as part of RFE bug 1925878.