Is there any way to pull a list of records where addresses have been updated/changed within a certain time period? The box office has been printing a lot of tickets during pandemic and we want to pull tickets with address changes before mailing. The only thing I can find is output date of last record change, but that will be a lot more time consuming than pulling specific for address updates.
Thank in advance!!
Jen
Hi Jen - have you tried the Constituent Audit Report? You can filter by date / table (t_address) and by list. Once run , you could export as csv to get to the updated records only.
Thank you! It's over 700 pages using the T_Address, but I'm now thinking maybe I can merge it with a list of printed tickets and narrow it down.
Another idea: If you don't have it already, you could add date changed from the address record as an item in your list builder options (or if you have SQL experience, put the data directly from SSMS).
Not sure how to do this (and no SQL), but I think I've got the list. Unfortunately it's over 800 records long because of other address clean-up not necessarily address changes.
I wish I had know about this a year ago. Back then I wrote a SQL statement that looked at TA_AUDIT_TRAIL. It did what I needed it to do, but I sure wish I had found this report first.
Ashley