Issue with Retrieving SSL Certificate Expiry Days for Synthetic Monitors in New relic
I’m working on setting up a dashboard for my clients to display URL status and SSL certificate expiry days. I have configured both SSL and ping monitors for several URLs, but I’m facing an issue where my SQL query:SELECT * FROM SyntheticRequest only returns data for ping monitors and not for SSL monitors. Specifically, it only shows sslCertificateExpirationDaysRemaining for one URL, and the SSL monitor for this URL is currently disabled.(I am not sure why only this URL is working)