The script below is used to find any service ticket numbers that have duplicated ticket numbers
select distinct d.Ticket_Number,
Count(d.Ticket_Number) as "Number of Tickets with Same Ticket Number", d.Ticket_Status
from AR_customer a, AR_customer_site b, ar_customer_system c, sv_service_ticket d
where d.Customer_Id = a.Customer_Id
and d.Customer_Site_Id = b.Customer_Site_Id
and d.Customer_System_Id = c.Customer_System_Id
Group by d.Ticket_Number, d.Ticket_Status
having count(d.ticket_number) >1
