Getting last accessed date of sitecollection/sites

Question

How to get last access date of any site collection/sites in SP2013?

I tried using Powershell, but we can only get lastItemModifiedDate Property or lastContentModifiedDate. Please suggest which is the best way to get the date "last access date" by users?

Answer 1

The last access date can't be queried through PowerShell, as the values of such are stored with an associated SQL database and initially created by the Windows Server's IIS. So in another words you are interested in IIS logs.

last access date/time for sharepoint site collections topic from MSDN forums has a suggestion regarding the site collections.

A pseudo-code version (where you'd need to fill in your data table's name and URL):

SELECT max(date)
FROM IISLogs
WHERE url like 'http://server/sites/sitecollection%'

And a bit advanced query

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

(Source: Last access date/time for SharePoint site collections)

Answer 2

To my knowledge there is no last accessed date variable stored in the site collection.So I do not think you can get that using PowerShell .

You can look into logs to check for last request for that particular site collection

Answer 3

You could also try the PowerShell Commands which are given in the following articles to find out last accessed date.

Find unused sites based on Last Modified Date

pyaarey.wordpress.com/2012/11/17/find-unused-sites-based-on-last-accessed-date/

Get Last Accessed date for a site

blogs.msdn.microsoft.com/varun_malhotra/2010/05/11/moss-2007-get-last-accessed-date-for-a-site/

Last Accessed Date for a Site Collection

https://danieljroberts.wordpress.com/2011/09/05/usage-data-in-sharepoint-powershell-retrieval/

Additionally, you can try this automated solution ( https://www.lepide.com/lepideauditor/sharepoint-auditing.html ) which grants access to only specific reports to be accessed.