Responsible Team - what variable is this

Question

Team,

I'd like to use Responsible Team as a variable.  Is this already a variable or would have to be customized?

New to SolarWinds, please advise.

Waverly

omavel · Answer

Hi, @mrxinu !
I'd like to put it in email action, into the body of email alert. And going to use this in future as 'Assigned groups' field (after integrating SW with ServiceNow).

Now, the only way is to use SWQL-request and there is no such variable like  ${N=Alerting;M=ResponsibleTeam} - am I right?

wywilliams · Answer

awww...found it.  Contact.

mrxinu · Answer

Hey there! Where are you trying to use the variable? If you're using SWQL somewhere, it's located in the Orion.AlertConfigurationsCustomProperties entity/table. If you were creating a list of the alerts and their ResponsibleTeam, it would look like this:

SELECT
    Configs.Name
    , CustomProperties.ResponsibleTeam
FROM Orion.AlertConfigurations AS Configs
INNER JOIN Orion.AlertConfigurationsCustomProperties AS CustomProperties
    ON Configs.AlertID = CustomProperties.AlertID