Report policies

A report policy runs reports on a group of databases and mails the results. Open Policies › Reports.

Before you begin

• Report policies need Manage Policies. The Report Catalog needs Manage reports.
• Mail uses Settings › Email. See Email and notifications.

Create a report

1. Under the list of policies, click New Report.

2. On Query, type a Name and a Description.

3. Write the Query. For values that the user gives, use :p1 to :p5.

4. Select a database and click Test Query. The repository cannot read DBA_ and V$ views.

5. Tick I confirm our Oracle licenses cover everything this query reads.

6. Click Add Report. Scops saves the report only if the test passes. The report opens in the Report Catalog.

• The query is one SELECT, or WITH … SELECT. Scops refuses PL/SQL and statements that change data.
• Scops refuses Diagnostics and Tuning Pack sources: DBA_HIST_ views, active session history, ADDM, the advisors and SQL Monitor.
• The monitoring account of each database must be able to read what the query reads.
• If you change only the schedule or the mail of a saved report, Scops does not test the query again.

To change a report, click Report Catalog under the list of policies. Click the report, then click its pencil.

Set when a report runs

Open the Schedule tab of the report.

A scheduled report runs only on the databases of the running policies that hold it. Times use the clock of the Scops server.

Mail a report

1. Save the report. Then open its Output tab.

2. Click Add Mail.

3. Type a Name and select the Recipients.

4. Select the Delivery: One Mail for All Databases or One Mail per Database.

5. Select the Databases, then click Save.

The mail follows the schedule. It shows the first 250 rows, and the Excel file has all rows. A run with no rows sends no mail. The send button of a mail runs the report now and sends it.

On Output you can also set the Categories, Draw a chart and Colours in the mail.

Add a report to a policy

1. Click the policy in the list.

2. Click Add Report and select the report. If the report is not in the list, click New Report beside the search box. Scops selects the new report.

The Runs column shows when the report runs. The Excluded cell sets the databases that the report skips. The bin removes the report from the policy, but not from the catalog.

Create a report policy

1. Click New Policy.

2. Type a Name and click Create Policy.

3. Click its database count and select the databases. Click Save.

A new report policy has no reports. A database that you add leaves its old report policy.

Stop, rename or delete a policy

• Running switch: a stopped policy keeps its databases but runs no reports.
• Pencil: rename the policy.
• Bin: delete the policy. Its databases then have no report policy.

Delete a report

In the Report Catalog, click the report, then click its bin. The report leaves all policies. Scops deletes its mails and its kept results.

Manage categories

At the bottom of the Report Catalog, + adds a category and × deletes one. The Reports page lists the reports by category.

Weekly performance report

One mail for each database every week: its health, a Scops AI summary and eight daily charts. The settings are one set for all policies.

1. Click the calendar button above the list, Weekly report settings.

2. Turn on Send the weekly report.

3. Set the fields in the table below.

4. Click Save.

What the mail holds

The report sends no query to the database. It uses the data that Scops collected.

Related

Updated October 30, 2026