Return
-
Title
'Auditing filter change monitor' alert information is not displayed in full due to character limitation for the [UserSummary] column in [ApexSQL].[AlertReports] table -
Description
- ApexSQL Audit has a character limitation of 32 000 characters for the text in the UserSummary column from the ApexSQL.AlertReports table.
- When the limit is reached, the text is cut off and ellipsis (...) is placed at the end of the entry both in the UI (Summary pane of the alert in Alert History) and the UserSummary column in ApexSQL.AlertReports tables (and views).
Expected behavior: To have all the information available from the alert in the UI without the text being cut off. Specifically, for the 'Auditing filter change monitor') alert - when there is a change in the Before-after configuration. Either to raise the limit or to modify the text of the alert to include only the objects and operations that have been added or removed (as opposed to having the entire configuration listed twice - for Before change and After change). -
Resolution
WORKAROUND:
NoneSTATUS:
The issue is fixed in ApexSQL Audit 2023.01.2238 version -
Defect ID
235808