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.

Report all monitored elements

Hi All.

Is there any way to produce a report that lists what elements are monitored on what nodes?
I need to produce lists of every element on every node.
e.g.

Node1:
            -CPU
            -Mem
            -Volume C
            -Custom app mon 1
            -Custom app mon 2
            -etc, etc

Thanks!

Parents
  • In SQL joining all these different kinds tables with different kinds of things on them can be kind of a mess with a lot of the data duplicating in columns, but this should get you the raw info you asked for as a custom swql query.

    It would be possible to clean this up and make the output a lot nicer but it is going to take some SQL wizardry.

    SELECT

    n.Caption as [Node]

    ,case

    when max(cpu.maxload) is null then 'No'

    when max(cpu.maxload) is not null then 'Yes'

    end as [CPU]

    ,case

    when max(cpu.totalmemory) is null then 'No'

    when max(cpu.totalmemory) is not null then 'Yes'

    end as [Memory]

    , v.caption as [Volumes]

    , i.ifname as [Interfaces]

    , a.name as [Applications]

    FROM Orion.Nodes n

    left join orion.volumes v on v.nodeid=n.nodeid

    left join orion.npm.interfaces i on i.nodeid=n.nodeid

    left join Orion.CPULoad cpu on cpu.nodeid=n.nodeid

    left join Orion.APM.Application a on a.nodeid=n.nodeid

    group by n.nodeid, n.Caption, v.caption, i.ifname, a.name

    order by nodeid

    Results

    pastedImage_13.png

    -Marc Netterfield

        Loop1 Systems: SolarWinds Training and Professional Services

  • Hi Mark - I'm trying to add a custom Node property "Customer" in here for the column output, and my formatting isn't working.

    I am trying:

    pastedImage_0.png

  • In swql the nodes custom properties don't live on the same view as the nodes themselves

    replace all n.customer with n.customproperties.customer and that should work

Reply Children