How can I quickly see who closed an alert in SCOM 2016

I need to be able to see quickly who closed an alert in the operations or web console for SCOM 2016. Users are set up as Operators role and can close alerts. Is there a quick way to tell who closed the alert whether it be a user or the system itself by automatic means?
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rich WeisslerProfessional Troublemaker^h^h^h^h^hshooterCommented:
I don't have 2016, but assuming it's materially the same as 2012, play with this against the DataWarehouse database:
select * from Alert.vAlertResolutionState ars 
inner join Alert.vAlertDetail adt on ars.alertguid = adt.alertguid 
inner join Alert.vAlert alt on ars.alertguid = alt.alertguid
  where AlertName like '<beginning of the alertname you're looking at>%' AND

Open in new window

And look at the  StateSetByUserId field.

(And base script scarfed from kevinholman's blog.)
BeallsDesktopTeamAuthor Commented:
Thank you. This works for me as an admin with access to the DB.
I guess I should have worded the question a little better. What I need to accomplish for the team closing the alerts is for them to see who closed the alert within their own team, not me looking up for them. Is there a way to include the closed alert details in a dashboard, in the closed alert email, or would it have to be queried in the DB? I'm new to SCOM so this is all uncharted territory for me :)
Rich WeisslerProfessional Troublemaker^h^h^h^h^hshooterCommented:
Oh, I see.  I think it can be added to the closed alert email...
Test this in your test environment:
In Administration/Notifications/Channels -- Modify your email channel (or set up a new one)
  On the format page, within the Email message portion, go down to the portion of the email alert format you want the closer to be added... on the right side of that page (in my SCOM 2012 instance anyway), there's a arrow that allows things to be added.  Add "Alert Last Modified By".

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Rich WeisslerProfessional Troublemaker^h^h^h^h^hshooterCommented:
To add it to an alert panel... you'll need an alert panel which includes Closed alerts (in this case), but from the panel, you should be able to pull up "Tasks"/"Personalize View" and add the "Last Modified By" and/or "Resolved By" fields.
Rich WeisslerProfessional Troublemaker^h^h^h^h^hshooterCommented:
Three methods of displaying the information requested have been provided.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
System Center Operations Manager (SCOM)

From novice to tech pro — start learning today.