Click the Reports tab.

On the Reports Definition page, click the Availability History (Target) report link under the Monitoring category and Availability History subcategory.

Click the flashlight icon to select a target.

You are prompted for a target. Select your Windows host and click the Select button.

Note: This reports should be used for non-composite targets. If you want to see availability for a Group or a System, view the Availability History (Group) report. To see the availability history for a Redundancy Group, view the Availability History (Redundancy Group) report.

Click the Continue button.

Change the time period to Last 7 days and click the Continue button.

The data in the report will change accordingly (i.e. displaying information for the Last 7 days). Click the Reports tab to return to the Reports Definition page.

Now, lets view additional out-of-box reports in the Reports Definition page. Click the Database Instance Overview report link, under Deployment and Configuration category, and Oracle Database Configuration sub-category.

Click the flashlight icon to select a database instance to include in this report.

Note that this report provides information about an Oracle Database. Therefore, the user is only allowed to input an Oracle Database as a parameter for this report. Select the database instance assigned to you and click the Select button.

Click the Continue button

View the Database Instance Overview report.

On the Reports Definition page, select the Availability History (Target) report under the Monitoring category and Availability History subcategory. Click the Create Like button.

Specify a title for your report, such as "Availability History and Outstanding Alert for my DB"

You can use one of the existing categories or you can also create your own. Click the Add Category button to create a new category.

You can specify any name for the category, for example My Reports. Click the Continue button.

You can use one of the existing subcategories or you can also create your own. Click the Add Subcategory button to create a new subcategory.

Enter the name for the subcategory, for example Database Reports and click the Continue button.

Since you are defining this report for a specific database, select the Use the specified target option button in the Targets section, and click the flashlight icon to select the database you would like to use.

Choose Database Instance from the Target Type drop-down list. Select a database instance and click the Select button.

In the privileges section, select Run this report with privileges of report owner checkbox. This way you can schedule your report, as well as share it with users who do not have view privileges on your database.

Click the Elements property page.

Click the Add button to add the open alerts element.

Select the Open Alerts element and click the Continue button.

Click the Set Parameters icon for the Open Alerts element.

Specify the header for the element, for example Open Alerts. Since you are writing the report for a specific target, select the Inherit Target option. Select severities of alerts that you would like to include in the report. For example, select Critical and Warning. Keep the default 10 rows per page setting. Click the Continue button.

Click the Preview button to review the changes you made to the report.

Notice, that you are no longer prompted for a target, since you specified the target to use for this report. The report shows the data we wanted, however we can improve on its layout by moving the Open Alerts element to the right of the Availability History Details table. Scroll down the page, and click the Return to Create Report Definition link.

Click the Layout button.

Select the Open Alerts element, and click the Move Up button to move it to the 3rd row.

Notice that the Open Alerts element has now moved to the 3rd row. Click the Continue button.

Click the Preview button again to validate that the report layout has been changed.

Notice the change in the report layout. Scroll down the page, and click the Return to Create Report Definition link.

Click the OK button to save the report.

On the Report Definitions page, scroll down and select the report you just created and click the Edit button. The report is listed under the category and subcategory that you specified.

Click the Schedule property page.

Check the Schedule Report checkbox.

You can schedule the report to run one time immediately, one time later or on a repeating schedule. For the purposes of this exercise, you will generate one copy of the report immediately, save a copy of the report, and email the report to yourself. In order to achieve this:

• Retain the default One Time (Immediately) setting.
• Select the checkbox to Save a copy of report each time the scheduled report completes.
• Email report to yourself, by specifying your email address in the To field.

Click the Access property page.

Now, you would like to share the report with the "Reporting" user and publish this report to the Enterprise Manager reports Website. Click the Add button.

Select Reporting administrator as one of the users who can access your report and click the Select button.

Check Allow viewing without logging into Enterprise Manager checkbox. Checking this option allows you to share your reports with non-Enterprise Manager administrators. Click the OK button to save your report.

Notice the confirmation message - Successfully Modified Report: "Availability History and Outstanding Alert for my DB". It might take up to a couple of minutes for your report to get generated. Once a copy has been generated, a timestamp will appear in the Date Generated column for your report. Periodically click the Refresh icon at the top of Report Definitions page to check if a copy has been generated.

Logout of the Grid Control Console.

Navigate to http://<management service hostname>.<domain>/em/public/reports and verify that the report has been published to the reports Website.

Now verify that the reporting user has access to this report. Login as: Username: reporting and Password: reporting.

Navigate to the Reports tab and you will notice that reporting user has access to your report. Click on the report, and you can view the same report.

Click the Reports tab.

On the Report Definitions page, click the Create button to launch the report creation wizard.

Here you can specify any name for the report and use any existing categories and subcategories. For this exercise, specify the name as Host Report, category as My Reports, and subcategory as Host Report.

Since this report will require a user input, use the default A target will be selected by the report viewer when viewing the report option. Additionally, select Host in the Target Type drop-down. This will restrict user input to hosts.

In the Time Period section, allow the report viewer to customize the time period.

Now you need to add content to the report by adding reporting elements. For creating this report, you will use "Metric Details" and "Table from SQL" reporting elements. "Metric Details" element allows you to graph a metric over a period of time, and "Table from SQL" element allows you to write custom queries against the Management Views to the Grid Control Repository. Click the Elements property page.

Select the Metric Details element and click the Continue button.

Click the Set Parameters icon.

Specify a header for this element for example Selected Host CPU Utilization.

• Select the Inherit report time period option button, since we want this element to show information for the time period specified by the user
• Select the Inherit Targets option button, since this element will show information about the user-supplied host.
  

Select CPU Utilization (%): Load from the metric list, and click the Continue button.

Now, let's add an element that will show CPU Utilization for the baseline host. Click the Add button to add another Metric Details element.

Select the Metric Details element and click the Continue button.

Click the Set Parameters icon.

Specify the header, for example Baseline Host CPU Utilization. Select the Inherit report time-period option button as this element should show information over a user-specified time period

In the Targets section, select Use element-specific targets below option button, since this element will display information for the baseline host, you need to supply the baseline host.

Click the Add button, and select the host assigned you to be used as a baseline.

Select Host from the Target Type drop-down list. Select the host assigned to you and click the Select button.

Select CPU Utilization (%): Load in the metric list, and click the Continue button.

Repeat the previous steps, by adding 2 Metric Details elements, one for the user-selected host, and one for the baseline host, showing Filesystem Space Available (%): Filesystems metric.

Now, you need to add the alert history information for the two hosts. You will accomplish this using the Table from SQL element. Click the Add button to add Table from SQL element.

Select Table from SQL and click the Continue button.

Click the Set Parameters icon.

Enter a header, for example Alert History for a User-supplied Host. Write a SQL statement to select all warning and critical alerts that were triggered for the user-supplied host during the specified time-period, providing information about: metric that triggered the alert, alert severity, and date the alert was triggered. Refer to the SQL Cheat Sheet Handout for documentation on mgmt$alert_history view, and a list of variables to use in your SQL.

Answer:

select column_label as "Metric", alert_state as "Severity", collection_timestamp as "Date Triggered" from mgmt$alert_history where target_guid=??EMIP_BIND_TARGET_GUID?? and collection_timestamp>=??EMIP_BIND_START_DATE?? and collection_timestamp<=??EMIP_BIND_END_DATE?? and alert_state in ('Critical','Warning')

Click the Continue button.

Now, let's add another table that will include information about alert history for the baseline host. Click the Add button to add another Table from SQL element.

Select Table from SQL element and click the Continue button.

Click the Set Parameters icon.

Specify the header, for example Alert History for the baseline host. Write a SQL statement that will select all alerts triggered for the baseline host over the specified time-period.

Answer:

select column_label as "Metric", alert_state as "Severity", collection_timestamp as "Date Triggered" from mgmt$alert_history where target_name='stams03' and collection_timestamp>=??EMIP_BIND_START_DATE?? and collection_timestamp<=??EMIP_BIND_END_DATE?? and alert_state in ('Critical','Warning')

Please substitute the target_name with the hostname assigned to you.

Click the Continue button.

Click the Preview button.

Click the flashlight icon to select a host to include in the report.

Select the type as Host and select any host from the list. Click the Select button.

Click the Continue button.

Review the information presented in the report. While all of the information is correct, you notice that all the elements are laid out in one column. However, it would be better to compare data in two columns.

Click the Return to Create Report Definition link at the bottom left corner of the page.

Under the Elements subtab, click the Layout button.

Move the first two charts into the 1st row, next 2 charts into the 2nd row, and the alert tables into the 3rd row. Click the Continue button.

Click the Preview button to view the report.

Click the flashlight icon to select a host to include in the report.

Select the type as Host and select any host from the list. Click the Select button.

Click the Continue button.

Validate that the elements are shown side-by-side.

Click the Return to Create Report Definition link at the bottom left corner of the page.

Click the OK button to save the report.