I am trying to fetch the interface config data as shown in the SolarWinds UI.

siddhantg28

Hi,

I am trying to fetch the above data from SolarWinds which is shown under Orion/Interfaces/InterfaceDetails.aspx?NetObject=I:{interfaceId} along with other many details about the interface in context.

From what I found that this data is managed by NCM for each interface.

So in order to fetch this data I ran these queries :

SELECT TOP 1 i.InterfaceName, i.NodeID AS CoreNodeID    FROM Orion.NPM.Interfaces i    WHERE i.InterfaceID = @id 

SELECT TOP 1 ca.ConfigID, ca.DownloadTime    FROM NCM.ConfigArchive ca    JOIN NCM.NodeProperties np ON ca.NodeID = np.NodeID    WHERE np.CoreNodeID = @core AND ca .ConfigType = 'Running'    ORDER BY ca.DownloadTime DESC

SELECT ca.Config FROM NCM.ConfigArchive ca WHERE ca.ConfigID = @id 

And then I do a regex operation in python to scrape the above data from 1477 lines of text response.

I would like to understand if there is an easier way to do this as running 3 queries + regex operation is a little costly and adds unnecessary complexities.

I also want to fetch the runtime/current/real-time bandwidth of the interface…I guess that should be managed by NPM? If so can someone please help me with the SWQL query for it……

Thank you.

cnorborg

So, was trying to figure it out by doing some fancy work with CharIndex and Substring, but then I found this "Action" in SWQL query manager that might be more useful to you. In the "Cirrus.ConfigArchive" table (Cirrus is the original name for NCM), there is an Action you can Invoke and give it the nodeID of a node, and it will return all the interface config snippets in XML. These can also be called by Python and such.

Given a NodeID, it will give you a dump of all the Interface config snippets for that box.

Might make things easier for you? HTH