.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal

Home >> Articles >> SharePoint >> Post New Resource Bookmark and Share   

 Subscribe to Articles

What is Ensure User in Squadron

Posted By:Jean Paul       Posted Date: January 23, 2014    Points: 200    Category: SharePoint    URL: http://www.dotnetspark.com  

In this article we can explore a new command associated with Squadron > Explorer add-in.

In this article we can explore a new command associated with Squadron > Explorer add-in.

What is Ensure User?

Ensure User is the command that invokes EnsureUser() method for the SPWeb objects specified.

Why we need to call it?

For each new user in a web site, a user record is added to the User Info table. For new SharePoint installations, when the users login to the site first time, there will be simultaneous addition of records to the above table & might result in SQL Server Throttling error.

A wise advice for the problem is to add the user explicitly to each web site before the opening SharePoint to public.


Squadron is a Free SharePoint Administration tool available at www.sharepointcto.com.



How to perform Ensure User?

Please download & Install the latest version of Squadron. After executing it in Farm Account mode you will receive the following screen.


Enter the URL in the top pane & click the Explorer item from left pane. In the appearing SharePoint Web Application view, select you web item.


Click on the Ensure User button visible in the screen. In the appearing dialog enter the user names in the format DOMAINUser:


After entering the user names, click the Execute button in the bottom to continue. You will get the following message box after operation is completed.


This makes sure that the user is available in the UserInfo table for the particular web site. This will prevent the possible SQL Server Errors happening in SharePoint Installations with hundreds of users.


You can also invoke the Ensure User within the Web Application & Site Collection level. The same button will be enabled for those commands.

For Web Application item selection:


For Site Collection item selection:


On invoking the Ensure User command, all the Web items will be enumerated in the selection dialog. You can select the web items to be processed for.


Following is the code that performs the EnsureUser() method invoking.


foreach (string user in UsersText.Lines)
                if (string.IsNullOrEmpty(user))

                foreach (int i in WebList.CheckedIndices)
                    SPWeb web = WebList.Items[i] as SPWeb;

                        SquadronContext.WriteMessage("Success: " + web.ToString() + " " + user);
                    catch (Exception ex)
                        SquadronContext.WriteMessage("Failure: " + web.ToString() + " " + user + " " + ex.ToString());





In this article we have explore the Ensure User command. There are more commands associated with the Explorer Add-in of Squadron - plus, they are context sensitive based on Site / Web / List / Item types.

 Subscribe to Articles


Further Readings:


No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply
Find More Articles on C#, ASP.Net, Vb.Net, SQL Server and more Here

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend