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

Attention: This article is a record of a conversation with the Paessler support team. The information in this conversation is not updated to preserve the historical record. As a result, some of the information or recommendations in this conversation might be out of date.

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