I am looking for a report for all NCM nodes with the last startup and running config donwload dates.
Has anyone build such a report?
Here are two reports that I use. SWQL statements are used
1- All monitored devices and their last backup
With this report you can change the ConfigType from Running to Startup (as needed)
2- Just the Cisco Devices
With is one you can change the vendor to what you are looking for
Change the WHERE statement to reflect your required vendor
And ConfigType from Running to Startup (as needed)
/* All Monitored Device Running Config Backup Status */
SELECT OrionNodes.Caption, OrionNodes.DetailsUrl, OrionNodes.Status, OrionNodes.ChildStatus, OrionNodes.Vendor, OrionVendors.Icon, OrionNodes.IP_Address, OrionNodes.IPAddressType, OrionNodes.EngineID, OrionNodes.MachineType, NcmConfigArchive.DownloadTime
FROM NCM.NodeProperties AS NcmNodeProperties
INNER JOIN Orion.Nodes AS OrionNodes ON NcmNodeProperties.CoreNodeID=OrionNodes.NodeID
INNER JOIN Orion.Vendors AS OrionVendors ON OrionNodes.Vendor=OrionVendors.Name
LEFT JOIN NCM.ConfigArchive AS NcmConfigArchive ON NcmNodeProperties.NodeID=NcmConfigArchive.NodeID AND NcmConfigArchive.ConfigType='Running'
/* All Monitored Cisco Device Running Config Backup Status */
SELECT OrionNodes.Caption, OrionNodes.DetailsUrl, OrionNodes.Status, OrionNodes.ChildStatus, OrionNodes.Vendor, OrionVendors.Icon, OrionNodes.IP_Address, OrionNodes.IPAddressType,OrionNodes.MachineType, NcmConfigArchive.DownloadTime
INNER JOIN Orion.Nodes AS OrionNodes ON NcmNodeProperties.CoreNodeID=OrionNodes.NodeID INNER JOIN Orion.Vendors AS OrionVendors ON OrionNodes.Vendor=OrionVendors.Name LEFT JOIN NCM.ConfigArchive AS NcmConfigArchive ON NcmNodeProperties.NodeID=NcmConfigArchive.NodeID AND NcmConfigArchive.ConfigType='Running'
WHERE OrionNodes.Vendor = 'Cisco'
The normal warnings apply
Disclaimer:
Please note, any custom scripts or other content posted herein are provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software that you have purchased from SolarWinds, and the information set forth herein may come from third party customers. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment. Any custom scripts obtained herein are provided to you “AS IS” without indemnification, support, or warranty of any kind, express or implied. You elect to utilize the custom scripts at your own risk, and you will be solely responsible for the incorporation of the same, if any.
