HTTPS monitor search string variable?

You can find it in Orion.APM.ComponentTemplateSetting table under  Key = "SearchString"

EDIT:

You have to insert SQL query into email body - Add SQL queries to alert email notification (solarwinds.com)

I put something to use as a starting point:

${SQL: SELECT 
C.Value 
FROM APM_ComponentTemplateSetting C
JOIN APM_Component T ON C.ComponentTemplateID = T.TemplateID
where T.ApplicationID = ${N=SwisEntity;M=Application.ApplicationID} and C.[Key] = 'SearchString'}

You can find it in Orion.APM.ComponentTemplateSetting table under  Key = "SearchString"

EDIT:

You have to insert SQL query into email body - Add SQL queries to alert email notification (solarwinds.com)

I put something to use as a starting point:

${SQL: SELECT 
C.Value 
FROM APM_ComponentTemplateSetting C
JOIN APM_Component T ON C.ComponentTemplateID = T.TemplateID
where T.ApplicationID = ${N=SwisEntity;M=Application.ApplicationID} and C.[Key] = 'SearchString'}