Wednesday, October 23, 2013

SQL Query to find Last Access Date for a site ollection in Content Database

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

No comments:

Post a Comment

SharePoint 2013 - ADFS - Configuration

The main objective of this post is to provide detailed configuration steps on how to set up SAML Authentication for SharePoint 2013/2016 w...