${StatusOrErrorDescription}

Question

Does anybody know where the Alert variable ${StatusOrErrorDescription} pulls from in the database?  I'm looking for a table and column name if you have it.

Thanks,
Jason Henson
Loop1 Systems
www.Loop1Systems.com

Jason.Henson · Accepted Answer

NM, We found it.

Select StatusOrErrorDescription from apm_alertsandreportsdata where componentid = ${ComponentId}

I also found this from another Thwack post:

SELECT ErrorMessage FROM APM_CurrentComponentStatus accs INNER JOIN APM_PortEvidence_Detail aped ON aped.ComponentStatusID = accs.ComponentStatusID WHERE accs.ComponentID = ${ComponentId}

Thanks, 
Jason Henson
Loop1 Systems
www.Loop1Systems.com