count of messages in given state

[sfp]

Is there any way to get from NotePager Pro info about number of pending or bad messages?

We use NotePagerPro as SMS delivery tool for SolarWinds and we would like to monitor message sending:
* number of messages in separate states
* age of the first and last message in the given state

Can we fetch those data from NotePager process run by SolarWinds or better directly from database?

[Tech Support]

If you have a way of creating an ODBC link to the np_messages table of the NotePager Pro database, you could monitor for those values, yes.

Any record that has a value of 0 np_sent is considered a pending message.

Any record that has a value of 1 in np_error is considered a failed message.

Any record that has a value of 1 in np_sent AND a value of 0 in np_error is considered a successfully delivered message.

_________________
Tech Support
support@notepage.com
http://www.notepage.net