What is this?

This knowledgebase contains questions and answers about PRTG Network Monitor and network monitoring in general.

Learn more

PRTG Network Monitor

Intuitive to Use. Easy to manage.
More than 500,000 users rely on Paessler PRTG every day. Find out how you can reduce cost, increase QoS and ease planning, as well.

Free Download

Top Tags

View all Tags

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




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?



certificate microsoft query sql tde

Created on May 18, 2023 11:58:42 AM

Last change on May 23, 2023 5:22:03 AM by  Felix Wiesneth [Paessler Support]

1 Reply




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

Created on May 23, 2023 12:22:13 PM by  Muna Azmi [Paessler Support]

Disclaimer: The information in the Paessler Knowledge Base comes without warranty of any kind. Use at your own risk. Before applying any instructions please exercise proper system administrator housekeeping. You must make sure that a proper backup of all your data is available.