SPUser have logon into Site Collection?

Question

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.

Answer 1

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

Getting SPUser Last login date / time

Answer 2

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)