Learn more about SQL Server tools

mssqltips logo
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 

Using SharePoint Alerts


By:   |   Read Comments   |   Related Tips: > Sharepoint

How to Quickly Resolve Performance Problems for the IIS .NET and SQL Server Stack


Problem

SharePoint is a great collaborative environment. Our work teams love to share information and documents using an easy, intuitive web interface. It would be great if there was a way to get automatically notified whenever someone else changes or adds information. Is there a way to do that?

Solution

Yes! The simplest way is to use the built-in SharePoint alert system. SharePoint alerts allow users to selectively choose a library or list (or even an individual document or list item) to receive alerts from. Alerts come in the form of an email notification with a brief description about the item along with a link to it.

Here's how it works:

In this example, a document library called "Jazz Records" is used.

The user clicks on the "Actions" menus and selects "Alert Me".

The user decides on which alert options are suitable. It's tempting to choose "immediately", but unless it's a time critical function, daily or weekly summaries work quite nicely. These options are editable afterwards, so not to worry.

Immediately, the users receives an email that confirms that an alert was setup. It shows which resource (library or list) was selected and provides links to the resource and a page to change the alert options. Don't worry about losing or deleting this email...there's another way to check up on things. Read on...

After (anyone) uploads a ..jpg image called "01 Action-Alert Me.jpg, the user receives an email alert informing them that a new document has been "added", with various useful links.

Now here's the big surprise! In Outlook, select "Rules and Alerts..." from the "Tools" menu. Normally Outlook rules are managed here. I never thought anything about the "and Alerts..." until I stumbled on this one day.

Click the "Manage Alerts" tab. (Get ready!)

Alas, all SharePoint Alerts are displayed in one option-filled management screen, right in Outlook!

If a site administrator wants to review and edit alerts that were created on a particular site, they go into "Site Settings".

Click on "User Alerts".

Choose the user from the drop down and click "Update".

This shows the resource (in this case a document library) and the frequency of the Alert. Administrators can delete user alerts from this page.

Next Steps


Last Update:


signup button

next tip button



About the author
MSSQLTips author Rob Fisch Rob Fisch has worked with SQL Server since version 6.5 as a dba, developer, report writer and data warehouse designer.

View all my tips





Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Notify for updates 


SQL tips:

*Enter Code refresh code     



Learn more about SQL Server tools