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.
Db check with sql query
Modified on 2025-06-10 14:46:46 +0200
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.
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.
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