What's new in ApexSQL Audit 2021.xx ? (4310740)

Release: 2021.01.2120
Date: February 08, 2023

Fixes:
• 221223: 'Saving configuration was not successful' message is displayed when trying to exclude a local login in a domain environment
• 225537: SQL Audit auditing configuration is only partially applied when a database which doesn't exist anymore is included in the configuration filters
• 225485: Auditing configuration is only partially applied when there is an ApexSQL Audit Extended event session on SQL Server in stopped state
• 227648: ‘Saving configuration was not successful’ error is encountered when applying a Before-after configuration for an Availability Group
• 227647: ‘Error connecting to server’ is encountered when trying to add a database after an Availability group has been added for auditing
• 227557: Error ‘Msg 10314, Level 16, State 11’ is encountered when trying to update a table on the (new) primary AG replica after a failover
• 227466: SQL Audit database session is not properly created after a failover occurs in an Availability Group
• 228349: An Availability Group cannot be added via listener name if the FQDN of the listener is used
• 227237: AG cluster cannot be added via listener name if the name doesn't match the one given to the Availability Group
• 228615: Incomplete data after reading Microsoft Extended Event file using the MS function - fn_xe_file_target_read_file
• 228776: Auditing sessions are not properly created when a specific combination of filters is used

Release: 2021.01.2098
Date: August 22, 2022

Enhancements:
- Additional processing of files from the ActiveSessions folder after encountering 3rd party parsing errors.
- Creation of zipped files containing details about the queries which could not be processed.

Fixes:
-224205: An Extended event session file containing auditing data gets deleted by SQL Server when a very large number of operations is being executed.

Release: 2021.01.2095
Date: July 26, 2022

Fixes:
- 223536: Cannot parse "Deny a permission to principal" operation when there are blank spaces at the end.

Release: 2021.01.2093
Date: July 7, 2022

Enhancements:
- Additional logging is available by activating Debug mode.

Fixes:
-222847: Package is not quarantined when a SQL Query operation type is not extracted correctly from query text data in a specific case.

Notes:
- ApexSQL Audit 2021.01.2093 hotfix includes a fix/change to the quarantine mechanism which (in some specific cases) may result in an increase of the number of files contained in the quarantine folder on the audited server.

- Please note that the application will not process the quarantined files automatically, and they need to be processed manually by moving them to their respective Session folder (“ActiveSessions” for Extended events, “ActiveSqlAudits” for SQL Audit and “ActiveTraces” for Trace data collection)

Release: 2021.01.2091
Date: June 22, 2022

Fixes:
- 222518: The auditing configuration is not applied due to timeout being strictly defined as a 10-second value that is now set to follow global timeout settings.
- 222602: Application log messages are incorrectly labelled as INFO instead of ERROR when an error occurs while creating audit sessions.

Release: 2021.01.2089
Date: June 1, 2022

Fixes:
- 219140: API JSON output adds comma characters at the end when 'eventsPerPage' value from the URL is greater than 50,000.
- 220351: API call link cannot be opened in the browser (or used to generate data in power BI) when logged in as a user different to the one running ApexSQL Audit central.
- 221921: DML operations inside of a stored procedure are not audited when using Extended event data collection.

Release: 2021.01.2085
Date: February 10, 2022

Fixes:
- 218419: Table-level permission changes are not captured in ApexSQL Audit reports when using 'SQL Audit' technology.