NotePage, Inc. Forum Index

count of messages in given state

 
Post new topic   Reply to topic    NotePage, Inc. Forum Index -> NotePager Pro Support
View previous topic :: View next topic  
Author Message
sfp



Joined: 20 Feb 2017
Posts: 9
Location: Poland

PostPosted: Thu May 11, 2017 5:31 am    Post subject: count of messages in given state Reply with quote

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?


Back to top
View user's profile
Tech Support



Joined: 25 Aug 2003
Posts: 4041

PostPosted: Thu May 11, 2017 8:14 am    Post subject: Reply with quote

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
Back to top
View user's profile
Display posts from previous:   
Post new topic   Reply to topic    NotePage, Inc. Forum Index -> NotePager Pro Support All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2002 phpBB Group
Theme created by Vjacheslav Trushkin