cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
162
Views
0
Helpful
1
Replies

Unity SQL Total New Messages Location

Chad Stachowicz
Level 6
Level 6

All,

I am trying to do a ODBC dip into unity, and I cannot figure out where in the SQL Database the total number of new messages for a specified subscriber is held. Essentially i want to be able to retrieve the number the lady on unity says...

"hello you have X new messages, to play these message press 1" Where is the X held in SQL?

Thanks much!

Chad

1 Reply 1

Chad Stachowicz
Level 6
Level 6

ReportsDb->SUBMSG table contains this, but it is only showing the most recently left vmail. I need to find this somewhere, where I can look up anyones, is this done on the fly looking at the message store maybe?

Thanks,

Chad