Enterprise Reporter 3.5.2 - Report Library

Databases

SQL Database Objects

Shows all SQL database objects. Contains parameters to select the SQL servers, SQL instances, and SQL databases to be included in the report.

SQL Databases

Shows all SQL databases. Contains parameters to select the SQL servers, SQL instances, and SQL databases to be included in the report.

Jobs

SQL Server Job Information

Shows information for the jobs on the selected SQL servers. Contains parameters to select the SQL servers and database jobs to be included in the report.

Permissions

Account Permissions for SQL Database Objects

Shows the direct or indirect database object permissions for the selected accounts. Contains parameters to select the AD or SQL Login accounts, SQL servers, SQL instances, SQL databases, and object types to be included in the report.

SQL Database Object Permissions

Shows all SQL Server® database objects and their permissions. Contains parameters to select the SQL servers, SQL instances, SQL databases, object types, permission types, and object permissions to be included in the report.

SQL Database Schema Permissions

Shows all database schemas and their assigned permissions on the database. Contains parameters to select the SQL servers, SQL instances, SQL databases, schemas, owners, permission types, and schema permissions to be included in the report.

SQL Server Instance Permissions

Shows SQL Server instance permissions for the selected instances. Contains parameters to select the SQL servers and SQL instances to be included in the report.

Roles and Users

SQL Database Role Membership

Shows membership for each SQL Server role. Contains parameters to select the SQL servers, SQL instances, SQL databases, and SQL roles to be included in the report.

SQL Database Role Membership by Account

Shows all database roles of which the selected accounts are direct or indirect members. Contains parameters to select the AD or SQL Login accounts, SQL servers, SQL instances, and SQL databases to be included in the report.

SQL Database Users

Shows all SQL database users. If you choose to expand groups, membership of the groups is displayed. Contains parameters to select the SQL servers, SQL instances, SQL databases, and SQL database users to be included in the report. Contains a parameter to include nested group memberships and options on how they are displayed in the report. For more information, see the Expand Nested Groups Parameter topic in the Quest Enterprise Reporter Report Manager User Guide the Technical Documentation.

SQL Logins

Shows all SQL logins. Contains parameters to select the SQL servers, SQL instances, SQL login types, and SQL logins to be included in the report.

SQL Server Role Membership by Account

Shows all server roles of which the SQL Server® logins are direct or indirect members. Contains parameters to select the AD or SQL Login accounts, SQL servers, SQL instances, and SQL roles to be included in the report.