Product: LepideAuditor for SQL Server
Publisher: Lepide Software Pvt Ltd.
Price
Pricing is based on Per Server. Single server license fee is $ 499. Support and Upgrades are free as long as subscription is valid. They offer Educational, Government and Non-profit discounts.
Introduction
LepideAuditor is an auditing tool for Auditing in SQL Server. Though there are in built auditing options in SQL Server, this tool provides additional options for DBAs.
Installation & configuration
This tool has a simple installation. After installing you need to configure what are the SQL Server instances you are auditing. After setting those few objects will be created in the SQL Server Instance. Firstly, it will create a database name called LepideSQLTracker in the instance. Since this is taking the recovery model of model database, you need to create additional log backup options so that log of this database is not growing rapidly. If not, you need to change the recovery model of this database to Simple.
SQL Server Agent jobs will be added to the server to populate data to the SQLTracker database.
There are two types of configurations, Server and Database configurations.
However, database object configuration is for the all the databases hence you don’t have an option of setting configuration for separate databases.
However, vendor informed that this will be added to the next version of this tool.
Features
There three main features with LepideAuditor for SQL Server.
· Change Analysis
· Scheduled Reports
· Realtime Alerts
Change Analysis
Change analysis is the main feature of this tool. Users have the option of analyzing the changes server wise and the database as well.
So you will get the details of , what was the object changed and type of change, when it was changed, who changed from which application and the relevant t-sql statement.
There are limited filtering options such as Duration (Last 24 hrs, Last 7 Days, Last 15 Days, Last 30 Days and Date Range) , Object Type , Operation Type. User and application are the most important parameters missing for the filtering.
Also, there is an option to save the report in different formats such as CSV, HTML and PDF.
Scheduled Reports
Scheduled Reports are wizard driven so that users can configure them easily.
First you will be asked to select an operation from following list.
Depending on the selection whether it is server objects or database objects, user will be asked to select types of objects.
Then the scheduling can be done as shown below.
Though this does not have option you have in the SQL Server Agent scheduling, but this may be just enough.
In the reporting option you only have a mailing option. There is no option to create a report to a folder. Also, in the SMTP configuration you have to have a user name and password. However, there are two other SMTP options, anonymous and windows authentications are missing.
Real Time Alerts
Since reports are scheduled tasks, there is another feature where it delivers alerts as and when event occurs. It is similar to reports and you will get the all the pros and cons of reports in the real time alerts as well.
This is a major feature with this auditing tool, since most of the auditing tool only provides simple auditing.
Other Information
|
Web site |
|
|
Documentation |
|
|
Download |
|
|
Price |
Review Summary
|
Description |
Rating |
Comments |
|
Installation |
5 |
Simple and Standard installation |
|
Configuring |
3.5 |
No configuration available for each database wise |
|
Product Stability |
5 |
Had no issues |
|
Usability |
5 |
|
|
Feature Set |
4 |
Apart from the few configuration options (which vender confirms that those will be available in future versions) , most of the valuable features exists. |