In this article I would like to introduce you to the Explorer (Old Site-Structure) Add-in of Squadron.
What are the advantages of Explorer?
Using Explorer we can quickly generate the Site Collection, Sub sites, Lists & Libraries, Items in hierarchical manner. The information is useful in analyzing a site collection.
We can also view in Grid Style where the above objects are displayed in Rows with facility to export too.
Squadron is a Free SharePoint 2010 Productivity tool deployed using ClickOnce technology. You can install it from following location.
How to generate the Structure?
Install the Squadron application & execute it using the Desktop short cut. You will get the following screen.
Now click on the left pane named Explorer. You will get the following Site Structure screen.
Enter the Web Application URL in the URL textbox of the header. Click the Execute button to generate the site structure as shown below:
Please note that you can include Lists & Libraries by checking the Show Lists, Libraries checkbox. Additionally you can include Items & Versions using the Show Items, Show Version Count Checkboxes.
Following is the result after generating Items & Versions.
Please note that the versions are displayed within Parenthesis.
We can also generate Grid Style using the Grid Style checkbox.
Now click the Execute button again.
Export to Excel
For saving the rows, right click & choose:
1. Export to Excel
2. Export to CSV
After saving, the file gets opened inside Microsoft Excel. You may uncheck the Open after save option if you do not prefer automatic launching of file after saving.
CSV option is also good but if you have COMMA (,) character in the names of Site, List, Items the generated file will be confusing.
The hidden lists checkbox allows you to include Hidden Lists in the result. Hidden Lists are those not displayed in the Quick Launch bar as well as the System Lists.
We can examine each item properties further using the Property Grid. For example you wanted to view:
· Allow Designer property of site collection
· Allow Unsafe Updates property of site
· Allow Deletion property of List & Library
You can view these properties by clicking the result item; the Properties will get displayed in the right side.
Following is the code to generate the Hierarchy information.
Following is the main method:
private void GenerateHierarchy(string url)
SPWebApplication webApp = SPWebApplication.Lookup(new Uri(url));
_rootNode = tv.Nodes.Add(webApp.Id.ToString(), GetDisplay(webApplication), 0, 0);
_rootNode.Tag = webApplication;
foreach (SPSite site in webApp.Sites)
TreeNode node = _rootNode.Nodes.Add(site.ID.ToString(), GetDisplay(site), 1, 1);
node.Tag = site;
node.ToolTipText = “Site Collection”;
if (_rootNode != null)
For iterating webs, the following method is used:
private void IterateWebs(SPSite site, TreeNode parentNode)
foreach (SPWeb web in site.AllWebs)
if (!web.IsRootWeb) parentNode = GetParent(web.ParentWebId.ToString());
if (parentNode == null) parentNode = _rootNode;
TreeNode node = parentNode.Nodes.Add(web.ID.ToString(), GetDisplay(web), 2, 2);
node.Tag = web;
node.ToolTipText = “Site”;
For iterating Lists, following is the method:
private void IterateLists(SPWeb web, TreeNode parentNode)
foreach (SPList list in web.Lists)
if (list.Hidden || !list.OnQuickLaunch)
int imageIndex = 3;
if (list is SPDocumentLibrary)
imageIndex = 4;
TreeNode node = parentNode.Nodes.Add(list.ID.ToString(), GetDisplay(list),
node.Tag = list;
if (list is SPDocumentLibrary)
node.ToolTipText = “Library”;
node.ToolTipText = “List”;
For iterating Items, use the following code:
private void IterateItems(SPList list, TreeNode parentNode)
foreach (SPListItem item in list.Items)
TreeNode node = parentNode.Nodes.Add(item.ID.ToString(), GetDisplay(item), 5, 5);
node.Tag = item;
For finding Root Web of a site, following method is used:
private SPWeb GetRootWeb(SPWeb web)
SPWeb result = web;
while (result.ParentWeb != null)
result = result.ParentWeb;
In this article we have explored the Site Structure Add-in in Squadron. I believe this would be a helpful tool in your bag while visiting a new SharePoint customer.
You can download & use Squadron for Free, if you face any installation problems, please let me know.