Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

We have a requirement as follows. An owner of a site has set up an alert for at least 50 users. They now want to run some sort of query and/or report that will allow them to monitor that alert. They want to be able to see who is subscribed to that alert and ideally remove them if they have moved to another dept etc. and no longer need alert set. Just seeing who is subscribed to the alert will go a long way. They are indicating that the subscription feature in SP 2001 allowed for this. The alert subscription could be handled as a group rather than individually.

It is my understanding that OOTB this is not possible. Once an alert is assigned to a number of users, that one user can only administer this alert from that point forward. I also know that an owner can delete alerts that are set for individuals.

Paul

share|improve this question
add comment

3 Answers

I have not tried this myself, but here is a custom solution: Display all my alerts

However, this web part only shows the alerts for the current user. You would need to download and modify the code to iterate through SPWeb.Alerts instead of SPUser.Alerts and add a column to the grid for the user name.

share|improve this answer
    
+1, not possible out of the box. You'll need to write code or use a third party web part. –  Kit Menke May 11 '11 at 16:53
add comment

Microsoft did not provide a solution for this specific need. While James Love is correct in stating that this is completely unsupported as a solution in a production environment, it works. However, I would modify the query to return only distinct useremails as follows:

Select Distinct UserEmail from ImmediateSubscriptions where AlertTitle = "Your Alert Title"

share|improve this answer
add comment

You can get the list of subscribed users to a particular alert by executing the following SQL query on your Content database

Select UserEmail,UserId from ImmedSubscriptions where AlertTitle ='Your Alert Title'
share|improve this answer
3  
This is a completely unsupported practice for a solution in a production environment. –  James Love May 11 '11 at 15:00
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.