Using Oracle Enterprise Manager 10g Release 2 Information Publisher to Create Reports
Using Oracle Enterprise Manager 10g Release 2
Information Publisher to Create Reports
Purpose
This tutorial provides
instructions for creating and publishing reports using Information Publisher.
Oracle Enterprise Manager 10g Release 2 includes an HTML-based
Information Publisher that is integrated with the Enterprise Manager console.
Information Publisher provides the ability to easily create and publish customized
reports.
Reports can be generated and viewed interactively, or they
can be published on a schedule and stored and e-mailed to selected recipients.
Place the cursor over this icon to load and view all
the screenshots for this tutorial. (Caution: Because this action loads all screenshots
simultaneously, response time may be slow depending on your Internet connection.)
Note: Alternatively, you can place the cursor
over each individual icon in the following steps to load and view only the screenshot
associated with that step.
The screenshots will not reflect the specific environment
you are using. They are provided to give you an idea of where to locate specific
functionality in the Oracle Enterprise Manager 10g Grid Control console.
Overview
Reports are used to present a view of enterprise monitoring
information for business intelligence purposes. Reports can show aggregate information
over a business-oriented period of time, such as a week (Sun-Sat) or a month
(September 2005). Reports are not generally used for day-to-day monitoring and
administration; the Oracle Enterprise Manager 10g Release 2 console is designed for these tasks.
Administrators can use reports to show the activity, resource utilization, and
configuration of managed targets. IT managers can use reports to show the availability
of sets of managed systems. Executives can view reports on the availability
of applications (such as corporate email) over a period of time.
Information Publisher includes a set of predefined report
definitions and element building blocks. A report definition specifies the content
of the report that you want to generate. It also includes various attributes,
(for example an optional schedule). You can use predefined report definitions
directly ("Oracle HTTP/HTTPS Traffic") or create your own. When you
create your own report definitions, you can:
- Start with a predefined report definition and customize it to meet your needs
- Create a report definition from scratch by selecting the elements that you
want to include in the report
Oracle Enterprise Manager 10g
Release 2 Control provides a variety of out-of-box reports such as monitoring, configuration
and service level reports. These reports are available to all Enterprise Manager
administrators and they cannot be deleted. Users can view out-of-box reports
in real time (on-demand) as well as customize them, and schedule and share customized
reports. There are many out-of-box reports that you can view. In this tutorial
you look at the Availability History (Target) report. To view the out-of-box
report, perform the following steps:
1.
Open the browser and enter the following URL:
http://<management
service hostname>.<domain>:<port>/em/
The default port value on a clear machine is 7777. However,
if there are other instances running on the machine, then the port may
be different.
The login page will be displayed. Enter the User Name
and Password, and then click the Login button.
2.
The Oracle Enterprise Manager 10g Grid Control Home page appears showing you
a high-level summary of your entire environment. Click the Reports
tab.
3.
You can see the Report Definitions page. Using this page, you can search
for a particular report, create new reports, customize out-of-box reports,
and delete custom reports. Scroll down and click the Availability History
(Target) report.
4.
Click the flashlight icon to select the target.
5.
Select Host from the Target Type drop-down list, select the assigned
host, and click the Select button.
6.
Click the Continue button.
7.
You can now view the Availability History by Target report. Click the
Printable Page button. Printable Page is used to fully expand tables
in cases where there is paging in tables. This does not automatically
print the page.
8.
You are now viewing the printable page of the report. Click the Back
button of the browser.
9.
Click the Set Time Period button to select the time range for
viewing the data for a different time period.
10.
Select the Previous Time Period option button. Enter 12
next to the Days drop-down list, and click Continue.
11.
You can now see the history for the previous 12 days. Scroll down and
click the Return to Report Definitions link.
In addition to using the out-of-box reports you can also create
new reports to suit your needs. This section covers how to create a report.
The report provides a comparison between a user-supplied host and a baseline
host. To create a report, perform the following steps:
1.
To create a new report, click the Create button.
2.
Specify the title for the report, and select the category and the subcategory.
Select Host from the Target Type drop-down list. Select the Allow
the report viewer to customize the time period check box. Finally,
click the Elements tab.
3.
Click the Add button to add the element for the user-supplied
host.
4.
Select Metric Details from the elements list, and click Continue.
5.
After selecting the element, the next step is to set the parameters.
Click the Set Parameters icon.
6.
Specify Selected Host CPU Utilization as the header. Select Load:
CPU Utilization (%) from the metric list, and then click Continue.
7.
Now you add the element for the baseline host. Click the Add button.
8.
Select Metric Details from the elements list, and click Continue.
9.
After selecting the element, set the parameters. Click the Set Parameters
icon.
10.
Specify Baseline Host CPU Utilization as the header. Select the
Use Element-specific Targets Selected Below option button. Click
the Add button to add the target.
11.
Select a host that you want to use as a baseline, and click Select.
12.
Select Load: CPU Utilization (%) from the metric list, and then
click Continue.
13.
Click the Add button to add the second element for the user-supplied
host.
14.
Select Metric Details from the elements list, and click Continue.
15.
Click the Set Parameters icon.
16.
Specify Selected Host: Filesystem Space Available(%) as the header.
Select Filesystems: Filesystem Space Available(%) from the metric
list and then click Continue.
17.
Now you add the second element for the baseline host. Click the Add
button.
18.
Select Metric Details from the elements list, and click Continue.
19.
Click the Set Parameters icon.
20.
Specify Baseline Host: Filesystem Space Available(%) as the header.
Select the Use Element-specific Targets Selected Below option button.
Click the Add button to add the target.
21.
Select the host that you are using as a baseline, and click Select.
22.
Select Filesystems: Filesystem Space Available(%) from the metric
list, and then click Continue.
23.
After adding all the elements, click the Preview button to preview
the report.
24.
Click the flashlight icon to select the target.
25.
Select the host that you want to use for comparison, and click Select.
26.
Click Continue.
27.
You can now see that four graphs are displayed in one column. However,
it would be better to compare if the graphs are displayed in two columns.
To change the layout, scroll down and click the Return to Create Report
Definition link.
28.
Click the Layout button.
29.
Move the element from row 2 to row 1, and the elements from row 3 and
row 4 to row 2. Click Continue.
30.
Click the Preview button to validate that the graphs are displayed
side-by-side.
31.
Click the flashlight icon to select the target.
32.
Select the host that you want to use for comparison, and click Select.
33.
Click Continue.
34.
You can now see that the graphs are displayed side-by-side. Click the
Return to Create Report Definition link.
35.
Click the OK button to save the report.
36.
You have successfully created the comparison report.
In addition to creating a new report from scratch, you can
also customize an existing out-of-box report according to your requirement.
To customize out-of-box reports, perform the following steps:
1.
Scroll down on the reports definition
page to select the Alerts and Policy Violations History (Target) report,
and click the Create Like button.
2.
Change the report title. Select the Use the specified target
option button and click the flashlight icon to select the target that
you want to use for this report.
3.
Select Host from the Target Type drop-down list. Select any
host, and click Select.
4.
Select the Run report using target privileges of the report owner
check box, and click the Preview button to see whether you get
the hard-coded target.
5.
You can see the report output that is based on the target that you
specified during the definition. Scroll down and click the Return
to Create Report Definition link.
6.
Click the Schedule subtab to schedule report generation.
7.
Select the Schedule Report check box. Select the Repeating
option button. Select By Days from the Frequency Type drop-down
list, and enter 2 days for the Repeat Every text box. Select
the Specified Date option button and specify the date. Select
the Save a copy of report each time the scheduled report completes
check box. Apart from scheduling the report, you can also give access
permissions for your report to selected administrators. Click the Access
subtab to do this.
Note: To schedule a report, the report must be e-mailed or saved.
8.
Click the Add button to add the administrators to whom you want
to grant the permission.
9.
Select a few administrators from the list, and click Select.
10.
Click OK to save the report.
11.
You have successfully customized an out-of-box report.
Bookmark
Place the cursor over this icon to load and view all
the screenshots for this tutorial. (Caution: Because this action loads all screenshots
simultaneously, response time may be slow depending on your Internet connection.)
