Hi,
I was wondering if someone could help me in joining two queries together in SWQL?
I have two queries (planning on about 4) that pull out
DisplayName and CurrentConnections from vsvrCurClientConn OID
and
DisplayName and Status from vsvrState OID
Both queries work great on their own and produce two separate tables (in two widgets)
1)
DisplayName CurrentConnections
##############################
Server1 20
Server2 45
2)
DisplayName Status
##############################
Server1 Up
Server2 Partial
In legacy dashboard this could be easily combined in to a single table without having to use any SWQL. I've tried using hubble but it doesn't display the swql for this page.
DisplayName Status CurrentConnections
#####################################################
Server1 Up 20
Server2 Partial 45
etc
I am really struggling to join the two queries together using DisplayName
1)
SELECT [data].[CustomPollerStatus].[DisplayName] AS [DisplayName],
[data].[CustomPollerStatus].[Status] AS [CurrentConnections]
FROM orion.npm.custompollerassignmentonnode AS data
WHERE
[data].[CustomPoller].[UniqueName] = ('vsvrCurClientConn')
WITH NOLOCK
2)
SELECT [data].[CustomPollerStatus].[DisplayName] AS [DisplayName],
[data].[CustomPollerStatus].[Status] AS [Status]
FROM orion.npm.custompollerassignmentonnode AS data
WHERE
[data].[CustomPoller].[UniqueName] = ('vsvrState')
WITH NOLOCK
Is anyone able to help please?
