SQL Query Output - SQL TDE Certificate Expiry - SQL v2 sensor configuration

Hi,

I have created a SQL query which outputs the number of days from date that a SQL certificate expires.

SELECT datediff(day, getdate(),expiry_date) days_between
FROM sys.certificates
WHERE name = 'DEVSQL2016_3_TDE_Cert';

The query outputs a integer for the number of days

I want to create a Microsoft SQL V2 sensor which will show a warning for 60 days threshold and then down on 30 days threshold. The certificate is created on the master DB.

Is this possible with this sensor and query output?

Thanks,

David

certificate microsoft query sql tde