Change Auditor for SQL Server
Change Auditor for SQL Server Overview
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
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.
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.
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.
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.
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.
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.
Auditor-ready reporting
Generates comprehensive reports for best practices and regulatory compliance mandates for SOX, PCI-DSS, HIPAA, FISMA, GLBA and more.
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.
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
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 SP3
- Microsoft SQL Server 2014 SP2
- Microsoft SQL Server 2016 SP1
NOTE: Change Auditor does not support SQL high availability technology other than 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
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, we strongly recommend:
- 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.
Resources
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.
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
A Practical Guide for GDPR Compliance
In this white paper, we provide a checklist for complying with EU GDPR compliance requirements.
Conversational Geek e-book: Hybrid AD Security Detection & Alerting
Your Active Directory (AD) security is constantly in a state of change, making it difficult to understand your risks from static reports alone. That’s why you need to actively monitor all changes made in AD — being able to detect suspicious activity and a
Conversational Geek e-book: Hybrid AD Security Investigation & Recovery
Changes in your AD environment can be indicative of a breach, leaving it unreliable. Explore AD security investigation and recovery plan best practices.
- More Resources
- Communities
- Events & Demos
- Research Docs
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.
Training & Certification
Training courses delivered through online web-based, on-site or virtual instructor-led.