I thought this sounded easy until I started trying to nail down a solution. Our business wants to know how we can look at a person's name and see all the incidents they've updated. We don't care if it's the last person who updated the ticket, we want to know if they EVER updated that ticket.
I know there's an Activity area of the incident with names every time it gets updated. I thought this would be a good bet but I couldn't find that variable to search from off the INC table. I also didn't find it in the incident fact table.
How would you quickly look up all incidents a person updated?
