Solutions

Db check with sql query

Modified on 2025-06-10 14:46:46 +0200

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.

Article Comments

Attention: This article is a record of a conversation with the Paessler support team. The information in this conversation is not updated to preserve the historical record. As a result, some of the information or recommendations in this conversation might be out of date.

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.

Jul, 2012 - Permalink

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.

Db check with sql query

Article CommentsAttention: This article is a record of a conversation with the Paessler support team. The information in this conversation is not updated to preserve the historical record. As a result, some of the information or recommendations in this conversation might be out of date.

Search

Attention

Related Articles

Article Comments

Attention: This article is a record of a conversation with the Paessler support team. The information in this conversation is not updated to preserve the historical record. As a result, some of the information or recommendations in this conversation might be out of date.