Reports
Configure email server settings and manage Operations Center reports.
- General Operations
- Summarizes storage environment status and recent activity, including the backup success rate and server availability.
- License Estimation
- Summarizes front-end and back-end capacity usage.
You can create custom reports, which provide targeted information about specific server or client metrics.
- To send email reports, the mail server must be configured to use open mail relay. Open mail relay allows email to be sent without authentication.
- Reports might not be shown correctly in email clients that convert HTML to another format. For example, text might be formatted incorrectly if HTML email is converted to Rich Text Format (RTF).
- + Report
- Create a custom report, which can include the following settings:
- Send to
- Enter one or more administrator IDs or email addresses. Use commas with no spaces to separate
list items. Each administrator ID must be registered on the hub server and must have an email
address specified.
You can specify an email address for an administrator ID by opening the command builder and changing the EMAILADDRESS parameter of the UPDATE ADMIN command.
- Operational Overview
- Instead of writing SQL SELECT statements, you can select one or more categories of information, such as storage utilization and client backup operations. Each category that you select is included as a separate section of the custom report.
- SQL Builder
- Enter a query name and a single SQL SELECT statement. The query name is shown as a section
header in the email report.
To add or remove a query, click the + and - icons.
For information about SQL queries, including sample queries that you can adapt for your own use, see SELECT (Perform an SQL query of the IBM Spectrum Protect database) in the IBM Spectrum Protect documentation and Custom Report Examples in the IBM Spectrum Protect wiki.
Tips:- The number of SQL queries in a report and the complexity of those queries determine how long the report takes to run. If reports are being sent later than expected, consider moving some queries to a separate report.
- To reduce the size of email reports, the number of query results might be limited. If this occurs, you can adjust the queries to return fewer results. For example, if you are querying all servers, create a separate query for each server.
- Ensure that the SQL queries you enter are valid for the version and operating system of the selected servers.
- Details
- View or change report settings, including the following setting:
- Send to
- Enter one or more administrator IDs or email addresses. Use commas with no spaces to separate
list items. Each administrator ID must be registered on the hub server and must have an email
address specified.
You can specify an email address for an administrator ID by opening the command builder and changing the EMAILADDRESS parameter of the UPDATE ADMIN command.
- Send
- Immediately run the selected report and send it to one or more recipients.
When you send a report manually, you can change the report recipients without affecting the default recipients of scheduled reports.
Use commas with no spaces to separate administrator IDs or email addresses. Each administrator ID must be registered on the hub server and must have an email address specified.
You can specify an email address for an administrator ID by opening the command builder and changing the EMAILADDRESS parameter of the UPDATE ADMIN command.
- Enable or Disable
- Prevent a report from being sent, either manually or by a schedule.Tip: To permanently remove a custom report, select the report and click Delete.
- Status
- Summarizes the completion status of the most recent report. The following error conditions can
be shown:
Failed: The report failed to run and was not sent.
Warning: The report was sent, but did not include data from one or more
servers. This can occur when a server is unavailable or when a SQL query is not valid for a server
version or operating system.