SP Monitor with SQL Server Database: impossible to filter alerts with the character "_ "on the name

Products

• CA Automic Sysload

Issue/Introduction

Affects Release version(s): 1

Error Message :
None

Patch level detected:Sysload Monitor 1.40
Product Version: Sysload 1.4.1

Description :SP Monitor with SQL Server Database: it is impossible to filter alerts with the character "_ "on the name

Environment

OS: Windows

Cause

Cause type:
By design
Root Cause: The character underscore ( _ ) is a special character in SQL language that means any char.

Resolution

Change the naming convention of the alerts in case you want to filter via SP Monitor, replace for example the character "_" by the character "-"

Fix Status: Released

Fix Version(s):
Component: Monitor
Version: Sysload 1.4.1

Additional Information

Workaround :
N/A