I have been working on getting to query for the Cisco, Audio Codes, Juniper and Dell devices.
I have found the tables and columns I need but having trouble getting the join down.
I was using https://www.dofactory.com/sql/join AND https://www.w3schools.com/sql/sql_join.asp
Wanted to ask Thwack to see if anyone had some ideas.
Thanks
------------------------------
SELECT TOP 1000
HWH_HardwareInfo.Manufacturer AS Manufacturer,
HWH_HardwareInfo.Model AS Model,
HWH_HardwareInfo.ServiceTag AS ServiceTag,
Nodes.IP_Address AS IP_Address,
Nodes.Vendor AS Vendor,
Nodes.Description AS OS,
Nodes.C3_Function AS Function,
Nodes.L2_BuildingComplex AS Complex,
Nodes.L3_Building AS Building
FROM Nodes
INNER JOIN HWH_HardwareInfo
ON Nodes.NodeID = HWH_HardwareInfo.NodeID
WHERE Nodes.Vendor = 'Cisco' AND Nodes.L2_BuildingComplex = '1600'
