Help with binding Alert to a SQL Instance

[Johnathan R]

Very new to Event Management (as you will see)

I am trying to bind an Alert to a MSFT SQL Instance. The actual CI name is "DBINSTANCE@HOSTNAME"

The string value on the alert comes in as: 

[08-16-23] The view is empty(HOSTNAME\DBINSTANCE)

How would you tackle this to bind to the right CI?

I can write a regex to retrieve HOSTNAME\DBINSTANCE ... but how to transform it into DBINSTANCE@HOSTNAME, and put it in the Node field?

Would I use manual attributes in some way? Make $dbinstance and $hostname .. and then make the Node field be $dbinstance@$hostname somehow? Can't figure this part out

[Henrik Jutterst]

I'm still looking for a solution to this, but not sure that this is something that actually exist at the moment.

Therefore, I've added this as an Idea to the Idea Portal:

You can find the link here:
Idea: Event Management - Bind CI to Dynamic named CI 

[Henrik Jutterst]

Hey there @Johnathan R !

Did you solve this? Just just got some feedback from my question so that I could bind my alerts to Dynamic CIs with "@" sign in names.

Maybe the post/question can help you?

Binding Event Rules to dynamic CI names 

So I used "CI Field Matching" and then was able to bind it to the correct CI.

Let me know if you need any help, and I'll try to guide.