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:
Excellent. It worked.
No results, there is no table named to Webs in the content database.
HI Please Suggest How to get Last Accessed Root Site in sharepoint 2010
Post a Comment