In addition to providing the 5Ws (Who, What, When, Where and Workstation), Netwrix SQL Server reporting tool will also show the values of information from both their previous and current states in all reports. This helps determine the impact of changes or serve as a reference should a change need to be reversed or documentation is required by a regulatory or security auditor. For example, if a user’s SQL Server roles were changed, the audit report will show both the original and new server role assignments.
Gathering this information from native SQL audit logs is difficult because of the commonly cryptic nature of SQL Server event descriptions. Further compounding the problem is having to cross-reference event IDs and lengthy strings of data that do not readily translate into human-readable text. Netwrix Auditor through its use of AuditAssurance™ and AuditIntelligence™ technologies, multiple sources of information are used to compose single records for each change event providing any necessary cross-referencing or translations before data is written to storage.
Having the ability to capture information is good however having the ability to capture the data and compose human-readable content for reporting that shows ‘before’ and ‘after’ information is what organizations require for successful auditing of their SQL servers. This ensures data is collected and stored efficiently maintaining only the necessary details so they can be archived and reported on over the short and long-terms.
|Download Free Trial||Request Quote||Questions?|