Custom Poller regex help.

Hello. I am trying to pull information from a device to get the location but having a bit of trouble. The devices dont have the locations on then but they are listed in the name. So the naming convention is, STATE_City_Location_Device. Each one is seperated by and underscore and what I am needing to Regex out is the third item, the location. Sorry I'm new to this and not sure if there is an easier way to say, ok give me the value between the second and third underscore. Thank you in advance.

Find more posts tagged with

poller

regular_expressions

regex

Accepted answers

All comments

jm_sysadmin

I don't have time to iron it for for you but in SWQL you will be able to find the underscores (maybe twice if the state/city length is too variable to get the start and then again for the end.

SWQL Functions · solarwinds/OrionSDK Wiki · GitHub

CharIndex(toFind, toSearch [, start]) - Returns the position at which toFind occurs within toSearch (starting at position start, if provided) or zero if toFind is not found. Supported since Orion Platform 2018.2 (NPM 12.3) and later.
SubString(s, start, length) - Returns a substring of length characters starting at position start (the first character is position 1).

adam.beedell

If you want to regex, regex 101 or a LLM are you best bet

Regex may not be the tool you want to apply to this situation unless you're integrating with another tool of some sort to perform the function

You could set an alert with the action "set a custom property" with 'WHERE nodes.caption like '%_Place_%' and duplicate that a few times
Or it'd be some nice bit of powershell etc with
-Connect-swis
-get-swisdata ... "Select all from nodes"
-foreach
--string split Caption for 2nd and 3rd underscore
--Maybe lookup table for full site name vs some properties
-foreach
--@ ( properties) = various location stuff
-- set-swisdata $props