Bug 891073

Summary: [rhevm-dwh] History DB - Change Fields "Network Name" to "Logical Network Name"
Product: Red Hat Enterprise Virtualization Manager Reporter: David Botzer <dbotzer>
Component: ovirt-engine-dwhAssignee: Shirly Radco <sradco>
Status: CLOSED ERRATA QA Contact: Pavel Stehlik <pstehlik>
Severity: low Docs Contact:
Priority: low    
Version: 3.1.0CC: aberezin, bazulay, bsettle, iheim, pstehlik, rbalakri, Rhev-m-bugs, ylavi
Target Milestone: ---Flags: dyasny: Triaged+
Target Release: 3.5.0   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard: infra
Fixed In Version: oVirt 3.5 Alpha 1 Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2015-02-11 18:14:09 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: Infra RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On:    
Bug Blocks: 1142923, 1156165    
Attachments:
Description Flags
NetworkName none

Description David Botzer 2013-01-01 14:44:42 UTC 
Created attachment 670984 [details]
NetworkName

Description of problem:
In webadmin the entity name is"Logical Network"
And in History DB / Reports this entity fields are called only "Network"
e.x
"Network Name"

In order to distinguish, and allow coralation between Webadmin & Reports

Version-Release number of selected component (if applicable):
3.1/si25.2

How reproducible:
always

Steps to Reproduce:
1.Examine Engine DB table "network" the field name is "Network Name"
2.Examine Engine DB "vds_interface" the field name is "Network Name"
3.Examine History DB "v3_1_host_interface_configuration_view" the field name is "Network Name"
4.Examine in Webadmin under cluster, See Logical Networks Tab
  name of entity is "Logical Network"
  
Actual results:
field name is "Network Name"

Expected results:
Should change to "Logical Network Name"

Additional info:
Comment 3 Barak Dagan 2014-06-11 12:52:03 UTC 
Verified on oVirt 3.5 Alpha 1:

bash-4.1$ psql -d engine -c "select table_name, column_name from information_schema.columns where table_name like '%dwh%view%' and column_name like '%network%';"

                  table_name                   |     column_name      
-----------------------------------------------+----------------------
 dwh_host_interface_configuration_history_view | logical_network_name
 dwh_vm_interface_configuration_history_view   | logical_network_name



bash-4.1$ psql -d ovirt_engine_history -c "select table_name, column_name from information_schema.columns where table_name like 'v3_5%configuration%' and column_name like '%network%';"

                 table_name                  |     column_name      
---------------------------------------------+----------------------
 v3_5_configuration_history_hosts_interfaces | logical_network_name
 v3_5_latest_configuration_hosts_interfaces  | logical_network_name
 v3_5_configuration_history_vms_interfaces   | logical_network_name
 v3_5_latest_configuration_vms_interfaces    | logical_network_name
Comment 6 errata-xmlrpc 2015-02-11 18:14:09 UTC 
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

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

https://rhn.redhat.com/errata/RHEA-2015-0177.html