I'm trying to create a report (SQL or Tab "Reports") to bring me first the interation on a Request (the first time a technician contact a user, respond a user or close a request).

I believe this interation can be made by two forms:

      01 - In "Request" Tab, when send email by "Reply" or "Forward";

      02 - In "Resolution" Tab, when status is changed to "Closed" or "Resolved" and the request is saved.

With the help of a profiler I've verified some things:

When we use the option "01", the software insert values into "dbo. Notification", "dbo. Notification_Recipients", "dbo. NotificationToDesc" and " Notify_WorkOrder" and update values into "dbo. WorkOrderStates" and "dbo. WorkOrder".

When we use the option "02", the software  insert values into "dbo. RequestResolver", "dbo. RequestResolution", "dbo. WorkOrderHistory", "dbo. WorkOrderHistoryDiff", "dbo. RequestOnHold", "dbo. Notification", "dbo. Notification_Recipients", "dbo. NotificationToDesc", "dbo. Notify_WorkOrder" ,  "dbo. RecentItems" and "dbo. RequestRI"  and update values into "dbo. WorkOrderStates" and "dbo.WorkOrder".

Does anyone have made a SQL based on this tables that can bring me the first interation on a Request?