ManageEngine® SQLDBManager Plus


Audit Monitoring

<< Prev

Home

Next >>

 

SQL Server Audit Reports

SQLDBManager Plus reports the server-level and database-level audit events helping your organization stay compliant to the security standards. It keeps track of all the audit events that have been written to a file location on your computer for your instance of SQL Server, provided you have enabled auditing in the product.

 

SQLDBManager Plus displays several audit activities in an organized table format based on various categories that can be further filtered and sorted to drill down to exact data you are looking for. This helps you in having your data archived, formatted and be ready for audits to ensure the security of consumer data.

 

Monitored Parameters

Following are the various parameters that are monitored in SQLDBManager Plus for Audit Reports:

 

Parameters

Description

Event Time

The time at which the audit event occurred in the SQL Server instance.

Audit Type

The audit event that is being monitored.

User Name

Current user login when the auditable action occurred.

Server Name

Name of the server instance where the audit occurred.

Database Name

Name of the database where the audit occurred.

Description

Transact SQL statement giving a detailed explanation of the auditable action.

The SQL server audit events in SQLDBManager Plus are categorized under four different heads.

  1. Login: This category enlists the various login actions.

    - Login Activity: Displays all the successful and failed login.

    - Login Password Change: Displays events related to login password changes.


  2. Server: This category enlists the various server-level actions.

    - Server Object Change: This event is raised when a server object is created, altered, or dropped.

    - Server Object Permission Change: This event is raised when a grant, revoke or deny permission is issued for a server object.

    - Audit Server Operations: Displays events related to security audit operations such as altering settings, resources, external access, or authorization are used.


  3. Database: This category enlists the various database-level actions.

    - Database Logout: This section displays all the events raised when a database user logs out of a database.

    - Database Changes: Displays all the events related to a database change such as when a database was created, altered, or dropped.


  4. Audit:This category enlists the various events that is raised on any change to an audit, that includes creation, modification, or deletion of audit specifications.

  5. Note: The above said categories are pre-defined. You can add more to this list as per your requirement, by contacting our technical experts at sqldbmanagerplus-support@manageengine.com

 

 

Reporting

SQLDBManager Plus allows you to generate a wide variety of reports thus providing a better insight into what is going on in the audited infrastructure and help you ensure that you meet compliance requirements. We store your data into our database for a span of an year.

 

There are options for audit reports to be Emailed and also to be exported as PDF and CSV files. These options are available as icons at the right top corner.

 


<< Prev

Home

Next >>

Cluster Details

Alarms