locked
Fetch Sharepoint portal server 2003 user alerts from Database RRS feed

  • Question

  • Hi All,

    I have a requirement where I need to fetch sharepoint portal server 2003 alerts from Database.

    We have tried to access it through web services, stsadm, etc. but without success. We know that the Alerts are stored in the MySite portion of SPS 2003, which I believe is part of the Sitename_PROF database. SharePoint Portal Server 2003 creates three DBs for every portal created: for example – Sitename_SITE (contains the data), Sitename_SERV, Sitename_PROF (Profile Information).

    The task will be to fetch the information from database in a way that will allow us to recreate them on SP 2010.

    So please let me know it is possible to fetch information such iformation from database or not or in case have any other alternative then please shareit with me.

    Thanks !!!

     

     

     

     

    Wednesday, December 19, 2012 5:08 PM

Answers

  • How are you migrating your content?  If you're using a migration tool, then you may be able to get this to transfer / recreate the alerts for you.

    If not, you'll be looking at the following tables;  ImmedSubscriptions or SchedSubscriptions tables in the content database. In the SchedSubscriptionstable there are additional columns to handle the timing of alert delivery.

    I suspect you can run a few queries agaiinst these to find what you need but I've never tried it.


    Steven Andrews | SharePoint Professional | http://www.twitter.com/backpackerd00d | https://baron72.wordpress.com/


    • Edited by Steven AndrewsEditor Thursday, December 27, 2012 12:22 PM Cleaned up the Grammar
    • Marked as answer by BPAdmin2013 Friday, December 28, 2012 1:25 PM
    Friday, December 21, 2012 3:16 PM
    Answerer

All replies

  • How are you migrating your content?  If you're using a migration tool, then you may be able to get this to transfer / recreate the alerts for you.

    If not, you'll be looking at the following tables;  ImmedSubscriptions or SchedSubscriptions tables in the content database. In the SchedSubscriptionstable there are additional columns to handle the timing of alert delivery.

    I suspect you can run a few queries agaiinst these to find what you need but I've never tried it.


    Steven Andrews | SharePoint Professional | http://www.twitter.com/backpackerd00d | https://baron72.wordpress.com/


    • Edited by Steven AndrewsEditor Thursday, December 27, 2012 12:22 PM Cleaned up the Grammar
    • Marked as answer by BPAdmin2013 Friday, December 28, 2012 1:25 PM
    Friday, December 21, 2012 3:16 PM
    Answerer
  • Thanks much Steven,

    Let me try to work on queries to find alert data from database and will update you soon on same.

    Thursday, December 27, 2012 8:39 AM