Solarwinds DPA alerts in Orion

Hi,

I am working on an alert in NPM which will trigger from DPA. I can query DPA for the specific instance ID, however the database instance name does not show up. I have attached a screenshot. Is there a way, I can pull the database instance name when the alert is triggered? I don't get an option to add the Database Name.

Find more posts tagged with

npm

dpa

Accepted answers

Lofstrand

Hi @arnabmk

As @mesverrum said, you can always create your own custom variables for any data available in the database, if not a prebuilt variable exist.

Try below custom variable:

${N=SWQL;M=SELECT D.name FROM Orion.DPA.DatabaseInstance AS D WHERE D.DatabaseInstanceID=${N=SwisEntity;M=DatabaseInstanceID}}

All comments

mesverrum

You can probably get it with a custom swql variable whenever there isn't an OOTB variable for what you need.

Lofstrand

Hi @arnabmk

As @mesverrum said, you can always create your own custom variables for any data available in the database, if not a prebuilt variable exist.

Try below custom variable:

${N=SWQL;M=SELECT D.name FROM Orion.DPA.DatabaseInstance AS D WHERE D.DatabaseInstanceID=${N=SwisEntity;M=DatabaseInstanceID}}

arnabmk

Perfect @Lofstrand , thank you so much. That did the trick.