Eli Mesika has posted comments on this change.

Change subject: Adding host bios fields to vdsStatic table
......................................................................


Patch Set 2: (1 inline comment)

....................................................
File backend/manager/dbscripts/create_views.sql
Line 637:                       CASE WHEN storage_pool.spm_vds_id = 
vds_static.vds_id THEN CASE WHEN storage_pool.status = 5 THEN 1 ELSE 2 END ELSE 
0 END as spm_status, vds_dynamic.supported_cluster_levels as 
supported_cluster_levels, vds_dynamic.supported_engines as supported_engines, 
vds_groups.compatibility_version as vds_group_compatibility_version,
Line 638:                       vds_dynamic.host_os as host_os, 
vds_dynamic.kvm_version as kvm_version, vds_dynamic.libvirt_version as 
libvirt_version, vds_dynamic.spice_version as spice_version, 
vds_dynamic.kernel_version as kernel_version, vds_dynamic.iscsi_initiator_name 
as iscsi_initiator_name,
Line 639:                       vds_dynamic.transparent_hugepages_state as 
transparent_hugepages_state, vds_dynamic.anonymous_hugepages as 
anonymous_hugepages, vds_dynamic.non_operational_reason as 
non_operational_reason,
Line 640:                       vds_static.recoverable as recoverable, 
vds_static.sshKeyFingerprint as sshKeyFingerprint, vds_static.biosManufacturer 
as biosManufacturer, vds_static.biosProductName as biosProductName, 
vds_static.biosVersion as biosVersion,
Line 641:                       vds_static.biosSerialNumber as 
biosSerialNumber, vds_static.biosUUID as biosUUID, vds_static.biosFamily as 
biosFamily
agree
Line 642: FROM         vds_groups INNER JOIN
Line 643: vds_static ON vds_groups.vds_group_id = vds_static.vds_group_id INNER 
JOIN
Line 644: vds_dynamic ON vds_static.vds_id = vds_dynamic.vds_id INNER JOIN
Line 645: vds_statistics ON vds_static.vds_id = vds_statistics.vds_id LEFT 
OUTER JOIN


--
To view, visit http://gerrit.ovirt.org/10114
To unsubscribe, visit http://gerrit.ovirt.org/settings

Gerrit-MessageType: comment
Gerrit-Change-Id: Id330288a13490475a61625eb0b6076153fec422f
Gerrit-PatchSet: 2
Gerrit-Project: ovirt-engine
Gerrit-Branch: master
Gerrit-Owner: Yaniv Bronhaim <ybron...@redhat.com>
Gerrit-Reviewer: Alon Bar-Lev <alo...@redhat.com>
Gerrit-Reviewer: Barak Azulay <bazu...@redhat.com>
Gerrit-Reviewer: Eli Mesika <emes...@redhat.com>
Gerrit-Reviewer: Yair Zaslavsky <yzasl...@redhat.com>
Gerrit-Reviewer: Yaniv Bronhaim <ybron...@redhat.com>
_______________________________________________
Engine-patches mailing list
Engine-patches@ovirt.org
http://lists.ovirt.org/mailman/listinfo/engine-patches

Reply via email to