Report to show duplicated tickets

Report to show duplicated tickets

A lot of analysts use the duplicate function.

Is it possible to write a query that shows how many tickets were created as a result of this Duplicate function

I would need to see

Ref Number
Requester
Subject 
Created Date
Analyst that created the ticket
Region


Database: MSSQL
Version and Build: 9.2 Build 9221

                  New to ADSelfService Plus?