Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

SWQL help needed for a count of total nodes in multiple containers.

Hi All,

I am attempting to make a dashboard that shows total counts of nodes in multiple containers with statuses of critical, warning etc.

Using SWQL

SELECT Count (n.DisplayName) as ContainerMembers FROM Orion.ContainerMembers n WHERE n.ContainerID = '1' AND n.Status = '14'

Works for a single container. I am struggling to work out how to make the count span multiple containers like 1, 2, 3 and 4 though.

Could anyone advise if this is possible and show an example?

Thanks.

Find more posts tagged with

Accepted answers

adam.beedell

You want

GROUP BY n.ContainerID

and maybe

HAVING n.Status = '14'

-I say without running it.

"Orion.ContainerMembers n" really threw me. I know when i started it took me ages to find out what that magic "n" was because it was a nightmare both googling for it and working without it. - it's an "alias" and you can put whatever you want there really, like "cm" in this case. Useful tool.

GROUP BY does what you want.
HAVING is like WHERE but after a grouping

All comments

adam.beedell

You want

GROUP BY n.ContainerID

and maybe

HAVING n.Status = '14'

bruce.smith

Thanks Adam,

GROUP BY sorted it.

If it helps anyone else this is the SWQL query for all critical nodes in container id's 1 and 2.

SELECT
Count (n.Status) as Qty
FROM Orion.ContainerMembers n
where n.ContainerID in ('1','2')
GROUP BY n.Status
HAVING n.Status = '14