Microsoft SQL Server: Entities supported for queries

HOWTO107186

Last Updated November 28, 2014

Microsoft SQL Server: Entities supported for queries

Control Compliance Suite supports queries on Microsoft SQL Server.

Table: Entities supported on Microsoft SQL Server tabulates the entities that Control Compliance Suite supports for queries on Microsoft SQL Server.

Table: Entities supported on Microsoft SQL Server

Entity name	Entity description
Database Backups	This entity reports on the backups that are made for databases.
Database Permissions	This entity reports on the SQL Server objects permissions.
Database Role Permissions	This entity reports on all permissions that a Role can have on different types of database objects.
Database Users	This entity reports on the users who are defined for databases.
Databases	This entity reports on SQL Server databases.
Job Server	This entity reports on the job server on the SQL server.
Server Integrated Security	This entity reports on the integrated standard security of servers.
Server Logins	This entity reports on the logins of the SQL Server.
Server Roles	This entity reports on the server roles of the SQL Server.
Database Audit Specifications	This entity reports on Database-level Audit Specification configuration details of the SQL Server 2008. This entity is applicable to SQL Server 2008 Enterprise Edition only.
Servers	This entity reports on instances of the SQL Server.
Stored Procedures	This entity reports on stored, compiled Transact-SQL scripts.
Configuration	This entity reports on the configuration values for instances of the SQL Server.
Server Audit Specifications	This entity reports on Server-level Audit Specification configuration details of SQL Server 2008. This entity is applicable to SQL Server 2008 Enterprise Edition only.
Server Audits	This entity reports on Server Audits configuration details of SQL Server 2008. This entity is applicable to SQL Server 2008 Enterprise Edition only.
Database Roles	This entity reports on SQL Server database roles.
Remote Servers	This entity reports on the remote servers visible to instances of SQL Server.
Job Steps	This entity reports on the job steps for the jobs that are defined for job servers.
Linked Servers	This entity reports on the datastores made available for querying by means of OLE DB.