i need to create a sensor on my database which contain the notifications history as if it has no new entries after xx minutes, it initiate a warn. After xx minutes, trigger an alarm.
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.
the sensor must generate a trigger after 5mn without sending notification and a alarm after 10mn without notif.
Jun, 2016 - Permalink
Would you like to trigger a action within your SQL database? If not, what exactly do you mean with alarm (without notification)? That somehow contradicts... :/
Jun, 2016 - Permalink
i receive login/logout notifications from my sql database.it's not normal to stay 10mn without receiving notif,so i want to create a sensor that after 5mn without notif will generate an notice & if after 10mn always no notif ,will generate an alarm.
Jun, 2016 - Permalink
Are you already monitoring login/logout within PRTG? If so, what sensor are you using?
Jun, 2016 - Permalink
Well that won't do any good in terms of monitoring log in/out operations within a SQL database as ping only checks the availability of the host to respond to a ping. You basically need to get the number of concurrent user sessions with a query and use one of our SQL sensors to retrieve that value. Then you can use the channel limits to alert accordingly, once no logins happen within a certain timespan.
More information about the SQL sensors can be found here: https://www.paessler.com/manuals/prtg/available_sensor_types#database
Jun, 2016 - Permalink
thanks for your help.the solution is to write a script and follow your way to create an mysql sensor. Just wondering,does it exist a full and detailed prtgdocumentation in french?if yes please share .
Jun, 2016 - Permalink
how can add for exple the 7 last lines values of a sensors in my notification email(plain text format)?
Jun, 2016 - Permalink
is it possible to add a graph to the content of my email or just add the link to the graph in the content ?
Jun, 2016 - Permalink
The text mail content can actually be changed, directly in the notification settings, when the format is set to " Text with custom content". However, there's no placeholder that represents a link to the current live graph unfortunately. The same goes for values. Only the latest value can be inserted using %lastvalue.
Jun, 2016 - Permalink
Hm, I'm afraid that this can't be realized with the built in sensors. Do the entries have a timestamp field we could use for calculations?
Jun, 2016 - Permalink