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
Store

Count from two tables showing as one in Modern Dashboard

knightyomega

Hi all,

I'm counting all "Up" entries from Orion.VIM.VirtualMachines and Orion.Nodes seperately.

Is there any way to combine these two "UP" KPI's to count as one? All my attempts hit SWQL limitations.

Current Look:

Top KPI for Up is

"SELECT N.TheCountFROM (SELECT COUNT(1) as TheCount FROM Orion.VIM.VirtualMachines n WHERE n.Tags.Name = 'VMtagName' AND (Status = '1') ) N"

Bottom KPI:

SELECT N.TheCountFROM (SELECT COUNT(1) as TheCount FROM Orion.Nodes n WHERE n.CustomProperties.Team IN ('XYZ') AND (Status = '1') ) N

Find more posts tagged with

moderndashborads

swql query

KPI Widget

Comments

knightyomega

This top post seems to fix it, if anyone stumbles on this post.

https://thwack.solarwinds.com/discussion/100356/sum-count-from-two-entities

SELECT TOP 1

(SELECT COUNT(NodeID) as values

FROM Orion.Nodes WHERE SysName LIKE '%branch%')

(SELECT COUNT(DisplayName) as values

FROM Orion.NPM.SwitchStackMember

WHERE DisplayName LIKE '%branch%')*1.0

AS AllTotals

from orion.nodes

Credit to @marcrobinson

Lofstrand

Hi @knightyomega

Great you found a solution. But I had to try another approach :-D

I don't have any VM's in my lab so it's not fully tested but hope it will work.
I have here excluded all VM's that have a NodeID, as they are counted as Nodes. So we don't count some devices two times.

SELECT

    Count(N.NodeID) + Count(V.VirtualMachineID) as QTY


FROM Orion.Nodes AS N

LEFT OUTER JOIN Orion.VIM.VirtualMachines AS V ON

    1=1 

    AND V.NodeID IS NULL 

    AND V.Status=1

    V.Tags.Name='VMtagName'

WHERE

    N.Status=1

    AND N.CustomProperties.Team IN ('XYZ')

Quick Links

Cisco ASR Devices
Cisco ASR Devices.pollerCisco ASR Devices
Basic SWQL Syntax
SWQL is built on the framework of SQL and as such supports most of the standard clauses as part of a query. A very simple example query is: SELECT Caption, IPAddress, Vendor, ResponseTime FROM Orion.Nodes Dissecting this query is relatively straightforward: show some fields (Caption, IP address, Vendor, and Response Time)…
Cisco ASA SSL Tunnels
Active SSL Tunnels-ASA.UnDPThis poller *should* display the number of Active SSL VPN (Anyconnect) Tunnels currently connected to your box. However, I tried it with my 5520 running 8.0.4 and for some reason I get a OID Not Supported. Here's my post in the forum: *EDIT* This is confirmed working with at least Interm release…
HP ProCurve Switches Hardening check
HP ProCurve Switches Hardening check.xmlGeneral hardening for HP switches