HI Purushotham, In Incident table there is a field called as Reassignment Count which you can use for reporting to find all reassigned incidents. There is also an OOTB metric in Performance analytics related to this named as 'Number of reassigned open incidents'. Inorder to find to which all Assignment Groups the incident is reassigned, there is a data base view for incidents called as incident_metric which was created using Incident, metric_instance and metric_definition tables. This DB view will have all entries related to all changes done to Assignment Group for a particualr incident when we group by Incident Number. Please see below capture for reference where Assignment group changes related to two incidents are shown.
