Home >

SharePoint How to identify which user created a web site?

3. March 2011

SharePoint object model won’t help in identifying WHO has created a web site and WHEN it was created. However, a little sneak peak in the SharePoint content database will reveal this critical info.

Here is the sample SQL script that will show the user and creation date of any given site:

   1: select u.tp_login, u.tp_title, w.title, w.fullurl, w.timecreated, w.lastmetadatachange
   2: from webs w, userinfo u 
   3: where title like '%<site title here>%' 
   4: and w.author = u.tp_ID;

Add comment

  Country flag

biuquote
  • Comment
  • Preview
Loading