[Spce-user] get date of subscriber termination?

[Gavin Sweet]

Hi folks - any thoughts on finding that mod date when subscriber status
becomes terminated?

We were thinking about adding a db trigger on the billing table to write the
date somewhere else (a new table I guess) when there is an update to a row
to change status to Terminated.

 

But it doesn't feel very upgrade safe.? Anyone got any advice regarding
this, I assume sometimes that tables are altered in new releases?

 

Cheers

Gavin

 

 

From: spce-user-bounces at lists.sipwise.com
[mailto:spce-user-bounces at lists.sipwise.com] On Behalf Of Gavin Sweet
Sent: 02 April 2013 18:09
To: spce-user at lists.sipwise.com
Subject: [Spce-user] get date of subscriber termination?

 

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

  _____  

No virus found in this message.
Checked by AVG - www.avg.com
Version: 2013.0.2904 / Virus Database: 2641/6218 - Release Date: 04/01/13

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20130404/6b89a1c8/attachment-0001.html>