Jean Paul's Blog

There are 2 types of People in the World, One who Likes SharePoint and..

  • Microsoft MVP

  • MindCracker MVP

  • CodeProject MVP

  • eBook on SharePoint 2010

  • eBook on Design Patterns

  • eBook on Windows Azure

  • NLayers Framework @ CodePlex

  • MSDN Forums

  • .Net vs. Java

    Due to Public Demand

Posts Tagged ‘squadron’

Error : Unable to Delete Site : SharePoint 2010

Posted by Paul on June 28, 2013

I was working on a site moving, but the operation failed due to site template mismatch.  I ended up with a half-created site.

I can access the site through URL, but unable to access the site settings to delete the site.

image

I tried PowerShell Remove-SPSite approach, but it says it cannot find the site with url.

Solution

I tried to examine the problem using Squadron.  Luckily i was able to see the site there.  Then the rest is easy – created on Delete command which recursively delete sites & sub sites under.  It worked like a charm with Squadron.

Steps

Here are the steps involved to delete a site collection/site/list/library using Squadron.

Install Squadron

You can download the latest from http://www.sharepointcto.com/Squadron/

Install the application & run it from Start Menu > Programs > Squadron

image

Open the Explorer plugin from the left pane.

image

Locate the site to be deleted

image

Click the Delete button

image

Confirm site deletion

image

Great! Your defective site should be deleted now.

Summary

Here we have explored a rare scenario of defective site & deletion of it using Squadron.  You can use the tool for site collection deletion, list/library deletion as well

Posted in SharePoint | Tagged: , , , , | Leave a Comment »

Squadron – How to document site hierarchy?

Posted by Paul on April 30, 2013

Based on consultant requests, I have added the following functionality to Squadron.

· Document Site Hierarchy

What is Site Hierarchy?

Site Hierarchy represents the parent-child relationships between sites. A site can have number of sub sites under it. For example a site collection will be having SiteA, then SiteB under SiteA and so.

Site Collection

Site A

Site B

Site C

Let us see how to create such a documentation using Squadron.

clip_image002

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

clip_image004


Step 1: Open Squadron, Explorer

After installing Squadron, execute it from start menu. In the appearing screen enter the URL & choose Explorer add-in from the left.

clip_image006

Step 2: Expand Menu Item

Now right click on the Explorer root node, choose Expand > Up to Site menu item.

clip_image008

This will expand all the nodes up to Site. Please note that there are Site Collection, Site, List & Item types.

clip_image010

Now we need to discard the Library items from the display. We can do it in next step.

Step 3: Hide Menu Item

Right click again & choose the Hide > All Lists option.

clip_image011

This option will hide all the List items from the display.

clip_image012

This completes our Site Hierarchy Documentation. For exploring new SharePoint Installations, the above hierarchical view should be useful.

Note on Refresh

For retrieving the items back, you can use the Refresh menu item. You can even manually expand the nodes to view all children.

clip_image013

clip_image002[1]

Please note that the Menu is Context Sensitive. You can choose the particular node for the behavior.

References

http://www.sharepointcto.com/Squadron

Summary

In this article we have explored the Site Hierarchy Documentation feature of Squadron.

Posted in SharePoint, Uncategorized | Tagged: , , | 2 Comments »

Squadron – Active Directory Add-in

Posted by Paul on April 26, 2013

In this article we can explore about the Active Directory Add-in of Squadron.

What is Active Directory Add-in?

Active Directory Add-in allows quick lookup of the Active Directory users & groups. For SharePoint installations, Active Directory is the directory service which stores security objects. While working with Permissions, we need to explore the available users & groups in Active Directory. This Add-in helps with the functionality.

clip_image001

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

clip_image002

Types of Active Directory Groups

I would like to emphasize that we are mainly focusing on 3 types entities in Active Directory.

1. User

2. Security Group

3. Distribution Group

A User is an entity representing an individual user.

A Security Group represents collection of users representing usually a Department. (Vertical)

A Distribution Group will be an email distribution group based on location. (Horizontal)

In SharePoint, we can only assign Permissions to User & Security Group.


Generating Report

After installing Squadron, you can execute it from Start Menu > SharePointCTO > Squadron. On loading the primary screen enter your SharePoint URL in the top text box.

clip_image004

You can see that the Domain name is automatically fetched. If you need to change it you can do so.

Now, click on the Active Directory item from the left pane.

clip_image006

You will get the following screen.

clip_image008

Click on the Execute button to generate the report. The Highlight Disabled option highlights the disabled users/groups in red color.

clip_image010


Saving Report

For saving the report, right click on the Grid & choose from the options:

1. Save as Excel

2. Save as CSV

clip_image011

After saving, you can see the file opened in associated application.

clip_image013

Properties Window

We can also use the Properties Window on the right hand side to explore properties of user/group. Click on the grid item to view the properties in the right hand side.

clip_image015

This completes our Active Directory Add-in information. I hope you like the functionality & beautiful lookNfeel.

References

http://bit.ly/10uiVpB

Summary

In this article we have explored about the Active Directory Add-in of Squadron. I believe this Add-in would be another needy too in the hands of a SharePoint Explorer.

Posted in SharePoint, Uncategorized | Tagged: , , | Leave a Comment »

Squadron Diagnostics Add-in

Posted by Paul on April 25, 2013

In this article we can explore a new Add-in integrated into Squadron.

clip_image002

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

clip_image004

What is Diagnostics?

Diagnostics allows you to perform validations periodically. For example: Site Administrators run the following reports on monthly basis:

· Site Collection Size Information

· Permissions are set for Groups

· No obsolete workflows exists

· No obsolete alerts exists

· No dead accounts are in use

Etc.

How to view Diagnostics Screen?

After installing Squadron, you can execute it from Start Menu & click the Diagnostics item on the left side. Please ensure you entered the site url correctly.

clip_image006

I am explaining each of the visible Diagnostics items.


Dead Accounts

Dead Accounts are those with Active Directory Disabled Status. Periodically we might need to remove the dead accounts from SharePoint Permission Associations.

You can click the Execute button against Dead Accounts row to start the check.

clip_image007

If no problems found, the bar will be green. You can click the Details link for viewing further information. Using the Details screen we can manually locate the items & fix the problems.

Dead Alerts

Dead Alerts are those Alerts created by users & the users do not exists or being disabled. We can find the alerts through the Dead Alerts diagnostics item.

You can click the Execute button against Dead Alerts row to start the check.

clip_image008

If no problems found, the bar will be green. You can click the Details link for viewing further information. Using the Details screen we can manually locate the items & fix the problems.


Direct Permissions

Microsoft recommends Permissions to be assigned to SharePoint Groups instead of directly assigning to users. Groups enable more manageability, reusability & ease of clarity. We can find Direct Permission items through this diagnostic item.

You can click the Execute button against Direct Permissions row to start the check.

clip_image009

If no problems found, the bar will be green. You can click the Details link for viewing further information. Using the Details screen we can manually locate the items & fix the problems.

In the above case it is red and clicking the Details link, you can see the problem locations.

clip_image011

This concludes our overview of Squadron > Diagnostics.


References

http://www.sharepointcto.com/Squadron

Summary

In this article we have explored the Diagnostics Add-in of Squadron. Diagnostics are essentials to be executed on periodic basis like every one month. For SharePoint Governance enabled organizations, the need for more Diagnostics tools exists.

In future I hope to see more functionality integrated into Diagnostics add-in. You can also give inputs on your Diagnostics requirement.

Posted in SharePoint, Uncategorized | Tagged: , , , | Leave a Comment »

Squadron – Invalid URL Exception & Solutions

Posted by Paul on April 1, 2013

While working with the Explorer Add-in, you might receive the following error:

Invalid URL!

image

Problem

The Web Application object cannot be created using the URL specified.

Solution

You can try the following solutions:

1. Open Central Administration & Ensure the URL is correct

Open Central Administration > Manage web applications link

image

2. Execute the application from a Machine within Farm Environment & using the Farm Account.

In the Farm Machine, you an use CMD.EXE > RUNAS command to start Squadron in Farm Account context.

image

You can also try the http://localhost url within the farm environment.

 

clip_image002

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

clip_image004

Posted in C#, SharePoint | Tagged: , , , | Leave a Comment »

Squadron – Backup & Restore Permissions

Posted by Paul on March 31, 2013

In this article we can explore a new feature in Squadron for SharePoint 2010.

clip_image002

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

clip_image004

What is Backup & Restore Permissions Add-in?

This is a new add-in in SharePoint that allows backing up existing permissions in SharePoint securable object & restoring it elsewhere.

Following are the levels of backup possible:

· Web Application

· Site Collection

· Site

· List

· Item

Squadron also provides URL based filtering for backing up permissions. This will enable speed, context & reduce size of backup data.

What is contained in Permissions?

Following are the content of Permission:

1. Title

2. URL

3. User/Group Name

4. Members in Group

5. Owner if Group

6. Role Assigned

How to perform Backup?

Please follow the steps to perform backup:

Step 1: Execute Squadron

Execute Squadron from Start Menu > SharePointCTO folder. In the appearing scree se the URL.

clip_image006

Step 2: Click Permissions

From the left pane, click the Permissions item.

clip_image008

Step 3: Click Backup

Click on the Backup button in the appearing screen. You will get the following wizard.

clip_image010

Step 4: Check the Items

Expand the Web Application root item & Check the items to be backed up. You can right click & choose Check All command to check the sub items.

clip_image012

You can also use the Filter By Url on the bottom to filter by url.

Click the Next button to continue.

Step 5: View Permissions

In the next page you will see the Iterated Permissions as shown below:

clip_image014

The first column shows the Title of the Site / List / Item. The Type is displayed in the second column. The Url column is the key-column which will be used to identify the item uniquely.

The PermissionType column displays whether the permission is Unique or Inherited. The remaining rows contains the SharePoint Group / Domain User along with the role assignment.

Role Assignment can be Full Control, Contribute, Read or Custom Level.

Click the Next button to Save the file.

Step 6: Choose File

In the next page, choose the file name for saving the backup.

clip_image016

Step 7: Final Page

On clicking Next button you will see the last page which displays summary of the export.

clip_image018

It displays the number of web items, list items, library items along with unique/inherit permission types.

Click the Finish button to close the wizard.

Now we have successfully performed the Backup operation.

The file generated is in excel format & you may edit it for further optimizations. Please ensure the format of columns are retained.

Note: Please note that Folders (SPFolder) inside list/library are not included in permission backup.

How to perform Restore?

In the restore wizard, we are using a previous backup file to restore in a UAT/Production system. Click the Restore button from the Permissions Add-in.

clip_image020

You need to select the backup file in the next page.

clip_image022

In the next page you will be displayed the file contents as shown below:

clip_image024

In the next page choose the URL of the site to perform the backup.

clip_image002[1]

Please note that the URL column of backup file will be used to match the target items.

Please note that this feature is only available for SharePoint 2010.

clip_image026

On clicking Next you can see the matching URLs.

clip_image028

You can verify the Source Objects in file & the Destination Objects in the destination Site URL specified.

On clicking Next you will see the Confirm prompt.

clip_image030

Click the Yes button to continue..

The restore operation will be performed & you can see the result as shown below:

clip_image032

This concludes our Restore Operation.

References

Permissions & Permission Levels http://bit.ly/YoKoX8

Summary

In this article we have explore the new feature in Squadron 2010. I believe this feature will be useful in backing up existing permissions before applying new ones. The Backup & Restore can be applied combined in scenarios of UAT Backup & Production Restore OR vice-versa.

Posted in C#, SharePoint | Tagged: , , , | Leave a Comment »

Squadron Exception >> Unable to find SPDeletedSite…

Posted by Paul on March 29, 2013

While using Squadron you might have faced with following Exception:

image

The exception states unable to load type ‘Microsoft.SharePoint.Administration.SPDeletedSite’ from assembly ‘Microsoft.SharePoint, Version 14.0.0.0’ with Public Key Token

Description of Problem

The stated assembly should be registered in GAC (Global Assembly Cache) for working with Squadron.

Solution

As Squadron is built based on Server Object Model, it is expected to be executed in the SharePoint Server machine.

Following are the solutions recommended:

  1. Execute Squadron from a machine with the above Assemblies installed in GAC
  2. Install above Assemblies to GAC  (http://msdn.microsoft.com/en-us/library/dkkx7f79.aspx)

On Success

After solving the problem, you can execute Squadron again.  If the problem is resolved, you can see the Squadron Main Screen without any errors.

image

Posted in C#, SharePoint | Tagged: , , , | Leave a Comment »

Squadron – PowerShell Code Command

Posted by Paul on March 27, 2013

Observing the SharePoint Administrators, I found that they need a tool for examining problems with site/list/item objects & a PowerShell code to fix the problem.

As we already integrated Explorer with Properties in Squadron, I thought of easing their second step of using PowerShell code.

clip_image002

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

clip_image004

What does PowerShell Code button do?

You can see the PowerShell Code button in the Explorer add-in.

clip_image006

The command is only available for:

1. Site Collection

2. Site

3. List

4. List Item

On clicking the command (button) you will get the PowerShell Code to point to the item.

For example, I am selecting the Site Collection object & clicking the button.

clip_image008

You can see the code in above screen. The code can be directly pasted to a PowerShell Editor for execution or debugging.

You need to enter your custom code after the last line of generated code 🙂 The generator helps in saving time skipping the plumbing work.

You can even launch PowerShell & PowerShell ISE using the buttons displayed.

Generate List Item Code

Both List & Library are internally Lists for SharePoint. So the list items & documents are the same List Item. You can select the item as shown below.

clip_image010

Click the PowerShell Code button to generate code.

clip_image012

You can launch the PowerShell ISE and paste the code there..

clip_image014

This concludes our article on PowerShell code command in Explorer add-in.

References

http://bit.ly/10uiVpB

Summary

In this article we have explored a possible useful Add-in command option of Squadron. Please let me know about more functionality you need in Squadron.

Posted in C#, SharePoint | Tagged: , , , | Leave a Comment »

Squadron – Permissions Add-in

Posted by Paul on March 26, 2013

In this article we can explore the new Permissions Add-in inside Squadron.

clip_image002

Squadron is a Free Administrative Tool for SharePoint. You can download it from:

http://www.sharepointcto.com/Squadron/Default.aspx

What is inside Permissions Add-in?

Permission Add-in helps with the following tasks:

1. Find permissions of site level, list level, item level

2. Distinguish between Unique & Inherited permissions

3. Save Reports

4. Provides wizards for Find, Copy, Delete, Backup, Restore permissions

clip_image004

Types of Permissions

In a quick overview of Permissions, there are basically 2 types:

Unique Permissions where we assign unique users/groups & permission levels.

Inherited Permissions where the securable object (site, list, item) inherits permissions from its parent.


How to Generate the Report?

Let us examine the steps to generate a report for a site collection.

Step 1: Enter URL

Run Squadron & in the appearing screen, enter the URL of the site. Please note that you should run this in SharePoint Farm Account context.

clip_image006

Step 2: Open Permissions

From the left hand side click the Permissions link.

clip_image008


Step 3: Set Options

You can set the options in the appearing screen.

clip_image010

Site: To include site objects check this item.

List & Library: To include list & library objects check this item.

Item: To include items & documents check this item.

Expand Groups: A permission entry can be a SharePoint Group or User. If it is a SharePoint Group, you might need to include the users contained inside it. Check this item for including users.

Show User Name: The user item will be having a Login Name (eg: DOMAINuser) & a Display Name (eg: Full Name). You can choose this option to include the Display Name of the user as well.

Include Hidden: There could be hidden lists which are not visible in Quick Launch or in the All Site content page. Check this option to include those.

Unique Permissions Only: Check this option if you need only Unique Permission items.

Expand Inherited Groups: Usually the Inherited Permissions will be expanded in the parent object, as it is unique there. This checkbox enables you to expand the inherited groups too.

Filter By: Checking this option will enable a URL textbox where you can enter the URL to filter the result.

Highlight: Highlight Unique Permissions as Yellow & inherited ones as Green.

For the time being I have checked the following options:

clip_image011

Step 4: Generate

For generating the report, click the View Permissions from the left. You can see the result as shown below depending on your Site.

clip_image013

Step 5: Save Report

For saving the report, you need to right click on the grid & choose the option.

clip_image015

1. Save to Excel

2. Save to CSV

You may uncheck the option “Open after save..” if you do not wanted to launch your report file after save.

I have selected the option to save as Excel.

clip_image017

Enter the file name and click the Save button.

You will be viewing the file in Excel after saving.

clip_image019

This concludes our usage of Squadron Permissions add-in.

clip_image020

I wanted to iterate the Microsoft Recommendation of using SharePoint Groups instead of directly adding users to the site/list/item permissions. Groups are more easily manageable & easier understanding.

About the Wizards

The additional wizards are separately documented. Here is the screen shot of thee wizard screens.

clip_image022

References

http://bit.ly/10uiVpB

Summary

In this article we have explored about Squadron Permissions Add-in. I believe in real life scenario the add-in is useful in quickly analyzing a SharePoint site.

Posted in C#, SharePoint | Tagged: , , , | Leave a Comment »