getting latest archived config

paulz

Hello, I'm using the Orion SDK for Python. I'd like to use it for obtaining the latest downloaded config for each device out of the archive - don't need to search for specific devices or conditions at this time - just need the latest for each one that NCM knows of.

For starters I tried to use a query found on another post to get the Cirrus based node id.

swis.query("SELECT NodeID, CoreNodeID, EngineID, NodeCaption FROM Cirrus.Nodes"

I was not able to pull up anything at all. I tried using any arbitrary core nodeid I found prior in another query:

swis.query("SELECT NodeID, DisplayName, IP, Description FROM Orion.Nodes"

I didn't think it's a permissions issue, but I'm not entirely sure . Has anyone tried the above successfully?

Then assuming I can get to the point of pulling Cirrus node id, how can I make sure to use a query or module that will provide the latest archived config?

I have NCM 8.0

Thanks!

mrxinu

Assuming you want the most recent running config, this should do it:

SELECT
    n.IPAddress
    ,cn.NodeID
    ,n.Caption
    ,ca.Config
FROM Cirrus.Nodes cn
JOIN Orion.Nodes n ON cn.CoreNodeID = n.NodeID
JOIN Cirrus.ConfigArchive ca ON cn.NodeID = ca.NodeID
JOIN (
    SELECT ca.NodeID, MAX(ca.DownloadTime) AS MostRecentDownload
    FROM Cirrus.ConfigArchive ca
    WHERE ca.ConfigType = 'Running'
    GROUP BY ca.NodeID
) tbl1 ON ca.NodeID = tbl1.NodeID AND ca.DownloadTime = tbl1.MostRecentDownload