WSS 2.0 Backup and Restore Links

Searching Alerts of Users in SharePoint Portal Server 2003 DBs

Today I was working for a user request who has received some alerts which are around 1.5 years old.  This happened due to some problem with the SPS topology of our client which we fixed yesterday so we were expecting some alerts gone to users so I was trying to search where can I go and delete the alerts for the user.  You will be amazed to know that there is no place in SharePoint Portal Server 2003 to find a specific alert and turn it off.  So I decided to switch to DB for that.  here are the steps to find the Alert

1. Get UserGUID by using Preferred name from UserProfie Table in Profile DB and copy it.

SELECT     *
FROM         UserProfile
WHERE     (NTName = ‘Domain\UserName’)

2. Get Alerts of Users by using UserSubscriptions Tables of Serv Database using the following query

SELECT *, userId AS UserGUID
FROM sub_UserSubscription
WHERE (userId = ‘{A8E9B020-BD66-4FD3-8826-6002DAE3FCE1}’)

you will get the alerts for the user.

3. Now if you wanted to confirm the alerts by checking it site, alert type and other details simple use a Inner Join to Table Subscription Details and check the Subscription ID in both the tables.  You will see the details in the rows.

SELECT *, sub_UserSubscription.userId AS Expr1, sub_SubscriptionDetails.subscriptionId AS Expr2
FROM sub_UserSubscription INNER JOIN
sub_SubscriptionDetails ON sub_UserSubscription.subscriptionId = sub_SubscriptionDetails.subscriptionId
WHERE (sub_UserSubscription.userId = ‘{A8E9B020-BD66-4FD3-8826-6002DAE3FCE1}’)

Execute the query and the result will be given below.


Migration Project Completed

Finally I am back to normal after 2.5 month of complete madness.  The SharePoint Server 2007 Migration project that I was doing for one of our client is completed on Tuesday morning.  The project involves Upgrading SharePoint Portal Server 2003 to MOSS 2007.  The length of the project was very much shrink from 5 months to 2.5 months just to get the next Project (Phase II) … Business deal.  Below are the details are the project that we completed.

Content Database Size : 26 GB

Custom SharePoint Server Templates : 20

Custom Lists and Library Features : 15

Upgrade Definition Files :20

A complete UI Upgrade to SharePoint 2007 Master Pages and CSS

Extensive use of SharePoint 2003 Issue Discussion (Migrated through Object Model)

20+ Custom Webparts completely re-developed

4 Custom Layouts

We had used Side by Side upgrade approach for this project.  The bad thing about SharePoint 2007 migration is that we can not predict that Migration can go smoothly without any issue.  If at some point migration fails you have to go back revert the site and have to come back again Which is some times time taken and very disturbing.  We got 48 hours windows of Server downtime which we successfully managed and completed the project.  From last two days we have not got any issue or help desk request from the end users. 

I have learned a lot from this project and will try to share my experience.