Content & Layout

Content & Layout
The content of the report is the most important feature of a report. And while layout & organization are less critical, they can often prove important when consuming the reports or presenting them to others.
Core Audit was designed to give a wide range of content, organization, and layout controls, while keeping it simple for most of not all use-cases.

Content

Core Audit Reports have several parameters that control the content of the reports:
  • Filters – reports have filters based on the type of report. Filters control what information is included in the report. When report schedules are set to alerts, the filters also control when alerts are sent
  • Columns – every report has a list of columns to display. The columns available are based on the report type. Columns can be used to group the information (see below)
  • Databases – reports are assigned databases. This assignment controls the databases that are included in the report
  • Anomaly Parameters – anomaly reports have additional parameters that define the anomaly search

Organization

Any Core Audit report (or alert) can be organized in one of these basic modes:
  • Summary – a summary report is a report that has grouping columns but no detail columns. Such a report will usually show counts and graphs. An example of such a report is the User Logon report that groups by Username, or the Logon per Hour report that groups by Hour.
  • Grouped – a grouped report is a report that has both grouping columns and detail columns. Such reports can, for example, show details for summary reports. Examples are the Logon Detail by User report that is grouped by username, or the DBA DML activity report that is grouped by session.
  • List – a list report contains only detail columns and no grouping. These reports are less common in the built-in reports as grouping tend to make reports more readable. An example of such a report is the Security New Programs report that shows programs that haven’t been seen in the database recently.

Layout

Reports can generated in several file formats. When using the default HTML file format, layouts allow for different graphical representation of the information (such as colors, spacing etc). Layouts are controlled by the HTML Format report parameter.
You can create your own layouts, but Core Audit ships with three layouts that can be applied to any report:
  • Default – the default layout contains collapsible database nodes and groups. This layout is the most useful
  • Tab – tabbed layout. In some cases, it is useful to layout reports so that each database is in a separate tab
  • NoJava – the nojava layout is similar to the default layout but does not use Javascript. It, therefore, lacks the collapsible elements in the default format