I'd like to create a report (or some way to see) all my devices that do not have up to date config downloads. We've ran into an issue lately where we've lost some access to devices, and not realized it until later on. Then, we find out that NCM hasn't backed up configs for months. I'd like to be able to see this proactively and not have to react when a device needs to be rebuilt, but has no up to date config.
Can someone help me out with how to do this? It seems like it should be simple, but I can't find a way to do it yet. I think a SQL query can do this in a report, but that is NOT my strong suite, and I'm not sure how to structure that query.
Thanks!