[Spce-user] get date of subscriber termination?

Gavin Sweet gavin.sweet at skyracktelecom.com
Tue Apr 2 13:09:28 EDT 2013

Hi all - 


I want to collect data with some simple sql of create and (modify and)
terminate for a subscriber.


I've been through most of the tables I could see that maintain subscriber
data . 

Is there an additional table other than billing.voip_subscribers and
provisioning.voip_subscribers that persist the state of a subscriber,
specifically where I can find when a subscriber was terminated?


There are create and modify timestamps for active subscribers in
provisioning.voip_subscribers but not for terminated subscribers.

Terminated subscriber details can be seen in billing.voip_subscribers but
there are no timestamps.


Am I missing something?




-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/mailman/private/spce-user_lists.sipwise.com/attachments/20130402/f9bf10ce/attachment.html>

More information about the Spce-user mailing list