Yaniv Dary has submitted this change and it was merged. Change subject: history: sync users data for user usage tables ...................................................................... history: sync users data for user usage tables Added users_details_history table to history db, added user_id to vm_samples_history, vm_hourly_history and vm_daily_history. Added views v3_5_users_details_history and v3_5_latest_users_details and added user_id to v3_5_statistics_vms_resources_usage_samples, v3_5_statistics_vms_resources_usage_hourly and v3_5_statistics_vms_resources_usage_daily. Added user_id to ETL process. Update legacy views. Added Users to v3_5_tags_relations_history and v3_5_latest_tags_relations views. Change-Id: Id236a3112947e00a58175f0361d44afda692b894 Bug-Url: https://bugzilla.redhat.com/1091687 , https://bugzilla.redhat.com/1018416 Signed-off-by: Shirly Radco <sradco@redhat.com> --- M etl_export/src/ovirt_engine_dwh/aggregationtodaily_3_5/AggregationToDaily.java M etl_export/src/ovirt_engine_dwh/aggregationtohourly_3_5/AggregationToHourly.java M etl_export/src/ovirt_engine_dwh/configurationsync_3_5/ConfigurationSync.java M etl_export/src/ovirt_engine_dwh/statisticssync_3_5/StatisticsSync.java M packaging/dbscripts/create_views_3_0.sql M packaging/dbscripts/create_views_3_1.sql M packaging/dbscripts/create_views_3_2.sql M packaging/dbscripts/create_views_3_3.sql M packaging/dbscripts/create_views_3_4.sql M packaging/dbscripts/create_views_3_5.sql A packaging/dbscripts/upgrade/03_05_0030_add_users_history_table.sql M tos_project/process/AggregationToDaily_3.5.item M tos_project/process/AggregationToDaily_3.5.properties M tos_project/process/AggregationToHourly_3.5.item M tos_project/process/AggregationToHourly_3.5.properties M tos_project/process/ConfigurationSync_3.5.item M tos_project/process/ConfigurationSync_3.5.properties M tos_project/process/StatisticsSync_3.5.item M tos_project/process/StatisticsSync_3.5.properties 19 files changed, 6,067 insertions(+), 1,113 deletions(-) Approvals: Shirly Radco: Verified Yaniv Dary: Looks good to me, approved -- To view, visit http://gerrit.ovirt.org/27338 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: merged Gerrit-Change-Id: Id236a3112947e00a58175f0361d44afda692b894 Gerrit-PatchSet: 14 Gerrit-Project: ovirt-dwh Gerrit-Branch: master Gerrit-Owner: Shirly Radco <sradco@redhat.com> Gerrit-Reviewer: Shirly Radco <sradco@redhat.com> Gerrit-Reviewer: Yaniv Dary <ydary@redhat.com> Gerrit-Reviewer: automation@ovirt.org Gerrit-Reviewer: oVirt Jenkins CI Server