Notifications
Announcements
No record found.
Hi Experts,
I would like to know if there is any code or way to pull out a report on accounts or any record in CRM where i can check for changes in account ownership, i know we can check for individual records but is there a way to pull it out as a report for all accounts etc.
Thanks in advance for your response.
Hello,
If you have ownerid field audit enabled then I believe you have variety of ways to get your report. If you don't have enabled I'm afraid you're out of options.
I will assume that ownerid field is enabled for audit. Here is what you can do:
1. If you need to get that report just once then request your organization DB backup from Microsoft, restore it to some SQL and build the report that will give you results you needed.
2. If you need it on iterative basis (let's say once a week) you can turn on Data Export Service - docs.microsoft.com/.../replicate-data-microsoft-azure-sql-database and build the report you need using Azure SQL replica of your CRM DB.
3. You always can develop an app that will generate that report using API but as for me it's overkill.
Thanks Andrew, Yes that will be overkill, i just want to access that to look at the account ownership transfer essentially nothing more and thats going to be a one time activity. I will try to go this route and see what come out of it, i know then i have to develop query and stuff but for now we can close this. Thank you so much for your help.
No out of the box report that I'm aware of. I would try the following option if it works for you:
1 - Auditing - which tracks changes at the field level for each record
docs.microsoft.com/.../audit-data-user-activity
2 - Workflow - Create a Note/Update a Field/etc whenever there is a Ownership Change. Then use Advanced Find to query this change
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Tom_Gioielli 70 Super User 2025 Season 2
Gerardo RenterÃa Ga... 33 Most Valuable Professional
Daniyal Khaleel 32 Most Valuable Professional
