SharePoint 2013 UserInfo Table

Question

Hello everyone,
I need to extract all users who have authenticated themselves on sites relating to a particular DB.

Is it correct to query the UserInfo and specifically the tp_ExternalTokenLastUpdated field?

In the explanations of "External" it is not clear to me what it refers to, for example it refers to users connected in VPN but belonging to AD or what? What is its significance?

Thanks a lot

Example of select that i use:

Select field1,field2, tp_ExternalTokenLastUpdated
from [WSS_example].[dbo].[UserInfo]
where tp_ExternalTokenLastUpdated > DATEADD (d,-90,SYSDATETIME())

Answer 1

Hi @Anonymous ,
According to my research, "External" should mean this:

For more information about UserInfo Table, please refer to this.

It is possible to search from the DB. It is recommended to add the following two fields:

 ,[tp_Login]  
 ,[tp_Title]  

Thanks,
Yanli Jiang

===========================================

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Thanks but whats means "An External Group Token"? On the link it is not clear.

That you know it is possible to query the tables of the DB or is it not recommended? For example, only SharePoint can do it exclusively.

Thanks a lot

Answer 3

Hello,
we're talking about SharePoint 2013, not 365 or others.

It doesn't seem clear what you wrote, the select on the UserInfo table gives me users belonging to the domain like this example:

All users are within domain. Any other indications?

In addition, can we perform the select on the db or we can't?

Thaks a lot.

Answer 4

Thanks, I got the answers that I expected.

The goodness of the query that I ran is validated by your additional information.

This additional information helped to understand the original question I wrote.

Best Regards