• State Not Answered
  • Replies 1 reply
  • Subscribers 53 subscribers
  • Views 168 views
  • Users 0 members are here
Options
Related

Group availability swql

lbarnes

I've been trying to work this swql out for a while now and just can't seem to piece something together.  I figured it out for servers, switches, ups's, SDwan devices but for groups, arrrgg.  We have offices that are Groups of course.  Each office has a description IE. Atlanta.  I would like to create a modern dashboard box like I did for servers, switches, etc. that shows each offices "uptime" in 5 9's over the last 24 hours, 6 hours, 7 days, etc.

Parents
  • 0

    Groups are tricky.

    You could use the PercentMembersAvailability column in the Orion.ContainerStatus table but that's availability of any object in that group, not necessarily the site/office being offline.

    The PercentAvailability column should represent the overall group status - if you use Mixed Status rollup the group (and PercentAvailability) should go down only if the entire site is offline.

Reply
  • 0

    Groups are tricky.

    You could use the PercentMembersAvailability column in the Orion.ContainerStatus table but that's availability of any object in that group, not necessarily the site/office being offline.

    The PercentAvailability column should represent the overall group status - if you use Mixed Status rollup the group (and PercentAvailability) should go down only if the entire site is offline.

Children
No Data

SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 200,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 SolarWinds Lab Link Accounts
About THWACK Blogs Federal & Government Edit Settings Free Tools & Trials
Legal Documents Terms of Use Privacy California Privacy Rights Security Information
©2021 SolarWinds Worldwide, LLC. All Rights Reserved.