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

custom unit



I created a sql query sensor. I need PRTG to recognize the time format at 01:05:00 The database query already brings me this format, in PRTG I registered the custom unit but I don't know how to fill in the custom unit to recognize this format.

Now the bank query brings 00:13:46 and in PRTG the value is 857

There must be a way?

custom sql sqlsensor

Created on Feb 2, 2023 8:49:06 PM

1 Reply



Hello Paquintao,

I'm afraid that the database does not store Date values, only integers and floats. So whatever you wish to monitor, you need to ensure that you return the queries results in these data types. "Custom" unit just means that you can define the units name after the actual value.

Kind regards,
Felix Saure, Technical Support Team

Created on Feb 7, 2023 1:17:46 PM by  Felix Saure [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.