Gino Abraham's Blog

User Principle Name

SQl Query to check whether User Principal Name is Blank in SharPoint User Profiles DB

User Principal Name /UPN is a property which is mandatory in SharePoint 2013 for Workflows and Provider Hosted Apps to work fine. When you employ a third party profile sync tool or a custom built one, the below SQL query will be quite handy to check whether the User Principal Name property is populated or not. SELECT dbo.UserProfile_Full.UserID, dbo.UserProfile_Full.NTName, dbo.UserProfileValue.Proper... dbo.UserProfile_Full WITH (NOLOCK) INNER JOIN dbo.UserProfileValue WITH (NOLOCK) ON dbo.UserProfile_Full.Partit... ......