none
List of Users and the site they have last accessed in SP 2013 RRS feed

  • Question

  • Hi Team,

    I would like to fetch the info, list of users who logged in last 3 months and the site they have accessed in SharePoint 2013.

    I have fetched users info with last login date using below query but not able to get the site/URL info which they have accessed?

    SELECT [tp_SiteID]

        ,[tp_Login]

        ,[tp_Title]   

        ,[tp_ExternalTokenLastUpdated]

    FROM [TFS_Contentdb].[dbo].[UserInfo]

    --Where tp_Login='i:0#.w|domain\username'

    order by [tp_ExternalTokenLastUpdated] desc


    Raj

    Tuesday, July 30, 2019 5:12 PM

All replies