We use FBA and currently have 500+ FBA users, we also use the FBA management pack from CodePlex. New user requests come in all the time for new users and adding users to roles. The issue our helpdesk face's is that the users already exist or are already in the role the end user has requested. This results in our helpdesk spending a great deal of time searching the name and then clicking within the users account and scrolling down all the roles to see if the tick box is ticked. When you have 40 to check it takes a long time. I have created a page using external content types and have made it so end users can now search themselves to see if the account or role is created\added. The only thing I am missing is the Full Name field\column! I cannot see it in any of the tables in the FBA DB. Where is this stored? Thanks
The value for Full Name is not stored within the Membership Database, per the solution
SharePoint 2013 FBA Pack. The value of Full Name is used to add the user, once created in the
aspnetdb, to the SharePoint site itself.
/// Adds a user to the SharePoint (in no particular group)
/// <param name="login"></param>
/// <param name="email"></param>
/// <param name="fullname"></param>
private void AddUserToSite(string login, string email, string fullname)
You may want to use a
Stored Procedure on the
aspnetdb to query for the value.
EXEC dbo.aspnet_UsersInRole_IsUserInRole @ApplicationName = '/', @UserName = 'firstname.lastname@example.org', @RoleName = 'MyRole'
You will need to adjust the values, and the
Application Name can be found in the
web.config of the SharePoint Web Application under the