Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
'Auditing filter change monitor' alert information is not displayed in full due to character limitation for the [UserSummary] column in [ApexSQL].[AlertReports] table (4378480)
'Auditing filter change monitor' alert information is not displayed in full due to character limitation for the [UserSummary] column in [ApexSQL].[AlertReports] table
설명
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).
해결 방안
WORKAROUND: None
STATUS: The issue is fixed in ApexSQL Audit 2023.01.2238 version