Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds


  Asked By: Evelyn    Date: Aug 06    Category: Sharepoint    Views: 708

this one really annoys me because i cant really find a better way to do it..

every company has a little turnover (especially sales organizations) and we have some alerts of former employees that i have to dig through each site and find then manually delete. is there some sort of query in the database that can assist me in deleting former employees alerts?



6 Answers Found

Answer #1    Answered By: Chantal Rosa     Answered On: Aug 06

There certainly os a way to query  your database  and find  this out but
the alerts  have to manually  deleted fro mthe site. Also, the my sites
created by your former employees ahs to be manually deleted.

Answer #2    Answered By: Kyla Eckert     Answered On: Aug 06

Just thinking out loud here on this, but here is one way you might be able to do
it programmatically.

Create an AD group called Former Employees, and place the user's account in this
group. Write a web part that you place on an admin-access-only web part page at
the top-level site  of the site directory. The web part would crawl through the
sites in the directory, and delete  all alerts  for any users in the Former
Employees group.

Then some routine could once a day hit all of the top-level sites, logging in as
the administrator.

Answer #3    Answered By: Damon Garner     Answered On: Aug 06

i guess there isnt a data dictonary to figure out which place the info is stored in the database? does anyone know the query? i dont mind going into the sites once i figure out which site  the alerts  are coming from. the part that takes the longest is to find  that darn wss site that they set the alerts up on.

Answer #4    Answered By: Alexis Ellis     Answered On: Aug 06

The data dictionary is located at

Also, immediate alerts  and scheduled alerts are stored in separate
places within the database. You may use queries similar to the
following to find  each:

FROM dbo.SchedSubscriptions
WHERE (UserEmail LIKE N'%Smith%')

FROM dbo.ImmedSubscriptions
WHERE (UserEmail LIKE N'%Smith%')

Answer #5    Answered By: Percy Beach     Answered On: Aug 06

We want to setup a comment web part, but don't seem to be able to make it work. We want

1.. Users to be able to submit comments
2. Users cannot see any comments/replies but their own
3. Site Administrators be able to set up alerts  when new comments are added.

It seems that when you setup the list to only read your own, you cannot set an alert?

Answer #6    Answered By: Mary Adams     Answered On: Aug 06

I got the same results.

You could remove the option to only see items you submitted and instead turn on content approval. You can then use alerts. Just never approve the items. It is a bit crude, but may be the only way to do what you are looking for.

Or you could allow anyone to see the comments (after approval) but set it up so no one sees who submitted the comments. I post about doing that here: heathersolomon.com/.../CustomLists.aspx#AnonList

Didn't find what you were looking for? Find more on Alerts Or get search suggestion and latest updates.