SQL Server Reports Quick Reference Guide

The following SQL Server reports are available for selections within the Resources pane.

SQL Server Node Report

The following report is available at the SQL Server node level:

Report	Description
Sensitive Content Summary Report	Provides a count of tables where criteria matches were found in the targeted environment. This report includes a Details table.

The following reports are available at the instance level:

Report	Description
Activity Report	Displays activity across the entire instance logged during the selected date range.
Sensitive Content Details Report	Provides details of tables where criteria matches were found on the selected instance. This report includes a table with criteria matches visible to Access Information Center users with either Security Team Member or Administrator roles. The Matches table requires the storage of discovered sensitive data within the Access Analyzer database or it will be blank.
Sensitive Content Summary Report	Provides a count of tables where criteria matches were found on the selected instance. This report includes a Details table.

The following reports are available at the Databases node level:

Report	Description
Activity Report	Displays activity across the databases logged during the selected date range.
Sensitive Content Report	Provides a list of tables and a hit count per table where criteria matches were found on the selected resource. This report includes a table with criteria matches visible to Access Information Center users with either Security Team Member or Administrator roles. The Matches table requires the storage of discovered sensitive data within the Access Analyzer database or it will be blank.

The following reports are available at the database and table levels:

Report	Description
Activity Report	Displays activity across the databases logged during the selected date range.
Permissions Report	Shows the permissions for the trustee on the selected resource.
Sensitive Content Report	Provides a list of paths and a hit count per table where criteria matches were found on the selected resource. This report includes a table with criteria matches visible to Access Information Center users with either Security Team Member or Administrator roles. The Matches table requires the storage of discovered sensitive data within the Access Analyzer database or it will be blank.

The following report is available at the Permissions node level:

Report	Description
Permissions Report	Shows the permissions for the trustee on the instance.

The following report is available at the Roles node level:

Report	Description
Permissions Report	Shows the permissions for the instance’s SQL roles.