Change Auditor for SQL Server
Overview of Change Auditor for SQL Server
SQL Server auditing tool tracks, reports and alerts on critical changes
Change Auditor for SQL Server makes database auditing easy and secure. The tool tracks, audits, reports and alerts on changes to Microsoft® SQL Server® permissions, access, configurations and data in real time. Translate change events into simple terms to eliminate audit time and complexity.
Change Auditor for SQL Server enables you to instantly identify the “who, what, when, where and originating workstation” details. Armed with this information, you can automatically generate intelligent, in-depth forensics for auditors and management, reducing the risks associated with day-to-day modifications and ensuring confidence at your next audit.
Features
Centralized auditing
Provides the ability to manage, monitor and audit all Microsoft® SQL Server® changes from a single location, which streamlines management of multiple servers and locations to a single, easy-to-use console.
At-a-glance display
Tracks user and administrator activity with detailed information including who, what, when, where, which workstation and why for change events, plus original and current values for all changes.
Data-level event auditing
Audits changes to databases and tables. Events that can be audited include additions, removals and changes to rows, procedures, tables, views, triggers and more. All changes provide robust details about the change, including the “who, what, when, where and originating workstation” details.
Correlate disparate IT data from numerous systems and devices into an interactive search engine for fast security incident response and forensic analysis. Include user entitlements and activity, event trends, suspicious patterns and more with rich visualizations and event timelines.
High-performance auditing engine
Removes auditing limitations and captures change information without the need for native audit logs, resulting in faster results and significant savings of storage resources.
Auditor-ready reporting
Generates comprehensive reports for best practices and regulatory compliance mandates for GDPR, SOX, PCI-DSS, HIPAA, FISMA, GLBA and more.
Integrated event forwarding
Easily integrate with SIEM solutions to forward Change Auditor events to Splunk, HP Arcsight or IBM QRadar. Additionally, Change Auditor integrates with Quest InTrust for long-term 20:1 compressed event storage and aggregation of native or third-party logs to reduce storage costs on SIEM forwarding and create a highly-compressed log repository.
Role-based access
Configures access so auditors can run searches and reports without making any configuration changes to the application, and without requiring the assistance and time of the administrator.
Event timeline
Enables the viewing, highlighting and filtering of change events and the relation of other events over the course of time in chronological order across your Windows environment for better understanding and forensic analysis of those events and trends.
Related searches
Provides instant, one-click access to all information on the change you're viewing and all related events, such as what other changes came from specific users and workstations, eliminating additional guesswork and unknown security concerns.
Real-time alerts on the move
Sends critical change and pattern alerts to email and mobile devices to prompt immediate action, enabling you to respond faster to threats even while you're not on site.
Event archiving
Schedules both the archiving of older data to an archive database enabling organizations to keep critical and relevant data online while improving overall performance of search and data retrieval.
Web-based access with dashboard reporting
Searches from anywhere using a web browser and creates targeted dashboard reports to provide upper management and auditors with access to the information they need without having to understand architecture or administration.
Specifications
There are specific system requirements for the Change Auditor coordinator (server-side), Change Auditor client (client-side), Change Auditor agent (server-side), and the Change Auditor workstation and web client (optional components). For a full list of system requirements and required permissions for all components and target systems that can be audited by Change Auditor please refer to the Change Auditor Installation Guide.
The Change Auditor coordinator is responsible for fulfilling client and agent requests and for generating alerts.
- Processor
-
Quad core Intel® Core™ i7 equivalent or better
- Memory
-
Minimum: 8 GB RAM or better
Recommended: 32 GB RAM or better
- SQL Server
-
SQL databases supported up to the following versions:
- Microsoft SQL Server 2008 R2 SP3
- Microsoft SQL Server 2012 SP4
- Microsoft SQL Server 2014 SP2
- Microsoft SQL Server 2016 SP2
- Microsoft SQL Server 2017
NOTE: Change Auditor supports SQL AlwaysOn Availability Groups and SQL Clusters.
- Operating system
-
Installation platforms (x64) supported up to the following versions:
- Windows Server 2008 R2 SP1
- Windows Server 2012
- Windows Server 2012 R2
- Windows Server 2016
- Windows Server 2019
NOTE: Microsoft Windows Data Access Components (MDAC) must be enabled. (MDAC is part of the operating system and enabled by default.)
- Coordinator software and configuration
-
For the best performance, Quest strongly recommends:
- Install the Change Auditor coordinator on a dedicated member server.
- The Change Auditor database should be configured on a separate, dedicated SQL server instance.
NOTE: Do NOT pre-allocate a fixed size for the Change Auditor database.
In addition, the following software/configuration is required:
- The coordinator must have LDAP and GC connectivity to all domain controllers in the local domain and the forest root domain.
- x64 version of Microsoft’s .NET 4.6.1
- x64 version of Microsoft XML Parser (MSXML) 6.0
- x64 version of Microsoft SQLXML 4.0
- Coordinator footprint
-
- Estimated hard disk space used: 1 GB.
- Coordinator RAM usage is highly dependent on the environment, number of agent connections, and event volume.
- Estimated database size will vary depending on the number of agents deployed and audited events captured.
Additional Account Coordinator minimum permissions required, please see Change Auditor Installation Guide .
Resources
Change Auditor for SQL Server
Efficiently track, audit, report and alert on changes to Microsoft SQL Server in real time
Microsoft Platform Management solution overview
Streamline Active Directory security and Group Policy Management
2017 Spotlight Report: Cloud Security
In this new report from the Information Security Community on LinkedIn, you will learn how your peers are approaching cybersecurity in the era of cloud, including the latest trends and benchmarks to gauge how your own organization stacks up.
How to Mitigate the Insider Threat
This eBook provides solutions to stop insider threats, manage privileged accounts, simplify GPO management and administration.
Randy Franklin Smith white paper: Securing Active Directory by Using the NIST Cybersecurity Framework
NIST cybersecurity framework enables organizations to create a secure environment. Learn how to apply this framework to your AD and Microsoft environment.
Best Practices for Protecting Against Phishing, Ransomware and Email Fraud
Learn cybersecurity best practices to protect your organization against phishing, ransomware and other threats.
Key Strategies for Meeting GDPR Compliance Requirements
This white paper explains the key provisions of GDPR and why organizations need to take action today to achieve compliance before May 25, 2018, when steep penalties for non-compliance take effect.
Protecting Data in the Healthcare Industry
This white paper discusses best practices to prevent healthcare data breaches — focused on implementing appropriate strategies, policies, processes, training and cybersecurity defenses — that can mitigate much of the risk that healthcare organizations fac
- More Resources
- Communities
- Events & Demos
- Research Docs
- Videos
- Customer Stories
Related Products
Change Auditor for Active Directory Queries
Simplify and refine LDAP query data
Change Auditor for Active Directory
Ensure security, compliance and control of AD and Azure AD.
Change Auditor for Exchange
Document all critical group, mailbox and public/private changes to Exchange
Change Auditor for Windows File Servers
Track, audit and receive reports on all Windows File Server real-time system changes
Change Auditor for EMC
Audit all events related to file activity and permissions on your EMC NAS devices.
Change Auditor for NetApp
Audit all events related to file activity and permissions on your NetApp NAS devices.
Change Auditor for SharePoint
Enable faster, easier and more secure Microsoft SharePoint auditing
Change Auditor for VMware vCenter
Ensure the security, compliance and control of event activity of VMware vCenter Servers
Support & Services
Product Support
Self-service tools will help you to install, configure and troubleshoot your product.
Support Offerings
Find the right level of support to accommodate the unique needs of your organization.
Professional Services
Search from a wide range of available service offerings delivered onsite or remote to best suit your needs.
Education Services
Training courses delivered through online web-based, on-site or virtual instructor-led.