On the Security assessment reports page, you can view the list of available security assessment reports for all target databases within the compartments that you have selected and where you have the required privileges. You can Generate reports, Download reports, and complete More actions within this page.

1. Under Security center, click Security assessment.
2. Under Related resources, click Assessment reports.
3. (Optional) Narrow the scope of the reports by using List scope.
   1. Select a compartment you have access to from the Compartment list.
   2. Select or deselect Include child compartments. If you select the root compartment and allow the default Include child compartments, then child compartments where you have required privileges are included.
4. View the list of available security assessment reports in the table.

   The table includes two tabs: Oracle predefined reports and Custom reports. Within the Oracle predefined reports tab, the table includes the Report name and Description.

5. Click All risks (detailed) to view all risks for target databases in the specified compartment.
6. Within the Overview tab, click + Add Filter to apply optional filters to limit the scope.
7. Click Manage Columns to manage the columns within the Risks by Targets table.
8. Click a specific risk to see the details of the risk in the selected target database.
9. (Optional) Click Generate report. The report is generated and saved to the specified compartment. When the report is finished generating, do one of the following:
   • In the Generate Report dialog box, click the click here link. A dialog box is displayed where you can specify whether you want to open or save the file.
   • Click Close to close the Generate Report dialog box, and then click Download Report. A dialog box is displayed where you can specify whether you want to open or save the file.
10. (Optional) Click Create custom report.
    • In the Create custom report dialog box, enter a display name for the report.
    • (Optional) Enter a report description.
    • Select a compartment in which to store your report.
    • Click Create custom report.
11. (Optional) Click Manage report schedule.

    The Manage report schedule panel is displayed, pre-loaded with either the default or modified schedule.

    1. (Optional) In the Schedule report name box, enter a report name.
    2. Select a compartment to store the reports generated by the schedule.
    3. For Report format, select PDF as the output.
    4. Select a Schedule frequency.
       • If you select weekly, select the day of the week in the Every field.
       • If you select monthly, select the day of the month in the Day field.
    5. In Time (in UTC), select a schedule time
    6. Click Save schedule
12. Click Show Advanced SCIM Query Builder.
    1. Use the provided filter builder and dropdowns to type in your filter(s). Advanced filtering uses System for Cross-Domain Identity Management (SCIM) syntax and supported operators include:
       • co: matches resources with an attribute that contains a given string
       • eq: matches resources with an attribute that is equal to a given value (not case sensitive)
       • eq_cs: matches resources with an attribute that is equal to a given value (case sensitive)
       • ew: matches resources with an attribute that ends with a given string
       • ge: matches resources with an attribute that is greater than or equal to a given value
       • gt: matches resources with an attribute that is greater than a given value
       • in: matches resources with an attribute that is equal to any of given values in list
       • le: matches resources with an attribute that is less than or equal to a given value
       • lt: matches resources with an attribute that is less than a given value
       • ne: matches resources with an attribute that is not equal to a given value
       • not_in : matches resources with an attribute that is not equal to any of given values in list
       • pr: matches resources with an attribute if it has a given value
       • sw: matches resources with an attribute that starts with a given string

       Operators can be grouped using parentheses to specify the order.

       Filters can also be combined using logical operators such as and and or.

       Note:

       If you have any basic filters currently applied they will appear in the query builder as well.
    2. Click Apply.