[Spce-user] get date of subscriber termination?

[Gavin Sweet]

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?

 

Cheers,

Gavin

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