Skip to main content

Peliqan

Try for free
Request a demo

SharePoint Site

List of users who have not logged in the last month

SQL query for SharePoint Site

Retrieve a list of users who have not logged into the site in the last month.

SELECT UserName FROM Users WHERE LastLoginDate < DATEADD(MONTH, -1, GETDATE())

Try this query now in SharePoint Site

SharePoint Site data model

SharePoint Site
Lists

SharePoint Site
Sites

Ready to get instant access to all your company data ?​

Connect 300+ sources, serve any BI tool, and give every AI agent one governed endpoint to read, and write back where the app supports it.

  • 14-day free trial
  • No credit card needed