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

Article Comments

Hello,

If your Query is able to provide the correct output, you can use it for your Microsoft SQL v2 sensor. Then, you can set the limits in the channel and set the State Trigger for the sensor to trigger the notification in the Notification Triggers Settings.

The below SQL guide could help you with the setup of the sensor:
How to set up the SQL v2 sensors in PRTG? Is there a guide?

Kind regards,
Muna Azmi - Tech Support Team


May, 2023 - Permalink