You'll receive

A bi-weekly newsletter

Exclusive discounts

Product update alerts

 
Audit all SQL database and security activities
Meet compliance requirements e.g. HIPAA, PCI
Out-of-the-box and custom Win and Web based reporting
Securely store audit data in a tamper-evidentrepository
Fully customize all auditing, alerts, and reporting
Who, what, where, and when type auditing

Features

SQL Server activity auditing

Audit all operations performed on your SQL instances including DML and DDL changes, SELECT statements as well as login, user, and permission related activities

See next feature

Statement auditing

View any SQL statement that was executed

See next feature

Who, what, from where, and when auditing

Find out the name of the login, computer, and application used as well as the time when the activity occurred

See next feature

Login auditing

Review failed login attempts

See next feature

Security change auditing

Investigate permission, SQL login, user, password, and role changes

See next feature

Tamper-proof design

Determine if and when anyone attempted to tamper with the captured auditing data

See next feature

Exports

PDF, Word, Excel and CSV formats supported

See next feature

Alerts

Get notified of data and system events on specified SQL Server instances, from email notifications and the alert history dashboard

See next feature

Manage alerts

Easily manage alerting configuration – create, edit or remove alerts

See next feature

User friendly alert wizard

Create or edit alerts with ease using an intuitive wizard with powerful features

See next feature

Built in custom reports

Filter data by using a powerful expression editor. Choose audited data columns such as server name, query text, login, etc. to include in a custom report and save a report template for later use

See next feature

Out-of-the-box reports

Quickly review captured information leveraging 10+ easy to use built-in reports

See next feature

Web reports

In addition to the built in Win client reports, access common reports via a web-based interface without having to set up or use SQL Server Reporting Services

See next feature

Custom web reports

Define custom reports via a web-based interface

See next feature

Custom alerts

Schedule execution of any SQL script to gather information like database size, amount of assigned memory, stored procedures results etc. and be alerted if the value is above some threshold

See next feature

Advanced filter

Set up a powerful expression editor to filter audited data, reports results, and alert conditions

See next feature

Roadmap

Common reports

Find out everything that's happening on your SQL Server instances including data and object access and changes, failed logins, and security changes

Simple filter

Find out the exact SQL statements that have been executed on your SQL Server instances including SELECTs

Basic system status

Find out exactly when and how an accident occurred, as well as details on who was involved

See our entire roadmap

What's next for ApexSQL Audit: ApexSQL Audit 2015 R2 – maintenance version


ApexSQL Audit 2015 R1 released ApexSQL Audit 2015 R3 Q2 ApexSQL Audit 2015 R4 Q3 ApexSQL Audit 2015 R5 Q4
Reporting
Common reports
Custom reports in GUI
Statistical reports
Before-After reports
Multiple simultaneous data sources
Reports on accessed columns
Auditing
Simple filter
Filter by database name
Filter by object name
Filter by operation
Filter by login
Filter by application name
Choose table columns (sensitive columns)
Before-After auditing
Advanced Filter
Filter by login
Filter by application name
Filter by operation
Filter by time
Filter by object name
Filter by object type
Filter by operation category
Filter by operation subcategory
Filter by database name
Filter by server name
Filter by transaction ID
Filter by schema name
Matching operators: like, not like, greater than and less than (in simple filter each value can be turned on or off, meaning that it is only equal or not equal matching operator)
The 'starts with' and 'ends with' operators
The 'is Null' and 'is not NULL' operators
Before-After auditing
Include/Exclude query text
Configuration templates
Statistics & Status
Basic system status
Advanced system status
Detailed info about each auditing instance
Detailed info about central instance
Aggregate preview on collected data per system and per instance
Graphical preview on collected data per system and per instance
Health information - diagnostic window, allows detecting system wide issues and suggest possible solutions
Archiving & Purging
Archive complete central repository database
Choose to archive from specific time: last week, last month, last year or just by specific date
Purge data from specific time range
Remove or backup database on uninstall
Data integrity
Check data integrity on CRD (tampering detection)
Check data integrity on archived databases
Option to ignore specific detected tampering
CLI
CLI for archiving
CLI for data integrity
CLI for exporting report
CLI for starting/stopping auditing instances
Alerting
Server management
Data alerts
Predefined alert types (DML, DDL…) with simple filters
Advanced alert filters
Sensitive columns alerts
Before-after data alerts
Alerts on historical data (aggregated alerts)
Predefined threshold (1 per minute)
Custom threshold
Predefined system alerts
Custom check interval
Alert on low disk space
Alert on ApexSQL Audit data tampering
Alert if central repository database grows too large
Alert if auditing instance is unreachable
Custom SQL script alerts
Alerting options
Alert reports date filter
Alert reports severity filter
Alert report template editor helper
E-mail recipient list
Alert rule preview
Alert rule changed by
Log alert management changes
Import/export alert rules
Alert actions
GUI notification
E-mail notification
Action templates
ApexSQL Audit log entry
Windows event log entry
SIEM/SOC syslog entry
SNMP trap notification
Execute external application
Execute SQL script
Archive central repository database
General
Failover cluster support
Always on cluster support
ApexSQL Audit 2015 R1 released ApexSQL Audit 2015 R3 Q2 ApexSQL Audit 2015 R4 Q3 ApexSQL Audit 2015 R5 Q4

Content

SQL Solution Center articles

Auditing SELECT statements on SQL Server

Track SQL Server database security changes

SQL Server database auditing techniques

SQL Server database security and compliance

HIPAA Compliance for SQL Server DBAs

SQL Server auditing – how to get notified about an event

Security and compliance in SQL Server

Tracking SQL Server object usage

Auditing security changes in SQL Server

How to meet requirements of HIPAA compliance as a part of a SQL Server audit

Meet SQL Server auditing requirements of Sarbanes-Oxley (SOX)

Meeting PCI compliance requirements with SQL Server

Meet GLBA compliance requirements for SQL Server

SOX survival kit for the SQL Server DBA

SQL Server auditing and compliance for FERPA

Audit failed SQL Server logins – Part 1 – distributed queries, brute force attacks, and SQL injections

Audit failed SQL Server logins – Part 2 – using native tools to investigate failed logins

Audit failed SQL Server logins – Part 3 – the solution

How to audit SQL Server to comply with Basel II

Methods for auditing SQL Server data changes – Part 1 – Change tracking

Methods for auditing SQL Server data changes – Part 2 – reading the Change Tracking results

Methods for auditing SQL Server data changes – Part 3 – Change Data Capture features

Methods for auditing SQL Server data changes – Part 4 – Change Data Capture set up

Methods for auditing SQL Server data changes – Part 5 – reading the Change Data Capture records

Methods for auditing SQL Server data changes – Part 6 – the SQL Server Audit feature

Methods for auditing SQL Server data changes - Part 7- the SQL Server Audit feature set up

Methods for auditing SQL Server data changes - Part 8 - reading the SQL Server Audit information

Methods for auditing SQL Server data changes – Part 9 – the centralized SQL auditing solution

How to audit your auditing in SQL Server – tracking when triggers are disabled

Using SQL Server traces for SQL Server auditing – Part 1 – The default trace

Using SQL Server traces for SQL Server auditing – Part 2 – Querying a SQL Server trace

Using SQL Server traces for SQL Server auditing – Part 3 – The out-of-the-box solution

PCI Compliance for SQL Server DBAs

GLBA Compliance for SQL Server DBAs

Basel II Compliance for SQL Server DBAs

How to ensure continuous auditing of SQL Server with zero audited data loss

See more solution center articles

PCI compliance checklist for ApexSQL Audit

This article describes PCI compliance requirements for SQL Server database administrators and describes whether, how, and to what extent ApexSQL Audit can help an organization fulfill these requirements

HIPAA compliance checklist for ApexSQL Audit

The following article describes the HIPAA requirements that concern SQL Server database administrators and describes whether, how, and to what extent ApexSQL Audit can help an organization fulfill these requirements

Testimonials

A word of congratulations. I think that your suite is some of the best stuff I have ever used. I had to add auditing to an existing SQL Server and your ApexSQL Audit product did that effortlessly and flawlessly. The client loves the solution I am also impressed by your rapid response to issues and feedback. Keep up the good work

Cameron Townshend

Executive Consultant

ISG Technology

Save a bundle

ApexSQL Audit is included in ApexSQL DBA

6 ApexSQL server tools

Priority support

1 year free support and upgrades

New products added for free

Combined 65% savings

For only $800 more