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]

Hi Johnathan!

I see that we both have similar questions in dynamic binding in an Event Rule.
I have posted my own question here: Binding Event Rules to dynamic CI names 

I'll try to let you know if/when I find the answer to our problem(s).

Because, as you say, there's no problem to extract the "variables" using RegEx, but to combine them into a dynamic name... That's the issue.

I'll keep an eye on your post also if you get a good reply.
I've also asked ServiceNow Support on their take on this.

[Harsh1]

Hi This can be done using regex and creating a manual attribute by combining both regex

[Henrik Jutterst]

Looking into this solution now.

Keep you posted here. Thanks for the feedback so far @Harsh1 !

[Henrik Jutterst]

Not getting the desired result here 😞

---------

Binding alert CI process flow:
Run Identification Engine. No matching CI was found. But host was found by Identification Engine.
Event CI type is empty
No related CI found for binding, alert CI will be bound to node (id): 8eff2432db1fbbc01918d29c6896197f
Bind to 8eff2432db1fbbc01918d29c6896197f

Event rule applied: DynamicCIName

---------