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. |
See Microsoft Windows: Entities supported for queries
See UNIX: Entities supported for queries
See Oracle: Entities supported for queries
See VMware: Entities supported for queries
Thanks for your feedback. Let us know if you have additional comments below. (requires login)