Send the link below via email or IMCopy
Present to your audienceStart remote presentation
- Invited audience members will follow you as you navigate and present
- People invited to a presentation do not need a Prezi account
- This link expires 10 minutes after you close the presentation
- A maximum of 30 users can follow your presentation
- Learn more about this feature in our knowledge base article
Transcript of RHEV Reports
- Installation Procedure
- Logging in to Access the Reports Portal
- User management
- How to access various pre-configured reports
- How it works in background
- Role of Dataware housing (dwh)
- Custom RHEV-M ad hoc report creation
Red Hat Enterprise Virtualization Reports
Report Engine is a built-in reporting tool for Red Hat Enterprise Virtualization Manager. It is comprised of JasperReports and JasperServer which are open source reporting tools.
Red Hat Enterprise Virtualization provides a customized implementation of JasperServer, which allows web-based access to a range of pre-configured reports and dashboards, plus the ability to create ad hoc reports.
What does it provide ?
: list of current system resources including physical hosts, storage domains, and virtual machines.
: Monitor your entire rhev environment and know various trends, Like most utilized hosts/vms in given time.
: In capacity planning we try and answer key questions, Whether you are running out off resources on your environment as well as how many more virtual machine can be fit in your environment. Using 3 matrix, CPU ,Storage,Memory
can produce reports which can be rendered to screen, printed, or exported to a
variety of formats including PDF, CSV, Word, Excel, RTF, Flash, ODT and ODS.
allows reports built in JasperReports to be accessed via a web interface.
# yum install rhevm-reports-setup rhevm-dwh-setup -y
--== PRODUCT OPTIONS ==--
Configure Reports on this host (Yes, No) [Yes]:
Configure Data Warehouse on this host (Yes, No) [Yes]:
--== DATABASE CONFIGURATION ==--
Where is the DWH database located? (Local, Remote) [Local]:
Setup can configure the local postgresql server automatically for the DWH to run. This may conflict with existing applications.
Would you like Setup to automatically configure postgresql and create DWH database, or prefer to perform that manually? (Automatic, Manual) [Automatic]:
Where is the Reports database located? (Local, Remote) [Local]:
Setup can configure the local postgresql server automatically for the Reports to run. This may conflict with existing applications.
Would you like Setup to automatically configure postgresql and create Reports database, or prefer to perform that manually? (Automatic, Manual) [Automatic]:
--== MISC CONFIGURATION ==--
Reports power users password:
Confirm Reports power users password:
Upon completing the rhevm report installation and setup , A second database called
which contains historical configuration information and statistical metrics collected every minute over time from the engine operational database.
engine >> ETL Service >> ovirt_engine_history < JasperReports < jasperReports Server < Report Portal
The replication of data in the ovirt_engine_history database is performed by the Red Hat Enterprise Virtualization Manager Extract Transform Load Service,
To access Report Engine, use a newer browser such as Firefox or Internet Explorer to access
the following URL:
- Logging in to Access the Reports Portal
When prompted for a log in, provide the username admin and the password assigned
to the report administrator account when the rhevm-reports-setup command was executed.
Report user accounts are different than the RHEV users that administer the hypervisor hosts
and virtual machines. Although directory service integration is not possible, Report portal
has its own in-built user management capability.
Once logged into the Report Engine web interface, report users can be created and managed
by hovering the mouse over the Manage tab, then selecting the Users menu item.
There are three roles, each of which provides a different level of permissions:
Can create/edit/delete reports, dashboards, ad hoc reports,
and manage the server.
Can create/edit/delete ad hoc reports and view reports and dashboards.
Can log in and look at reports and dashboards.
I installed rhevm-reports and setup successfully completed , So am I
ready to generate reports and show them to management
WAIT WAIT .......
Sufficient data must exist in the history database to produce meaningful reports.
Most reports use values aggregated on a daily basis. Meaningful reports can only
be produced if data for at least several days is available. In particular, because
trend reports are designed to highlight long term trends in the system, a sufficient
history is required to highlight meaningful trends.
In later slides, I will show how exactly data is extracted from engine database and stored in ovirt_engine_history
- How to access various pre-configured reports
After login into RHEV Report Portal, There are various way to access pre-configured reports .
- Search reports in Library
An easy way to see which reports are available is to use the Repository. To see which predefined reports are available in the repository navigate to
in the top navigation bar and select
. Expand the RHEVM Reports folder to see the menus that are available.
The Reports menu has further sub-menus that include the following choices:
• Service Level
– High level reports that highly summarize data on resources and system entities.
– Reports that list entities or display data about their status.
– Report that are used to examine system health and service quality to users.
– Graphs that indicate resource usage for planning of resources.
oVirt Reports Topics
sub-menu contains high-level overviews of system status useful for capacity planning. The
sub-menu reports list current system resources including physical hosts, storage domains, and virtual machines. The reports in the
sub-menu display information about system performance and availability within user-defined thresholds. Finally the reports in the
sub-menu highlight changes in system utilization and availability which are useful for identifying problems and bottlenecks in the system and for planning capacity expansion.
AD HOC REPORTS
Along with pre-configered reports, Users can also create custom reports as per their
need. Red Hat Enterprise Virtualization Reports provides a tool to create
customized ad hoc reports.
To create an Ad Hoc Report as an administrator, navigate to the
on the top menu bar and select
Ad Hoc View
to open the Data Chooser: Source window.
This topic is used to create simple hosts inventory reports using the ad hoc reports creator.
This topic is used to create simple virtual machines inventory reports using the ad hoc reports creator.
Host Inventory Topic
Virtual Machine Inventory topic
which are used to view values in the database and to summarize the values in columns.
which compare one or more measures across multiple sets of related fields.
which aggregates data across multiple dimensions.
Ad Hoc View Types
The 'ovirt_engine_history ' database created at the time of report installation is the heart of reporting
portal, Red Hat Enterprise Virtualization Reports uses data from the Red Hat Enterprise Virtualization
History Database (called ovirt_engine_history) which tracks the engine database over time.
Using ETL service,
oad, statistical data is collected from engine database
and transferred into ovirt_engine_history table, History database is exposed through API
Minute-by-minute data more than two hours old is aggregated into hourly data and stored for two months. Hourly data more than two days old is aggregated into daily data and stored for five years.
Each statistical datum is kept in its respective aggregation level table: samples, hourly, and daily history. RHEV Data Warehouse ETL service is based on
Talend Open Studio
The ETL service, ovirt-engine-dwhd, tracks three types of changes:
is added to the engine database - the ETL Service replicates the change to the ovirt_engine_history database as a new entry.
is updated - the ETL Service replicates the change to the ovirt_engine_history database as a new entry.
entity is removed
from the engine database - A new entry in the ovirt_engine_history database flags the corresponding entity as removed. Removed entities are only flagged as removed. To maintain correctness of historical reports and representations, they are not physically removed.
Sample data is collected at the end of every minute and is kept for up to 24 hours.
Hourly level is aggregated every hour for the hour before last and is kept for 2 months.
Daily level is aggregated every day for the day before last and is kept for 5 years.
Report Portal also includes few pre-configured dashboards. A dashboard is a collection of related reports that provide a summary of resource usage in the virtualized environment. Dashboards feature an active control panel, allowing quick adjustment of the parameters.
Inventory Dashboard :
The Inventory Dashboard provides an executive summary of the inventory of a data center over a given period of time. The dashboard includes average disk use, number of active virtual machines, and a breakdown of host operating systems.
The Uptime Dashboard provides an executive summary of the service level and uptime for a data center over a given period of time. The dashboard includes details on total uptime for each cluster in the data center for the period.
The Trends Dashboard provides an executive summary of the trends in a data center over a given period of time. The dashboard includes graphs of CPU and memory usage over time for the most highly utilized hosts and virtual machines in the data center.
To Access dashboards. One library page and type "dashboard" in search bar
Right-click Reporting Integration with REHVM Admin Portal
The Administration portal provides integrated access to reports on most resources. To access a report on a given resource, select the resource in the Administration Portal. Right-click the resource to show a context sensitive menu, and select the Show Report option. This expands to show all of the available reports on the selected resource.
- Dataware housing Logs (ETL related problem )
JasperServer Logs (GUI related issues, Data not showing in reports, etc...)
How it works in background
- Installation and setup logs
Create a custom report called Custom "TCL_TEST" Report that displays a list of current virtual machine configuration information. It should have five columns with the following data and titles:Name