What is this?

This knowledgebase contains questions and answers about PRTG Network Monitor and network monitoring in general. You are invited to get involved by asking and answering questions!

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

Db check with sql query

Votes:

0

Your Vote:

Up

Down

Hello, I want to check db status via sql query. However, I must use date value in the sql command.

ex; EXEC [db_query] 1,'(StateDate)'

I want to use "StateDate" as last error date. How can I use last error date in the sql query by PRTG ?

Thanks.

database mssql sql

Created on Jul 17, 2012 8:45:06 AM by  madzombie (0) 1



1 Reply

Votes:

0

Your Vote:

Up

Down

Hello,

if possible convert the date in your query directly to a integer number since the last error and then use this number in PRTG. Otherwise it will be a string which can only be used in the "message" of a sensor.

best regards.

Created on Jul 17, 2012 12:36:10 PM by  Torsten Lindner [Paessler Support]



Please log in or register to enter your reply.


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.