Tuesday, December 7, 2010

Using SQL QUERY to Find Out Site Created & Last Access Date

SQL QUERY:

Use Content Database Name

GO

SELECT FullUrl AS 'Site URL', TimeCreated,
DATEADD(d,DayLastAccessed + 65536, CONVERT(datetime, '1/1/1899', 101))
AS lastAccessDate FROM Webs WHERE
(DayLastAccessed <> 0) AND (FullUrl LIKE N'sites/%') ORDER BY lastAccessDate
at

3 comments:

  1. UnknownDecember 10, 2015 at 11:31 AM

    Excellent. It worked.

    ReplyDelete
  2. UnknownSeptember 6, 2016 at 4:22 AM

    No results, there is no table named to Webs in the content database.

    ReplyDelete
  3. UnknownMay 19, 2017 at 3:47 AM

    HI Please Suggest How to get Last Accessed Root Site in sharepoint 2010

    ReplyDelete