| Oracle Mission Critical Support Platform User's Guide, Release 2.3 Part Number E23198-01 |
|
|
PDF · Mobi · ePub |
| Oracle Mission Critical Support Platform User's Guide, Release 2.3 Part Number E23198-01 |
|
|
PDF · Mobi · ePub |
This chapter covers the following topic areas:
The Oracle Mission Critical Support Portal Report List displays all the reports and queries that have been defined in the system for a specific customer. The name of the creator of each report and query is also displayed. These reports and queries contain user-defined data and formatting that can help you focus on specific aspects of your organization's application and infrastructure resource performance. Once saved, the reports and queries are available for viewing by all system users with appropriate permissions.
From the Report List dashboard, you can select to view the report or query for a particular time range. You can generate, edit (if such permissions are granted), delete, and subscribe to different report types. In addition, the Reporting service enables creating reports based on queries that extract data from the Reporting database. You can create, view or delete queries that have been defined for a specific customer such as an availability summary, change ticket summary, incident ticket summary, or organization summary query.
You view reports and queries in any spreadsheet program capable of reading CSV format (Comma Separated Values) files as well as viewing reports online through Oracle Mission Critical Support Portal.
The Availability Reporting function collects and analyzes data from the event logs of monitored servers and then generates configurable reports that users can view and customize to suit the needs of their organization. Users can use these reports to identify the causes for planned and unplanned downtime and take preemptive actions to decrease downtime in the future.
Availability reports calculate the metrics of server availability and a standard report is configured to display the resulting data. Each configuration includes tables or graphs with information about the availability and reliability of servers, devices, and services in the monitored environment. Users can enter parameters, such as specific periods of time, to filter the data presented.
Availability reports provide the following advantages:
Determine whether monitored servers are meeting their availability and reliability objectives.
Filter reports to track trends by viewing information collected over a specific length of time, such as over a period of months or years.
Filter reports to view information on a specific subset of monitored servers.
Identify the best and worst performing computers for a particular area. For example, you can identify which servers suffer the most or least number of system failures.
Identify problem areas, such as a particular application or operating system version that stops responding.
Gather information about operating systems and applications.
To generate an Availability Report:
Log in to Oracle Mission Critical Support Portal.
The Dashboard page appears.
From the Reports menu, select Availability Reports.
The Availability Reports page appears.
From the Configuration Item list, select the Configuration Item (CI) whose data you want to use to create the report.
From the Probe list, select the probe that you want to report upon.
In the Start/End Time fields, specify the date and time over which you want the report data to cover.
From the Interval list, specify how often you want to create the report.
Click GENERATE to create the report using the parameters you specified in the steps above.
Oracle Mission Critical Support Portal generates an availability report similar to the one shown below.
Use this procedure to generate an event report from selected event criteria. The event report contains critical information about the event such as the target CI that caused the event, error message, time of event and so on. Event reports provide visibility into service-level activity across your network. Event Reports require user input and can be generated in several formats such as Excel and CSV.
To generate an Event Report:
Log in to Oracle Mission Critical Support Portal.
The Dashboard page appears.
From the Reports menu, select Event Reports.
The Event Reporting page appears.
On the Event Reporting page, decide whether you want to search events by Incident Ticket Number or Event Attributes.
If searching by ticket number, enter the number of the Incident Ticket for which you want to search for associated events.
If searching by attributes, enter the appropriate search criteria from the available fields; then click SEARCH.
Note:
The processing time for any search will vary depending on the size of the data file being searched. To decrease processing time, narrow the search by using multiple search fields.The Event Reports page displays all events that are associated with the search criteria you entered. The page displays the following fields for each event:
Hostname
Identifies the target CI from where the event originated
First/Last Occurrence
Indicates the time stamp of when the event first and last occurred
Cleared
Indicates he time stamp of when the event was cleared
Tally
Indicates the number of occurrences for the event.
Severity
Indicates severity of event. Severity 0: Clear, Severity 1: Indeterminate, Severity 2: Warning, Severity 3: Minor, Severity 4: Major, Severity 5: Critical.
Ticket ID
Identifies the unique ID assigned to each event ticketed as an Incident
Summary
The summary text for the Event Log entry
You can click the + (plus) sign for additional details on the reported event.
Repeat the steps as required to generate another event report.
Use this procedure to make local reports available to your users. The External Reports page provides a local URL instance of the report.
To create an external report:
Log in to Oracle Mission Critical Support Portal.
The Dashboard page appears.
From the Reports menu, select External Reports.
The External Report List page appears.
Click Add External Report.
The Add External Report area appears on the page.
In the Title box, enter the title name of the external report.
In the URL box, enter the full URL of the report.
In the Description box, enter a brief description of the external report.
Click SAVE.
Use this procedure to view a query. A query can consist of data items from the Incident, Change, CMS, and Monitoring service applications. You can execute a query from the View Query page for your company within a specific data and time range.
To view a query:
Log in to Oracle Mission Critical Support Portal.
From the Reports menu, select Reports.
The Report List dashboard page appears.
From the Queries table, locate the query you want to view, then click the Query Name.
The View Query - Query_Name page appears.
On the View Query page, you can choose to run a query. Do the following:
In the Begin Time box, click the calendar icon, then select the begin date and time range. Click Apply to apply your selection.
In the End Time box, click the calendar icon, then select the end date and time range. Click Apply to apply your selection.
From the Can group fields list, select the fields that you want to group, then click Add.
From the Fields setting table, you can do the following:
Select Hide this field if you want to omit a specific field from the report
From the Subtotal function list, select the aggregation value to display as a subtotal within the report for the specific field, such as number of rows (COUNT ROW) or number of unique values within a column (COUNT UNIQUE VALUE.)
From the Render as list, select a format to display the report:
| Display Format | Settings |
|---|---|
| Default | None |
| Table | None |
| Pie |
|
| Area |
|
| Time Series |
|
| Line |
|
| Bar |
|
Click EXECUTE QUERY.
Oracle Mission Critical Support Portal generates the query for your company and date or time window you selected and displays the data in the Query Results area.
Click Download CSV to download all query results or you can choose to download only an individual result. You can export the results to any common spreadsheet program that supports comma-separated value (CSV) files.
Use this procedure to view a report. A report can consist of query components from the Incident, Change, Configuration Management System (CMS), and Monitoring service applications. You can generate a report from the View Report page for your company within a specific data and time range.
To view a report:
Log in to Oracle Mission Critical Support Portal
The Dashboard page appears.
From the Reports menu, select Reports.
The Reports List page appears.
Locate the report you want to view, then click the Report Name.
The View Report page appears.
You can choose to generate a report within a particular date and time range. Do the following:
In the Begin Time field, click the calendar icon; then select the begin date and time range. Click Apply to apply your selection to the Begin Time field.
In the End Time field, click the calendar icon; then select the End date and time range. Click Apply to apply your selection to the End Time field.
Click EXECUTE REPORT.
The system generates the report for the customer organization and date/time window you selected and displays the data in the Report Results area.
Click Download CSV to download all report results or you can download only an individual result. You can export the results to any common spreadsheet program that supports comma-separated value (CSV) files.
When you create a subscription, you instruct Oracle Mission Critical Support Portal to e-mail, on a periodic basis, certain types of user reports to recipients defined in a subscriber list.
You configure scheduled reports by defining which type of report to send, the frequency with which the report is sent, and to whom the report is sent. You can schedule reports to be sent to one or more recipients.
To create a report subscription:
Log in to Oracle Mission Critical Support Portal.
The Dashboard page appears.
From the Reports menu, select Create Subscription.
The Create Subscription page appears.
In the Subscription Title box, enter a name for the report subscription, for example, "Jim's daily update of CMS inventory."
From the Report list, select the report you want to schedule to be delivered to a subscriber list.
From the Schedule Type list, select a schedule for the report. You can choose from any of the following options (you must choose at least one):
To send a report on a daily basis, select Daily report (you must select the time of day at which the report should be sent).
To send a report on a weekly basis, select Weekly (you must select the day of the week on which the report should be sent).
To send a report on a monthly basis, select Monthly (you must select the day of the month on which the report should be sent.
From the Deliver At list (filtered from your Schedule Type selection), select either the time of day, the day of the week, or the day of the month on which the report should be sent.
From the Time Zone list, select the time zone region associated with sending the report.
From the Date Format list, select the date format associated with sending the report.
From the Time Format list, select the time format associated with sending the report.
From the Email Format list, select the format in which to send the report.
From the Subscribers area, select the report recipients by selecting the appropriate subscriber e-mail list.
Click SUBSCRIBE
Oracle Mission Critical Support Portal creates the subscription and schedules the report to be delivered to the selected subscribers.
Use this procedure to view a summary overview of all subscriptions belonging to your company. You can apply filters to display certain subscription information by subscriber list and report list.
From the Subscription Summary page, you can also choose to edit or delete a subscription.
Note:
When editing a subscription, you cannot change the report type.To view the Subscription summary:
Log in to Oracle Mission Critical Support Portal.
The Dashboard page appears.
From the Reports menu, select Subscription Summary.
The Subscription Summary page with a list of subscriptions appears.
In the Filter section, from the Subscriber and Report list, select filter information as appropriate, then click FILTER.
The filter results appear in the Summary section.
|
 Copyright © 2010, 2011, Oracle and/or its affiliates. All rights reserved. Legal Notices |
|
