Hi,

 

I'm trying to measure how many tickets have been udpated, worked on, actioned, transferred etc... over a specified period e.g, maybe a day or over a week etc....

 

The logical way seems to be to report on the activity history on a request as it stamps any activity including that of a techncian. Is there any SQL someone could help me with that would export all the activity history and list by the Request ID?

 

e.g. I could export all requests for yesterday that had some activity on them.