locked
SharePoint Sites Creator RRS feed

  • Question

  • Hi All,

    Is there a way of knowing who (which active directory user) has created a SharePoint site?

     

    Many Thanks

    Lewis

    • Moved by Mike Walsh FIN Friday, July 15, 2011 10:54 AM admin q (maybe solved by programming but for now it's admin and certainly not general) (From:SharePoint - General Question and Answers and Discussion (pre-SharePoint 2010))
    Friday, July 15, 2011 10:07 AM

Answers

  • Hmm,

    Go to your central administrator and go to Operations --> Default database server.

    This will provide you the server and also the instance of the database.

    Now you can login into this server and connect the instance. Once connected you can break the node of the databases and then can select the content database holding your site.

    Then you can click on New Query and then you can type following query:

    Select * From Webs With(NoLock)

    Then press F5 or click on execute button you will get your results.

    I hope this will help you out.

    Thanks,

    Rahul Rashu

    Friday, July 15, 2011 6:02 PM

All replies

  • HI,

    Follow these steps:

    1. Login to the content databse of the site.

    2. You can get the above information from central administrator.

    3. Go to web table

    4. Locate the row containing your site

    5. Check the author value . This will be an integer corresponding to the user id who has created it.

    6. To convert this to the user ID again login into your site. Go to all people.

    7. Click on any user ID.

    8. In the page that opened after it change the ID in URL to the value you have got from database.

    Thats it.

    I hope this will help you out.

    Thanks,

    Rahul Rashu

    Friday, July 15, 2011 12:07 PM
  • Hi there,

     

    thanks for your reply.  How do i log into the content database of the site though?

     

    Lewis

    Friday, July 15, 2011 2:08 PM
  • Hi Lewis,

    If you have permissions - you can connect to the SharePoint database through the SQL Server Management Studio (SSMS - you may have to install that on the client machine).

    Here is another way of doing this - http://blogs.msdn.com/b/ketaanhs/archive/2010/03/13/how-to-find-who-created-a-site-on-a-moss-2007.aspx

    You can also check the site's owner's group - if there is only only 1 person listed there - that person must have created the site. This may not be accurate all the time - as you may add more people in this group after creating the site. As you know when you create a site it automatically adds you to the Owner's group.

    Hope this helps!


    BlueSky2010
    Friday, July 15, 2011 5:28 PM
  • Hmm,

    Go to your central administrator and go to Operations --> Default database server.

    This will provide you the server and also the instance of the database.

    Now you can login into this server and connect the instance. Once connected you can break the node of the databases and then can select the content database holding your site.

    Then you can click on New Query and then you can type following query:

    Select * From Webs With(NoLock)

    Then press F5 or click on execute button you will get your results.

    I hope this will help you out.

    Thanks,

    Rahul Rashu

    Friday, July 15, 2011 6:02 PM
  • Hi Guys,

     

    Thanks alot, the Select function did the trick perfectly.

     

    Many Thanks

    Lewis

    Monday, July 18, 2011 10:27 AM