ManageEngine® SQLDBManager Plus Audit Monitoring | ||
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.
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.
- Login Activity: Displays all the successful and failed login.
- Login Password Change: Displays events related to login password changes.
- 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.
- 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.
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
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.
Cluster Details |
Alarms |