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.

2 Answers 2


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

Getting SPUser Last login date / time

  • I had read it before, actually is not really answered but it's a good point. Thanks for the aid.
    – fallout
    Oct 24, 2013 at 11:26

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)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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