CiviCRM Community Forums (archive)

I'd looking to generate a report on contacts that haven't been edited in a given timeframe. For example, we might want find all the contacts who haven't been edited in the last six months.

If this isn't something that already exists, I'd love any suggestions on how to structure the report queries. I've got a couple hack-ish thoughts about how to do this using the activity log, but it would be helpful to hear from the experts.

I did notice that the database doesn't keep a last edited date for each contact.

The brute-force methods I thought of would require touching a lot of contacts:

1. Find all contacts.
2. For each contact, if there is an edit after a given date in the log, remove from list

1. Get IDs of contacts updated in the last time period from the log.
2. Find all contacts not in that list.

Could attach a limit to the second to make it more reasonable -- we could then just refresh the report when we need more contacts to update.