SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Possible to loop through all Site Collection Users and check if they have ever logon into the Site Collection and when? db table dbo.UserInfo tokens info can be useful?

this script can retrieve the last domain logon, but is not enough.

Update: isActive flag in dbo.UserInfo set to 1 when user hits the site for the first time.

share|improve this question

similar question answered here: looks like its not as easy as it may sound!

Getting SPUser Last login date / time

share|improve this answer
I had read it before, actually is not really answered but it's a good point. Thanks for the aid. – fallout Oct 24 '13 at 11:26
up vote 0 down vote accepted

PSScript that access SQL table UserInfo, and for each site retrieves the users and according to the following metadata:

  • tp_IsActive (is 1, account active)
  • tp_ExternalToken and tp_ExternalTokenlastUpdated (if null, user never access)
share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.