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 v2 sensor to show DATETIME / PRTG format

Votes:

0

Hi,

I have a SQL query that gives me DATETIME column in a single row as a result. Result looks like:

Jun 15 2022 11:04AM or
11:04 depends on how I convert it.

What should be the correct way to represent SQLL DATETIME to Date, hours, minutes and not: 3,864,279,759.08 which doesn't make sense?

Should I convert it to some PRTG format that then could be represented correctly by PRTG?

I have looked into documentation but for: date format, convert date, ... and time I have found nothing.

Thank you,

date datetime format sql sql-v2 time

Created on Jun 15, 2022 9:08:44 AM

Last change on Jun 15, 2022 3:20:45 PM by Felix Wiesneth [Paessler Support]



1 Reply

Votes:

0

Hello,
Within the sensor settings you can enable the option "Process data table" in order create additional channels. However please note that only numerical values can be displayed. "Jun 15 2022 11:04AM" seems to be a string. Maybe this example might however be of interest for you to display strings within the message field of the sensor instead as workaround.

Created on Jun 20, 2022 9:55:57 AM by Timo Dambach [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.