Ok, I have a question for the CRM Gods, and its a little bit tricky. I'm working on developing a report for SQL Server that will show the results of a daily executed Duplicate Detection job. The job will have the same name, and be executed each
morning.
By doing so, it this way I know I can write sql to query the DuplicateRecord table and join it to the AsyncOperations tables. By doing so I can get a list of the records that have duplicates based on the published rules.
The problem is the other side of that Duplicate Detection screen. Whe I look at each duplicate record generated, it seems to be listing the base record, and a single duplicate. Which is fine, except that I know in some cases, when you go to save
these records it will show 3-4 possibles based on the duplication rules. Where in the database would I find those 3-4 potential duplicate records that I might be able to display them in the report.
Any thoughts?