I'm trying to leverage reports in NCM to provide a list of certificates and their expiration dates in our Juniper VPN's. The idea behind it is to have a report sent every X days, via email. I've added a MIB to NCM that does list all the certs on the device, but I cannot seem to find a way of querying that MIB within a custom report. I also need to filter entries as there are certs on our VPN's that I wish not to list.
Originally I tried finding a way to do this in Orion NPM, but there doesn't seem to be a way to filter and join two MIB queries in one custom webpart. I'm sure there is a way to maybe do something with SQL queries, but honestly I'm not a coder... Ideas?