Bug 1874029

Summary:	Missing column in inventory dashboard
Product:	[oVirt] ovirt-engine-dwh	Reporter:	Aviv Litman <alitman>
Component:	Grafana	Assignee:	Aviv Litman <alitman>
Status:	CLOSED CURRENTRELEASE	QA Contact:	Ivana Saranova <isaranov>
Severity:	medium	Docs Contact:
Priority:	medium
Version:	4.4.1	CC:	lleistne, sradco
Target Milestone:	ovirt-4.4.3	Keywords:	ZStream
Target Release:	4.4.3	Flags:	pm-rhel: ovirt-4.4+ pm-rhel: planning_ack+ pm-rhel: devel_ack+ lleistne: testing_ack+
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:	ovirt-engine-dwh-4.4.3	Doc Type:	If docs needed, set a value
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2020-11-11 06:39:31 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:	1879377

Description Aviv Litman 2020-08-31 11:21:11 UTC

Description of problem:
We want to add 'num_of_running_vms' column to the main select statement (the column appear in the rest of the query), so the user can see the number of running virtual machines. 

Version-Release number of selected component (if applicable):
4.4.1

How reproducible:
100%

Steps to Reproduce:
1.go to oVirt Inventory Dashboards
2.go to Hosts Inventory Dashboard
3.look at Data Center Inventory (BR48) query 

Actual results:
num_of_running_vms column is missing in the main select statement. 

Expected results:
num_of_running_vms column is in the main select statement.

Comment 1 Ivana Saranova 2020-10-22 15:32:24 UTC

Steps:
1. In Monitoring portal, go to the oVirt Inventory dashboards
2. Go to Inventory Dashboard
3. Check that Data Centers Inventory shows number of running VMs

Result:
Data Centers Inventory is showing the number of running VMs under the 'Running VMs' column. There is no Data Centers Inventory query in Hosts Inventory Dashboard.

Verified in:
ovirt-engine-dwh-4.4.3.1-1.el8ev.noarch
ovirt-engine-4.4.3.7-0.22.el8ev.noarch

Comment 2 Sandro Bonazzola 2020-11-11 06:39:31 UTC

This bugzilla is included in oVirt 4.4.3 release, published on November 10th 2020.

Since the problem described in this bug report should be resolved in oVirt 4.4.3 release, it has been closed with a resolution of CURRENT RELEASE.

If the solution does not work for you, please open a new bug report.