Last Successful Login Report

Question

We are managing 3 large (1000+ nodes) regional Orion instances.  We are currently working thru bringing in a lot of large M&A locations into our Orion instances, and working thru getting NCM regularly backing up the configs.  Working through the daily NCM report finds a lot of nodes that are reporting errors, but in checking, everything is working fine, it just was unsuccessful during the last backup job for whatever reason.  That 'noise' makes it a bit difficult to find the nodes that are actually having real issues with NCM being unable to backup configs, and which are just nodes that failed one time.

What I would like is a report that can show me that last date/time of a successful login to a node, so I can determine which are nodes with real issues and no successful logins. Dates of configs are not useful for this, because it could be a node that just hasn't had a config change in some time, so NCM is successfully logging in, just not putting a new config.

Is there a way to just report on the date that NCM was last able to successfully able to login to a device?

wluther · Answer

dirt​ I have built out a few views for our Engineers to use, which helps them track firmware, reboots, and various other items. Within that view, my SWQL query includes the last login status, as well as the date/time of last downloaded running and startup config. It can easily be sorted, as well as searched. Would this be something similar to what you are looking to do?

Thank you,

-Will

superfly · Answer

There is a build in NCM report called Login Failure Report but it doesn't have a date associated to it. It's located in the NCM Security section.

There's also a report called Login Status which may be useful.