Hi, I have a case where one particular user is not receiving alert emails for a particular doc library. Any help or further insight will be appreciated. Here's some background and steps I've already taken to investigate/correct the issue: MOSS 2007 SP 2 farm, multiple WFE servers, MOSS 2007 SP1 was the original install to this farm. This user is able to receive the confirmation email after the alert is initially created. It is just the alert emails that are not being received. The alert was created using the immediate notification setting. This same user, user A, is also able to receive the confirmation email and subsequent alert emails from another site collection (different content DB) on the same web app of the same farm. That alert was created using the immediate notification setting. Another user, user B, is able to receive the confirmation email and subsequesnt alert emails from the doc library that user A is not. User A has contribute permissions on the doc library the alert was created for, User B has full-control permissions. Executed the query "select * from eventcache where eventdata is not null" against the related content database. The query returned 0 results. Verified that the Windows SharePoint Services Timer service is running on the index server and all WFE servers. Checked the Timer Job Status in Central Admin and all statuses = succeeded and all progresses = 100% Asked the Exchange admin to search for the missing alert email, he was unable to find the alert email (searching by subject line) for user A but could find that alert email for user B (showing it was received and delivered to user B). Stsadm -o getproperty -pn alerts-enabled for the problem site returns <Property Exist = "Yes" Value = "Yes" /> Stsadm -o getproperty -pn job-immediate-alerts for the problem site returns <Property Exist ="Yes" Value = "every 5 minutes between 0 and 59" /> Based on the above, do I look into Exchange (if so what/where)? Or look into SharePoint (if so what/where)? Since I can confirm that the alert in question was sent to user B, is there a way for me to search for that alert within the content DB and confirm it was also created for user A?

The first step in troubleshooting an error like this is to browse through the ULS logs that SharePoint creates. You can specifically tell SharePoint to log all events for alerts and such. You can find more details here: http://technet.microsoft.com/en-us/library/cc288649%28office.12%29.aspx These logs will contain lines that will tell you if emails were sent out, and if changes occurred that prompted alerts. What happens if you manually sign up User A up for an alert on that document library as the site admin? http://donahoo-development.com

Hmm, searching through the log files for keywords from the email subject line, site name, library name, username didn't return any relevant matches. Then again, I also didn't see any signs in the logs that emails were sent out (and I know one user did receive the alert email); what cofigurations are required to record those event details?

Okay, after reconfiguring the settings for diagnositic loggins and running a new test I found the following entry for the correct time sequence: "Alertsjob results for immediate delivery: 12 prematches, 6 passed filtering, 3 of 6 passed security trimming, 3 final after rollup" I understand that filtering refers to filtering for Exchange rules and security trimming refers to SharePoint checking that the user has permissions to access the item. But how do I find what filtering is being done for Exchange? Also, is there any way to see which 6 did not pass Exchange filtering and which 3 did not pass security trimming? Thanks.

Other than monitoring the database tables for SharePoint's notifications (specifically ImmedSubscriptions Table , I'm not sure how to find out what kind of filtering SharePoint does on the actual alert results, or what results didn't pass the filter. It could be filtering based on whether or not the email is internal or external: http://patrickfeltz.spaces.live.com/blog/cns!41A4F8DC87858F8F!197.entry?sa=985011218 Also, double check the user's email address in SharePoint's user list to make sure it is an internal email address, and that it's correct.http://donahoo-development.com

Carl, quick question for you. Are any of your sites migrated or imported sites from WSS 2 / SharePoint 2003?http://www.final-exodus.net

Hi Steven, sorry for the delayed response. Nope, nothing was migrated or imported from WSS 2. So far this issue hasn't reoccurred again which I find strange, but maybe someone else made a change to our email infrastructure or security w/o my knowing.