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

3 comments:

Unknown said...

Excellent. It worked.

Unknown said...

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

Unknown said...

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