This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Help with SQL query

Hi,

Please help me with my doubt.

Is there any way to insert a component status icon in the sql query below ?

Select n.caption, ccs.errormessage FROM APM_CurrentComponentStatus ccs WITH (NOLOCK)

INNER JOIN APM_Application a WITH (NOLOCK) ON ccs.ApplicationID = a.ID

INNER JOIN Nodes n WITH (NOLOCK) ON a.NodeID = n.NodeID

where ccs.ErrorMessage LIKE '%cisco_router%'

  • Hello,

    In the APM_CurrentComponentStatus table there is column Availability that contains the status of the component. Here are all possible values:

    Unknown = 0

    Up = 1

    Down = 2

    Partly Available = 3

    Not Licensed = 4

    Warning = 5

    Critical = 6

    Disabled = 7

    Unmanaged = 8

    Unreachable = 12

    I hope that helps.

    Thanks,

    Lukas Belza (SolarWinds development)