This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.

You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

I want to build an alert that queries a Custom Property string, I want to type the value in the alert, not select from a drop down list.

lbrowne over 8 years ago

So I have some alerts I'm building and I want to be able to type in a value instead of selecting one of the set items I've defined.

I've set a Custom Property called Site that has a list of our sites with the type of connection in the site title

Example:

Pluto (MPLS)

Our environment has many different connections. MPLS being one type that several sites have.

So, I want to alert on:

Node - Site - Contains - (MPLS) I want to be able to type the (MPLS) value in the value box. But it's only letting me select from the drop down box of all the sites I've created.

However if you go Node - Node Name - Contains - , I can type the value in, which I did in the pic for (MPLS) and (SAT)

Picture for reference, the top string I can only select from the drop down at the very end that has (VPN) listed.

Top Replies

0 lbrowne over 8 years ago in reply to AlexSoul

It certainly is
However, I don't have a "restrict values" under the edit option of this Custom Property. I only have the options in the above picture.
Cancel
Vote Up 0 Vote Down

Cancel
0 AlexSoul over 8 years ago in reply to lbrowne

Valid concern and I can assure you that all your drop down values will be lost and you will need to re-type them all again at the time you re-enable this option. (values assigned to nodes will remain though) ... I just want to re-iterate that I am very reluctant to guide you with this approach as it feels not right... you better be off with SQL trigger based on LIKE statements
Cancel
Vote Up +1 Vote Down

Cancel
0 cahunt over 8 years ago in reply to AlexSoul

So create a new custom property - do not advertise it, but just duplicate your values and use that Custom Property to create the alert with the inclusive - contains.
Cancel
Vote Up 0 Vote Down

Cancel
0 lbrowne over 8 years ago in reply to AlexSoul

Wow, I seriously need another coffee. Good lord. My apologies everyone.
Cancel
Vote Up +1 Vote Down

Cancel
0 cahunt over 8 years ago in reply to lbrowne

There may be a few ways to take care of your issues... don't be afraid to get creative.
Cancel
Vote Up 0 Vote Down

Cancel
0 AlexSoul over 8 years ago in reply to cahunt

ou, that's an idea, thanks cahunt‌ ... here is what you can do (in theory):
1. as suggested by Cahunt - create another custom property based on text and non-dropdown, say [SiteText] and do not advertise it (hide it)
2. create alert which will trigger upon custom property value change for [Site] property
3. create action to update [SiteText] with value from [Site]
4. use [SiteText] in your filter above
... brrrr... dirty... but this is potentially a workaround solution which will be fully supported by SolarWinds support as well.
Cancel
Vote Up +1 Vote Down

Cancel
0 AlexSoul over 8 years ago in reply to cahunt

ye.. go on man... blast it off... we will all laugh together
Cancel
Vote Up +1 Vote Down

Cancel
0 lbrowne over 8 years ago in reply to AlexSoul

When I do ShowSQL and put in my values, the only button is "close" on the SQL dialogue box, which doesn't save the entries I made. I must be missing something.
Cancel
Vote Up +1 Vote Down

Cancel
0 lbrowne over 8 years ago in reply to lbrowne

Picture for reference:
Cancel
Vote Up 0 Vote Down

Cancel
0 AlexSoul over 8 years ago in reply to lbrowne

Screenshot please
Cancel
Vote Up +1 Vote Down

Cancel