Need to let the other teams know the configured bandwidth of interfaces to stop us being queried each time.
Having some issues with our SW product due to be upgraded next month to resolve so kind of stuck me without being able to query our SQL DB to see what the entry I need is. Also I'm complete novice at SQL and someone made the below previously. Anyone able to help add configured bandwidth into the below?
SELECT DISTINCT PSCView.Node, PSCView.Location, PSCView.Inbps, PSCView.IfName, PSCView.InterfaceAlias, PSCView.Internal_Location_ID, PSCView.Outbps, PSCView.PollInterval, PSCView.Status, PSCView.StatusLED, REPLACE(PSCView.StatusLED, '.gif', '') AS StatusWord, PSCView.Caption, PSCView.IfSort, --CONCAT (PSCView.IfName, ' - ',PSCView.InterfaceAlias) AS NewInterface, PSCView.DetailsURL from ( SELECT Nodes.Caption AS Node, Nodes.Location, NodesCustomProperties.Internal_Location_ID, Interfaces.Inbps, Interfaces.IfName, Interfaces.InterfaceAlias, Interfaces.Outbps, Interfaces.PollInterval, Interfaces.Status, Interfaces.StatusLED, Interfaces.Caption, REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Interfaces.IfName + 'AAAAAAAAAA','/1AAAAAAAAAA','/01AAAAAAAAAA'),'/2AAAAAAAAAA','/02AAAAAAAAAA'),'/3AAAAAAAAAA','/03AAAAAAAAAA'),'/4AAAAAAAAAA','/04AAAAAAAAAA'),'/5AAAAAAAAAA','/05AAAAAAAAAA'),'/6AAAAAAAAAA','/06AAAAAAAAAA'),'/7AAAAAAAAAA','/07AAAAAAAAAA'),'/8AAAAAAAAAA','/08AAAAAAAAAA'),'/9AAAAAAAAAA','/09AAAAAAAAAA') AS IfSort, 'http://ixnetmon.ptv.com/Orion/Interfaces/InterfaceDetails.aspx?ViewID=229&NetObject=I:'+CAST(Interfaces.InterfaceID as varchar(256)) as 'DetailsURL' FROM Nodes INNER JOIN Interfaces ON (Nodes.NodeID = Interfaces.NodeID) INNER JOIN NodesCustomProperties ON Nodes.NodeID = NodesCustomProperties.NodeID WHERE Nodes.Caption LIKE 'GBLEE2O-SW%' ) PSCView ORDER BY PSCView.Node, PSCView.IfSort;