Hi Everyone,
I have to find out how many times our users have changed the first name and/or last name of Contact records.
I've tried to use the Auditbase table combined with the actions, operation and attributemask, but I'm finding it's either one or none.
What I mean is, I'm only returning results where the first and last name have been updated as part of a larger update to the record.
Any help would be appreciated.
*This post is locked for comments
There is a script that can convert audit table to a more "readable" format:
community.dynamics.com/.../crm-2011-get-audited-attributes-from-auditbase-table
Then you can probably just run a query on the results..
(or, maybe, you can use it to figure out how to run the query directly on the AuditBase)
Hi Bodders,
the best approach is using Audit.
In the past, I developed a solution to save user change in a record.
Just create a plugin which saves in a new entity (we named something like "My Entity Changes") firstname, lastname, datetime and systemuser each time firstname or lastname change and ... you are done!
Hope it helps!
If you found the answer helpful, please mark as Verified 
Join my network on LinkedIn 
Follow me on Twitter 
Thank You & Best Regards
Francesco Picchi
Microsoft Dynamics CRM Consultant, Bologna+Milano, ITALY
Independent Contractor
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (