Red Hat Bugzilla – Bug 1148745
[DOC][Bug-FIX] DWH and reporting Section - overhaul
Last modified: 2016-01-26 20:59:37 EST
Description of problem: http://documentation-devel.engineering.redhat.com/site/documentation/en-US/Red_Hat_Enterprise_Virtualization/3.5-Beta/html/Administration_Guide/chap-Reports_History_Database_Reports_and_Dashboards.html Has several errors and needs to be re-written. Shirly will supply an attachment indicating the problems. Version-Release number of selected component (if applicable): How reproducible: Steps to Reproduce: 1. 2. 3. Actual results: Expected results: Additional info:
Adding James to the Cc list. Laura, Please work with Shirly and James for a list of topics you need to work on. Depending on the scope of this bug, I don't think we can get everything covered for the Oct-22 cycle. Please identify the deliverables for this cycle. Cheers, Julie
Hi Shirly, Could you provide us with a status update for this bug please. I also saw that you have filed some more report/dwh bugs. They are either assigned to Laura or Lucy. Let me know if you have any questions for the docs team. Many thanks, Julie
Please change the history views initial according to the current version. Example: Table 23.12. v3_2_configuration_history_datacenters should be Table 23.12. v3_5_configuration_history_datacenters. Also make sure that the views columns names are accurate.
Please add documentation for the "User Details History", under "23.2.9. Configuration History Views" section. Users extended details in the system. Engine consumes users and groups from authorization providers. The authorization providers can be LDAP based, and can be non LDAP based. Table v3_6_users_details_history view: user_id - uuid -The unique ID of the user in the system. Generated by engine. first_name - varchar(255) - The users first name last_name - varchar(255) -The users last name domain - varchar(255) -The name of the authorization extension. username - varchar(255) - The account name department - varchar(255) - The organizational department the user belongs to user_role_title - varchar(255) - The title of the user in the organization email - varchar(255) - The email of the user in the organization external_id - text -The unique identifier of the user from the external system. active - Boolean - If the user is active or not - this is being checked once in an hour, if the user can be found in the authorization extension then it will remain active. A user can be turned to active also on successful login. create_date - timestamp with time zone -The date this entity was added to the system. update_date - timestamp with time zone - The date this entity was changed in the system. delete_date - timestamp with time zone - The date this entity was deleted from the system.
Please add to the documentation a note that we recommend syncing the servers according to UTC timezone. There is already a bug that includes this in the docs required.
# In all statistics views under "23.2.8. Statistics History Views" section the column "history_id" Type changed to bigint. # Add to Table "23.6. Historical Statistics for Each Storage Domain in the System" Columns: storage_domain_status - smallint - The storage domain status. minutes_in_status - decimal - The total number of minutes that the storage domain was in the status shown in the status column for the aggregation period. For example, if a storage domain was Active for 55 minutes and Inactive for 5 minutes during an hour, two rows will show for this hour. One will have a status of Active and minutes_in_status of 55, the other will have a status of Inactive and a minutes_in_status of 5. # Add to Table Table "23.7. Historical Statistics for Each Host in the System" Columns: ksm_shared_memory_mb - bigint - The Kernel Shared Memory size megabytes (MB) on the host is using. max_ksm_shared_memory_mb - bigint - The maximum KSM memory usage for the aggregation period megabytes (MB). For hourly aggregations, this is the maximum collected sample value. For daily aggregations, it is the maximum hourly average value. # Add to Table "23.9. Historical statistics for the virtual machines in the system" Column: current_user_id - uuid - The unique ID of the user in the system. Generated by engine. # Add to "Table 23.16. v3_5_configuration_history_hosts" Columns: number_of_sockets - smallint - Total number of CPU sockets cpu_speed_mh - decimal - The host's CPU speed in megahertz # "Table 23.17. v3_2_configuration_history_hosts_interfaces" change column name "network_name" to "logical_network_name" # "Table 23.18. v3_5_configuration_history_vms" Change the "operating_system" description to: 0 - Other OS 1 - Windows XP 3 - Windows 2003 4 - Windows 2008 5 - Linux 7 - Red Hat Enterprise Linux 5.x 8 - Red Hat Enterprise Linux 4.x 9 - Red Hat Enterprise Linux 3.x 10 - Windows 2003 x64 11 - Windows 7 12 - Windows 7 x64 13 - Red Hat Enterprise Linux 5.x x64 14 - Red Hat Enterprise Linux 4.x x64 15 - Red Hat Enterprise Linux 3.x x64 16 - Windows 2008 x64 17 - Windows 2008 R2 x64 18 - Red Hat Enterprise Linux 6.x 19 - Red Hat Enterprise Linux 6.x x64 20 - Windows 8 21 - Windows 8 x64 23 - Windows 2012 x64 1001 - Other 1002 - Linux 1003 - Red Hat Enterprise Linux 6.x 1004 - SUSE Linux Enterprise Server 11 1193 - SUSE Linux Enterprise Server 11 1252 - Ubuntu Precise Pangolin LTS 1253 - Ubuntu Quantal Quetzal 1254 - Ubuntu Raring Ringtails 1255 - Ubuntu Saucy Salamander Remove column "ad_domain" Add columns: vm_pool_id - The virtual machine's pool unique ID. vm_pool_name - The virtual machine's pool name # "Table 23.19. v3_5_configuration_history_vms_interfaces" Remove column "vm_id" change column name "network_name" to "logical_network_name" # Remove view "23.2.9.10. Disks to Virtual Machine Map" including : "Table 23.20. disks_vm_map table" change to "Table 23.20. v3_5_configuration_history_vms_devices" # Add Section "virtual machine's device configuration" A map showing the relationships between virtual machines and the devices - Disks and virtual interfaces" Table "v3_5_configuration_history_vms_devices" history_id - integer - The ID of the configuration version in the history database. vm_id - uuid - The unique ID of the virtual machine in the system. device_id - uuid - The unique ID of the device in the system. type - varchar(30) - VM Device Type - "disk" or "interface" address - varchar(255) -The virtual machine's device physical address is_managed - boolean - Flag that indicates if the device is managed by RHEVM is_plugged - boolean - Flag that indicates if the device is plugged into the virtual machine is_readonly - boolean - Flag that indicates if the device is read only vm_configuration_version - integer - The virtual machine configuration version at the time of sample. device_configuration_version - integer - The device configuration version at the time of sample. create_date timestamp with time zone - timestamp with time zone - The date this entity was added to the system. update_date timestamp with time zone - timestamp with time zone - The date this entity was added to the system. delete_date timestamp with time zone - timestamp with time zone - The date this entity was added to the system. # "Table 23.21. v3_2_configuration_history_vms_disks" Add column: is_shared - boolean - Flag that indicates if the virtual machine's disk is shared image_id - uuid - The unique ID of the image in the system.
1. Please update for all views names from v3_2 to v3_5. 2. I see an error in the section: "23.2.9.6. Host Configuration" 3. In "v3_5_configuration_history_vms" column " vm_pool_name" update type to varchar(255)