Wireless Office Headset User Manual

REPORTS > UNDERSTANDING REPORTS
EMBARCADERO TECHNOLOGIES > DSAUDITOR 4.5 USER GUIDE 15
Reports
Understanding Reports
For auditing requirements not met by the dashboard charts, you may create reports. These reports may include more
detailed data, and allow you to “drill down” from summary to detailed data, in some cases all the way down to the
individual query level. You may “publish” a report to share it with all other users, annotate reports with comments that
are visible to other users, and save reports in HTML, PDF, comma-delimited text, or rich text formats.
Reports have the following band-oriented structure:
The subreport body content is defined by setting the following subreport properties in a report template:
• Type: A subreport’s basic qualities are defined by selecting one of following nine types:
Column Summary, Query Summary, Table Summary, and Table Join Summary subreports provide summary
information on column accesses, query counts, table accesses, and join activity, respectively.
Dormant Column and Dormant Table subreports provide information on columns and tables which have not
been accessed in a certain amount of time. Dormant data is defined as a column or table which was used at one
time but has not been accessed in a certain number of days. Unused data is defined as a column or table which
has never been used. Both types of data can be shown on the same report.
NOTE: For the above summary and dormant subreports to be accurate, the STIReader, STIWriter, and
DBSummarizer server components must be configured and operating correctly. The following
reports do not depend on those server components.
Query Detail subreports can be used to show individual queries that meet specified selection criteria such as the
number of rows returned or execution time. Rejected queries can also be shown using this report.
Repetitive Query subreports show queries that have been duplicated more that a certain number of times.
Session Detail subreports shows one row of detail for each logical connection to the DBMS. Failed login
attempts can be displayed with this report.
NOTE: The Query Detail [verify], Repetitive Query, and Session Detail subreports can be configured to
show the full query text, the first line of the text, or no query text.
• Include Header Page / Include Signature Page: enables / disables optional header and signature
• Date Range: The range of dates to be included in the report. Preset date ranges are relative to the day the report
is run. Custom date ranges are static. For more information on preset date ranges, see Subreport Attribute Value
Descriptions
Report title
Report description
One or more subreports, each including: Subreport title
Optional header showing date range, grouping, sort, content, and filter settings
Body
Optional signature section (included only when exporting to PDF or RTF)