Hi,
there are plenty of them, but it would be hard to find one that is 100% matching your requirments. You will have to dev it yourslef. I have currently no access to SCOM, but I would start like this:
--To view a count of all alerts closed by all users:
select statesetbyuserid, count(*) as 'Number of Alerts'
from Alert.vAlertResolutionState ars
where resolutionstate = '255'
group by statesetbyuserid
order by 'Number of Alerts' DESC
You can add additional resolution states here.
After you check the results, you could limit the results byy using filtering coondition on the time frame.
This comes again from Kevin.
(If the reply was helpful please don't forget to upvote or accept as answer, thank you)
Regards,
Stoyan