Running Configuration Report

You would need to be running NCM (Network Configuration Manager) to be able get this. You would need to define a 'Compliance Policy Report' with some rules that look for the strings you are looking for.

Thanks I was able to do it

We should go to Configs-Compliance-Create a Rule-Add that rule to a Policy- Add that policy to a report, then dont forget to update all and then select your report and run

I would like to do something similar however I do not know how to have the compliance report export the list of nodes along with vendor/machine type/IP etc.

like you can with report writer.

Can anyone help me out with that?

You can actually do this in the report writer with a custom SQL query: (Replacing STRING MATCH HERE on the last line with whatever you want to match in your configs)

SELECT
n.Caption as 'DEVICE'
,n.IP_Address as 'IP ADDRESS'
,n.VENDOR
,n.MachineType as 'MODEL'
FROM
Nodes n
JOIN
NCM_NodeProperties p ON p.CoreNodeID = n.NodeID
JOIN
NCM_ConfigArchive c on c.NodeID = p.NodeID
WHERE
c.ConfigType = 'Running'
AND
c.Config LIKE '%STRING MATCH HERE%'

-ZackM

Loop1 Systems: SolarWinds Training and Professional Services

• LinkedIN: Loop1 Systems
• Facebook: Loop1 Systems
• Twitter: @Loop1Systems

Thank you this works great.

handy to know.

There is 1 problem though. I only have about 300 nodes and when I execute the query I get back about 20,000 lol.  (many duplicates)

I think its looking at every config saved?

Here you go. This should only return the newest running config.

SELECT  
n.Caption as 'DEVICE'  
,n.IP_Address as 'IP ADDRESS'  
,n.VENDOR  
,n.MachineType as 'MODEL'
,MAX(c.DownloadTime) as 'DOWNLOAD TIME'  
FROM  
Nodes n  
JOIN  
NCM_NodeProperties p ON p.CoreNodeID = n.NodeID  
JOIN  
NCM_ConfigArchive c on c.NodeID = p.NodeID  
WHERE  
c.ConfigType = 'Running'  
AND  
c.Config LIKE '%STRING MATCH HERE%' 
GROUP BY
n.Caption, n.IP_Address ,n.VENDOR ,n.MachineType

That worked. Thanks again.

I know this is an old thread, but I'm hoping you can answer this. I'm very green on SolarWinds. Since the report writer is replaced with the web-based reports, what report would be a good starting point to do the custom query?