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?

Article Comments

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


Feb, 2023 - Permalink