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

book

Article ID: 86200

calendar_today

Updated On:

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

Cause

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

Environment

OS: Windows

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