SWQL Query - Merging two tables

jaspalsingh

Hi all,

I have difficulty in using SWQL (since i don't have any background in SQL at all ).

I would like to merge two different table.

Syntax tried:

SELECT NodeID,Nodes.HardwareHealthInfos.ServiceTag

FROM Orion.Nodes

UNION ALL

SELECT
SwitchNumber,SerialNumber

FROM Orion.NPM.SwitchStackMember

however when i try above, it return with mismatched input 'SELECT' expectin '('

I'm not really sure how to correct the syntax. Appreciate much for any help here with a catch being to get all values from Orion.Nodes schema.

Thanks and regards

Find more posts tagged with

Accepted answers

jm_sysadmin

If you need all nodes, then making it a left join will help. All the stack members are required to be in this since they all have nodes assigned, and making it a left join takes the entire nodes table.

SELECT n.NodeID, n.Caption, n.HardwareHealthInfos.ServiceTag, s.SwitchNumber, s.SerialNumber 
FROM Orion.Nodes n
LEFT JOIN Orion.NPM.SwitchStackMember s ON n.NodeID = s.NodeID

All comments

marcrobinson

You were missing the parenthesis on the second query. (Select blah blah...) . I ran it but did not return much from the second query. Something is off with that entity - could just be me. But you may not need a union statement as a join seems to work. see below.

SELECT n.NodeID, n.Caption, n.HardwareHealthInfos.ServiceTag, s.SwitchNumber, s.SerialNumber 
FROM Orion.Nodes n
JOIN Orion.NPM.SwitchStackMember s ON n.NodeID = s.NodeID

jaspalsingh

Thanks but this limits number of records. I need an option to retrieve all records from Orion.Nodes & Orion.NPM.SwitchStackMember schema

jm_sysadmin

SELECT n.NodeID, n.Caption, n.HardwareHealthInfos.ServiceTag, s.SwitchNumber, s.SerialNumber 
FROM Orion.Nodes n
LEFT JOIN Orion.NPM.SwitchStackMember s ON n.NodeID = s.NodeID

jaspalsingh

@jm_sysadmin it worked like a charm.