If user want the duplicate records from specified time to current time in deduplication process report, user need to update the date in the eventdetail table.
 

How to generate Deduplication report from specified time to current time.

Product: TIBCO MDM Version: 9.x OS: All Supported Operating Systems

To change the date in the eventdetail table follow the below steps:

First, check the last most event i.e Auto Duplicate Detection Process in MDM UI and get the  eventid (associated event's id). 

After that update the value of SDDJob_StartingDate row in the eventdetail table using eventid with the date that user want to get the duplicate record from this date to the current date.

So data duplication process will pick the date and fetch the records from this date to the current date.

The queries are:

================================================

UPDATE eventdetail SET value = '2019-06-12' WHERE eventid=XXXX and name='SDDJob_StartingDate';

commit;

================================================

where XXXX is the ID of data deduplication process(associated events id),  and date format is in 'YYYY-MM-DD'.

Note: Before executing steps please bring the MDM down and then perform the steps, after that start the server and perform the data duplicate detection process.