Shirly Radco has uploaded a new change for review. Change subject: history: collect additional host hardware details ......................................................................
history: collect additional host hardware details Change-Id: I9a1c44f8870dafe7aa03c681cd097b9e7b17972b Bug-Url:https://bugzilla.redhat.com/1209931 Signed-off-by: Shirly Radco <[email protected]> --- M packaging/dbscripts/create_views_3_6.sql A packaging/dbscripts/upgrade/03_06_0030_added_host_hardware_details.sql 2 files changed, 16 insertions(+), 0 deletions(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-dwh refs/changes/41/41641/1 diff --git a/packaging/dbscripts/create_views_3_6.sql b/packaging/dbscripts/create_views_3_6.sql index 4b32ac0..fe63230 100644 --- a/packaging/dbscripts/create_views_3_6.sql +++ b/packaging/dbscripts/create_views_3_6.sql @@ -219,6 +219,11 @@ ELSE vdsm_version END as vdsm_version, vdsm_port as vdsm_port, + cpu_threads as cpu_threads, + hardware_manufacturer as hardware_manufacturer, + hardware_product_name as hardware_product_name, + hardware_version as hardware_version, + hardware_serial_number as hardware_serial_number, cluster_configuration_version as cluster_configuration_version, create_date as create_date, update_date as update_date, @@ -251,6 +256,11 @@ ELSE vdsm_version END as vdsm_version, vdsm_port as vdsm_port, + cpu_threads as cpu_threads, + hardware_manufacturer as hardware_manufacturer, + hardware_product_name as hardware_product_name, + hardware_version as hardware_version, + hardware_serial_number as hardware_serial_number, cluster_configuration_version as cluster_configuration_version, create_date as create_date, update_date as update_date diff --git a/packaging/dbscripts/upgrade/03_06_0030_added_host_hardware_details.sql b/packaging/dbscripts/upgrade/03_06_0030_added_host_hardware_details.sql new file mode 100644 index 0000000..22df3ba --- /dev/null +++ b/packaging/dbscripts/upgrade/03_06_0030_added_host_hardware_details.sql @@ -0,0 +1,6 @@ +select fn_db_add_column('host_configuration', 'cpu_threads', 'integer'); +select fn_db_add_column('host_configuration', 'hardware_manufacturer', 'character varying(255)'); +select fn_db_add_column('host_configuration', 'hardware_product_name', 'character varying(255)'); +select fn_db_add_column('host_configuration', 'hardware_version', 'character varying(255)'); +select fn_db_add_column('host_configuration', 'hardware_serial_number', 'character varying(255)'); + -- To view, visit https://gerrit.ovirt.org/41641 To unsubscribe, visit https://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I9a1c44f8870dafe7aa03c681cd097b9e7b17972b Gerrit-PatchSet: 1 Gerrit-Project: ovirt-dwh Gerrit-Branch: master Gerrit-Owner: Shirly Radco <[email protected]> _______________________________________________ Engine-patches mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/engine-patches
