Sharepoint file / content when last accessed or viewed

Declare @SearchDocument nvarchar(max)
set @SearchDocument = N’abc/xy zz/efg.xls’;
SELECT TP_TITLE,TP_LOGIN,DOCLOCATION,OCCURRED,EVENT
FROM AuditData INNER JOIN USERINFO
ON AuditData.USERID = USERINFO.TP_ID AND AuditData.SITEID
= USERINFO.TP_SITEID
WHERE AuditData.DOCLOCATION LIKE @SearchDocument AND USERINFO.TP_ISACTIVE =1
order by OCCURRED desc

Reference

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s