Articles in this section

See more

Determine UserID connection to Active Directory

Avatar
Dave White
Updated
Follow

First, figure out the UserID.

In my example, I'm looking up the UserID for the login ban

Select * From [Davidw3_PortalFX].[dbo].[PWUser]

​

Now, look up the SID connected to the UserID

Select * From [Davidw3_PortalFX].[dbo].[PwWindowsUserMapping]

​

Once we have the SID, we can look it up in the active directory and see if they match. The SID is in hexadecimal
​

Related articles

Comments

0 comments

Please sign in to leave a comment.