Disabling SharePoint Designer access in Office 365

SharePoint Designer is a free tool from Microsoft that allows you to make modifications to SharePoint sites. It can allow you to make changes down to the code and HTML level. That is great if you know what you are doing, however if you don’t you can cause irrevocable damage to SharePoint.

In most cases, this means you want to keep users away from using SharePoint Designer, however Office 365 by default provides the option to download SharePoint Designer right from the console as you can see:

 image

It is located in the Software section of all users Office 365 portal under the tools & add-ins.

As an administrator it is possible to disable this. Here is the procedure.

Login to the Office 365 portal as an administrator.

image

From the menu on the left hand side select service settings.

image

From the menu across the top select user software.

image

At the top of the page you’ll find the option to Manage user software through Office 365. In this section you can uncheck SharePoint Designer and then press the save button. You’ll also notice that you have the option to prevent users from also downloading Office and Lync (if it is part of their plan).

image

The next time a user accesses their console and goes to Software and tools & add-ins they will see a message:

The administrator has disabled SharePoint Designer 2013 installations. Contact your administrator for information about how to install SharePoint Designer 2013.

Unfortunately, this is not the only way that a user can download SharePoint Designer. They can of course download it directly from the Microsoft download site here:

http://www.microsoft.com/en-au/download/details.aspx?id=35491

So what can you do if users download SharePoint Designer themselves and attempt to modify SharePoint? Luckily, SharePoint has the ability to disable operation within individual SharePoint site collections. Unfortunately, if you have multiple site collections (M or E plans generally) then you’ll need to make the following changes on each site collection.

image

Login to the site collection you wish to change as an administrator.

image

In the top right of the window press the ‘cog’ icon to reveal the above menu. From this select Site Settings.

image

In the bottom left, under Site Collection Administration, select SharePoint Designer Settings.

image

Unselect all the options listed. By doing so you will remove the ability for ALL users (administrators included) to use SharePoint Designer on this site collection.

You will note that by default only Site Owners and Designers can edit sites using SharePoint Designer. Most users are only Site members, so they “shouldn’t” be able to using SharePoint Designer on a site. However, if you want to 100% sure that NO ONE can use it then uncheck all the options here.

Press the OK button to save and changes made. You will be returned to the Site Settings page.

The following Microsoft Support Article provides more information as well:

http://support.microsoft.com/kb/2592376

SharePoint 2013 tasks are cool!

One of the things that I’m waiting on for clients here is the availability of Project Online. In the meantime I have been been playing with the inbuilt Tasks in SharePoint 2013, and I gotta say they are HUGE improvement. Here’s some reasons why.

image

If you go into a Tasks area of SharePoint Online you’ll see something like that shown above by default. If we now add some tasks by clicking the new task hyperlink we’ll see:

image

Once we add the basic information we press Save.

image

You should now see a single task listed. But if you now select the ellipse (the three dots to the right of the task name) you get a flyout, as shown above, that gives more information about the task (like how many days till it is due).

Along the bottom you’ll also find a menu, which if you select Create Subtask, will:

image

switch you into data sheet mode allowing to enter tasks like you would in a spreadsheet.

image

as you complete the first additional task SharePoint will prompt you that it is automatically adding this task to the timeline above. You’ll need to do any others manually after the task has been created.

image

Let’s say the we continue on and create a third task and then switch back to the All Tasks view like shown above. In doing so we find that Task 3 has been created as a subtask of Task 1. We want Task 3 to be at the same level as Task 1 (i.e. not a subtask).

No problems, simply select the task by selecting the left most column for that task, the ribbon menu will then appear. In the middle of the ribbon is the Outdent button. Selecting this will move Task 3 to the same level as Task 1. Brilliant!

image

You’ll also notice that when there is task that is past its due date and not complete it automatically turns red as shown above for the Preparation task.

You’ll also notice that I have placed all the tasks on the time line at the top of the page, which you can do from the Ribbon Menu.

image

If I now click on the overdue task (Preparation) on the timeline at the top you’ll see a flyout appear as shown. Again, note that the days due is red since it is overdue. You will also notice that the Ribbon Menu is displayed.

At the left of the Ribbon Menu you will find a number of formatting buttons (Bold, Italic, UnderLine, Fill, Font colour etc). You can use these to change the way the item on the time line appears like so:

image

So here I have customized every task on the timeline expect the last one so you can see the difference.

You’ll notice that because Task 1 (in purple) over laps Task 2 (in green) the time line has two rows. If you select Task 1 (in purple) the Ribbon Menu appears and

image

selecting the button Display as Callout that tasks moves to an item outside the timeline as shown above.

I can once again edit the formatting of this task to increase the font size and so on as before.

image

Even better that than, I can now drag and drop that task anywhere on the screen if things are becoming cluttered. To demonstrate, in the above screen shot I have dragged the task to the lower right. When I do that the page automatically formats to make room. How cool is that?

So if you have lots and lots of tasks you can have some on the timeline and some as callouts which you can then position all over the page so you can easily see them all.

The takeaway here is that if you haven’t looked at what the new Tasks area can do in SharePoint 2013 I would. For most people this is going to work really, really well for project management. I am still, however, hanging out for Project Online because if this is what the generic tasks can do, just image what Project Online could do! I can’t wait.

SharePoint Online eDiscovery

One of great new features of SharePoint 2013 is eDiscovery. eDiscovery is the process of discovering (locating) electronically stored information that is relevant to litigation, audits and investigations. With SharePoint Online (Plan 2) this comes already configured. For more information about eDiscovery in SharePoint 2013 start here:

http://technet.microsoft.com/en-us/library/fp161516.aspx

However, I’ll at least show you how to get started with SharePoint Online in this post.

image

The first steps with eDiscovery in SharePoint Online are to create a seperate eDiscovery site collection. To do that, login to the Office 365 portal as an administrator and select SharePoint from the Admin menu in the top right as shown above.

image

You should now see all the site collections you have configured for your tenant.

image

In the top left select the New button and then private Site Collection from the menu that appears.

image

Give the site a meaningful name (here eDiscovery) and URL (here eDiscover). and then select the Enterprise tab in the Template Selection area. In there you should find an option eDiscovery Center, select this.

Complete the remaining information for the site and press the OK button to create the site.

image

After a few minutes the site will be created and you can browse to it. When you do you should see something like the above. To get started press the Create new case button on the right.

image

You’ll now be prompted to create a new site. Thus, for each ‘eDiscovery case’ there will be a unique subsite below the eDiscovery home site.

Give the new case site a name and URL as shown above. The only site template option you have is eDiscovery.

Scroll down for more options.

image

Complete the remaining options and press the Create button.

image

You should now see the new case site as shown above.

The next step is to configure the eDiscovery Sets for this case (i.e. where to look for information).

Press the new item hyperlink underneath the eDiscovery Sets at the top of the screen.

image

In the eDiscovery Set you need to give it a name and then select the Add & Manage Sources hyperlink next to Sources.

image

Here you can select both Exchange mailboxes and SharePoint sites to search through.

Add the desired locations and press the OK button to save.

image

Once you have defined the sources to search through you need to create a query for these locations, and you can have multiple queries if you want. To create a new query select the new item hyperlink just under the Queries heading on the case home page.

You can give the query a name and then enter in the terms you wish to search for as shown above. if you press the Search button on the right hand side you will see the results below, again as shown above.

So, that’s the basics of eDiscovery with SharePoint Online. Pretty powerful but yet easy to set up and configure. It is my firm belief that we’ll see more and more eDiscovery requests as we move into the future so having that built-in ability is fantastic benefit of SharePoint 2013 and a great opportunity to understand how to make it really perform.

SkyDrive Pro client now available for free

In an not unexpected move Microsoft has just release the SkyDrive Pro client as a free download. You can find it here:
http://www.microsoft.com/en-us/download/details.aspx?id=39050
Previously, as I have detailed in this blog, the only way that you could obtain the client app was by installing Office 2013 Pro Plus.
This is GREAT news as it makes SharePoint SkyDrive so much easier and available for all users! The SkyDrive Pro client app although now free is still only available for current Windows PC’s but I would expect you’ll see versions for other platforms available very, very soon. So stay tuned to this blog for updates!
Thank you Microsoft.

A beginner’s guide to SharePoint Online

Microsoft runs a regular Office 15 minute webinar and recently it focused on SharePoint Online. You can find the video at:

If are interested in getting started with SharePoint Online this video will give you a brief overview. Once you have watched that you can also check out the CIAOPS SkyDrive Pro Primer video:

There are of course plenty of other SharePoint and Office 365 publications over at:

http://www.ciaops.com/publications

So take a look, however if you haven’t looked at SharePoint and especially SharePoint Online then I’d strongly recommend you do.

Connecting PowerShell to SharePoint Online

image

So you have configured your environment to have PowerShell connect to Office 365 using my previous blog post:

Configuring PowerShell access in Office 365

However, this only used to provide access to tenant and Exchange administration. With the Wave 15 release of Office 365 you can now also connect to SharePoint Online. here is how to do just that.

You are going to need a machine that has the Windows Management Framework 3.0 installed, which basically means you need PowerShell version 3.0. if you are keeping up with the times and running Windows 8 as your desktop then you already have PowerShell 3.

Next you’ll to install the SharePoint Online Management Shell. The latest one I found is here:

http://www.microsoft.com/en-us/download/details.aspx?id=35588

I also found an earlier preview following some links but I’d suggest the latest version is what you want.

So on the Windows 8 machine on which you have the Microsoft Online Services Module for Windows PowerShell installed ,run it as an administrator and accept the UAC.

image

The next step is to load in the SharePoint Online cmdlets for use in this session. after some digging around I found that they are called:

Microsoft.Online.Sharepoint.PowerShell

image

So at the prompt type:

import-module microsoft.online.sharepoint.powershell

that should result in the above warning.

image

Now you will need to log into your Wave 15 account. i normally do this by saving the login details to a variable by typing the following:

$cred=get-credentials

A dialog windows as shown above will appear into which you need to enter the login and password of a suitably enabled Office 365 user who can administer SharePoint Online. If in doubt use the initial global administrator that was provisioned with your site.

image

The next step is now to use those credential to connect to SharePoint Online. To do this execute the following line:

connect-sposervice –url https://-admin.sharepoint.com –credential $cred

in my case this was:

connect-sposervice –url https://ciaops365e1-admin.sharepoint.com –credential $cred

image

In true PowerShell form, if everything is correct you will simply be returned to a prompt. Now you can execute commands against SharePoint Online. For example the following will display all your SharePoint Online sites by URL in a table:

get-sposite | ft “url”

Now you can start exploring all the cmdlets that are available for SharePoint Online which you can find at the bottom of this page:

http://office.microsoft.com/en-au/sharepoint-help/introduction-to-the-sharepoint-online-management-shell-HA102915057.aspx

Does the same process work on Wave 14 tenants that haven’t yet been upgraded to Wave 15 and SharePoint 2013?

image

I tried it on my Wave 14 tenant (https://ciaops365.sharepoint.com) above and it worked! Excellent, roll on SharePoint Online control via PowerShell everywhere.