Or to use exec command that will get REGISTER as stdin, parse it and save... if you do not have thousands of customers which register every 40 sec then it should work though it not a nice solution, I agree, just easiest to do :) using avpops you can only do that for customer who really wants it. -----Original Message----- From: serusers-bounces(a)iptel.org [mailto:serusers-bounces@lists.iptel.org] On Behalf Of Dr Rodney G. McDuff Sent: Wednesday, March 01, 2006 6:40 AM To: serusers Subject: Re: [Serusers] Saving historical registration information Jan Janak wrote: modifications. Use a database backend that has triggers. When a new entry is added to the location table write the record somewhere else. > Jan. > > Alistair Cunningham wrote: >> We've been asked by a customer to keep the last registration >> information, even after expiry. >> >> They want to be able to look at the database and see where and when a >> phone last registered from, even if it was months ago. Only the last >> registration is important; they don't care about older ones. >> >> This could be done using various methods such as a trigger in the >> database to update another table any time location is written to, but >> this is ugly. >> >> Does any one know of a simple way to do it, preferably in ser.cfg? >> >> > > _______________________________________________ > Serusers mailing list > serusers(a)lists.iptel.org > http://lists.iptel.org/mailman/listinfo/serusers -- Dr. Rodney G. McDuff |Ex ignorantia ad sapientiam Manager, Strategic Technologies Group| Ex luce ad tenebras Information Technology Services | The University of Queensland | EMAIL: mcduff(a)its.uq.edu.au | TELEPHONE: +61 7 3365 8220 | _______________________________________________ Serusers mailing list serusers(a)lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers