• State Verified Answer
  • Locked Locked
  • Replies 3 replies
  • Subscribers 38 subscribers
  • Views 436 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.

All Groups with count of members in title

sturk22

All,

I saw a post for a feature enhancement where the groups names would include a count of the members in paran's. The requester had seemed to be able to do this with SWQL, but my swql skills are limited, I'm wondering if anyone has seen this or has a solution to provide an output that looks similar to this:

grouped_nodes_with_count_2.png

This would be really useful in our environment, as a quick reference to the node levels within the groups.

I was referencing this thread in Thwack when I came across it:

but the example SWQL was never posted...

Appreciate any help on this.

Thanks

SteveT

  • 0

    I'm assuming their SWQL resource doesn't have all the fun javascript expanding menus unless they completely rolled their own resource.

    Basically it would be something like

    Select Name, count(name) as [Count] from orion.containers group by name

    Thats off the top of my head though, it could be orion.container if you get an error.  You could probably get a lot more elaborate with how you present that data but this is the basic info.

  • 0 in reply to mesverrum

    I finally got something close with a custom SWQL:

    SELECT   g.Name

    , g.detailsURL as [_Linkfor_Name]

    , '/Orion/images/StatusIcons/Small-' + g.StatusDescription + '.gif' AS [_IconFor_Name]

    , g.Description

    , Count(cm.ContainerID) as [Group Members]

    FROM Orion.Groups g

    INNER JOIN Orion.ContainerMembers cm on cm.containerid = g.containerid

    GROUP BY g.Name;

  • 0 in reply to sturk22

    Change INNER JOIN to FULL JOIN and it will show empty groups as well. 

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.