• State Not Answered
  • Locked Locked
  • Replies 1 reply
  • Subscribers 27 subscribers
  • Views 964 views
  • Users 0 members are here
Options
Related
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.

Use Custom Properties to classify nodes in Dashboard

wsothard

This may be a simple question to answer.  I am used to building dashboards, but needing to use a custom property for a new dashboard.

The custom property is "Network_Family"

I want to build a widget in the dashboard that will sort or classify all discovered nodes using that "Network_Family" property.

My SWQL is weak, remedial but learning.  I have mainly just needed to use the graphical build tool for most dashboards.  I have done some SWQL but never with custom properties.

Thank you in advance for any and all help everyone can provide.

Parents
  • 0

    This should get you started

    Select NodeID, IP_Address, Caption, status, Network_Family
FROM Orion.NodesCustomProperties cp
INNER JOIN Orion.nodes nd on cp.NodeID = nd.NodeID
Where Network_Family Like '%YourFamilyNameHere%' 
Order by Status DESC

Reply
  • 0

    This should get you started

    Select NodeID, IP_Address, Caption, status, Network_Family
FROM Orion.NodesCustomProperties cp
INNER JOIN Orion.nodes nd on cp.NodeID = nd.NodeID
Where Network_Family Like '%YourFamilyNameHere%' 
Order by Status DESC

Children
No Data

SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.

SolarWinds Customer Success Center Certification Media Vault Link Accounts
About THWACK Blogs For Government Edit Settings Free Tools & Trials
Legal Documents Terms of Use Privacy California Privacy Rights Security Information
©2024 SolarWinds Worldwide, LLC. All Rights Reserved.