Need a report that lists any issue a user has owned at any point over a given time frame. Doesn't look like this is possible in the 2009 R4.02 Change History Report (you can see ownership changes, but not restrict the data to a particular user or users). Anyone have pass-through SQL for this? Thanks.
Here is the Advacned SQL that we use. You just need to enter the actual tablename (eg, USR_ISSUES), the username and the date range required. (I have had to add as an image as I am never sure if I paste code whether it will display properly