Does anyone know how to get this interface to show from a SWQL perspective? I Can get any of the subinterfaces to show up but since this interface does not have an associated IP address nothing seems to work. With the code provided I can get the two interfaces I need however if I add the NodeIPAddresses.IPAddress or the NodeIPAddresses.SubnetMask it fails. A previous conversation recommended I use the InterfaceIndex however the interface that does not have an IP address is not listed in there. @KMSigma.SWI Any help?
Thanks in advance and see you all at SWUG Chicago!!
SELECT TOP 100 Nodes.interfaces.InPercentUtilizationThreshold.CurrentValue AS InPercentUtilizationThreshold_CurrentValue
, Nodes.interfaces.OutPercentUtilizationThreshold.CurrentValue AS OutPercentUtilizationThreshold_CurrentValue
, Nodes.interfaces.CustomProperties.Comments AS CP_Comments
, Nodes.interfaces.Caption
, Nodes.interfaces.Index
, concat(round((Nodes.interfaces.Inbandwidth / 1073741824.0),2), ' gbps') as Speed
, Nodes.interfaces.StatusDescription
, Nodes.interfaces.DetailsUrl
, Nodes.Caption AS Device_Name
FROM Orion.Nodes as Nodes
