question

DeeAkil-6556 avatar image
0 Votes"
DeeAkil-6556 asked MichaelHan-MSFT commented

Get a list of email alerts for a list/library

Hello,

I have a requirement of getting a list of users who are subscribed to a list on SP 2013. I can't really do it through the user interface because it's a high-usage site, and there are lots of user alerts. How can I get this list of users through PowerShell or the database? I tried a couple of things but they didn't work out for me.

Thank you
Dee

sharepoint-dev
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @deeakil-6556

Welcome to Q&A Forum!

This is a quick note to let you know that we are performing research on this issue.

Thanks,
Echo Du

0 Votes 0 ·

1 Answer

MichaelHan-MSFT avatar image
0 Votes"
MichaelHan-MSFT answered MichaelHan-MSFT commented

Hi ,@deeakil-6556

You could try the below way to get the alert:

 $web = get-spweb https://yourweburl
 $web.alerts | select List,User


Reference: https://social.technet.microsoft.com/Forums/ie/en-US/e5d4be3f-d39e-47ca-b4d4-a254fee44a31/sharepoint-2013-get-all-user-alerts-list-from-a-specific-sp-listlibrary-through-html-?forum=sharepointgeneral


If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.



· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

He Michael,

Thank you for the reply. This doesn't return anything against the site collection, but I'm also trying to get user alerts from a SharePoint list.

Thank you
Dee

0 Votes 0 ·

Hi @DeeAkil-6556,

Per my test, this would return all the alerts in the web. As you can see in the below picture:


141939-image.png

If you want to get user alerts from a specific list, you can add the condition like this : $web.alerts | where {$_.List.title -eq "list1"} | select List,User.


141840-image.png


0 Votes 0 ·
image.png (7.7 KiB)
image.png (7.4 KiB)

It worked nicely! How can I get the users' full name? Can I get it?

0 Votes 0 ·
Show more comments