PowerShell for SharePoint Online


SharePoint Online

In Conjunction with the release of the SharePoint 2013 preview and Office 15 and all the great releases this summer, Microsoft also saw fit to release some info on the support for PowerShell in SharePoint in Office 365 more commonly known simply as SharePoint online.

Have a look at this link:

Windows PowerShell for SharePoint Online
http://technet.microsoft.com/en-us/library/fp161362(v=office.15)

What I regard as a bit cryptic regarding this release is this:
Applies to: SharePoint Online Preview

Update 20120920: Sign up for the preview here: http://go.microsoft.com/fwlink/p/?linkid=257731
I have not spent time figuring out how to get access to a Preview, I’ll rather just read up on the CMD’lets and wait for the support to become general availability.

The list of CMD’lets is limited to just a few, but as a starter, it is a huge leap forward compared to no support, which was what we had before.
The entire list looks like this:

SharePoint Online cmdlets in verb order 

                Cmdlet name                 Description
Add-SPOUser Adds an existing Office 365 user or an Office 365 security group to a SharePoint group.
Connect-SPOService Connects a SharePoint Online global administrator to a SharePoint Online connection (the SharePoint Online Administration Center). This cmdlet must be run before any other SharePoint Online cmdlets can run.
Disconnect-SPOService Disconnects from a SharePoint Online service.
Get-SPOAppErrors Returns application errors.
Get-SPOAppInfo Returns all installed applications.
Get-SPODeletedSite Returns all deleted site collections that are in the Recycle Bin.
Get-SPOSite Returns one or more site collections.
Get-SPOSiteGroup Returns all the groups on the specified site collection.
Get-SPOTenantLogEntry Retrieves SharePoint Online company logs.
Get-SPOTenantLogLastAvailableTimeInUtc Returns the time when the SharePoint Online organization logs are collected.
Get-SPOUser Returns the SharePoint Online user or security group accounts that match given search criteria.
Get-SPOWebTemplate Shows all site templates that match the given identity.
New-SPOSite Creates a new SharePoint Online site collection for the current company.
New-SPOSiteGroup Creates a new group in a SharePoint Online site collection.
Remove-SPODeletedSite Removes a SharePoint Online deleted site collection from the Recycle Bin.
Remove-SPOSite Sends a SharePoint Online site collection to the SharePoint Online Recycle Bin.
Remove-SPOSiteGroup Removes a SharePoint Online group from a site collection.
Remove-SPOUser Removes a user or a security group from a site collection or a group.
Repair-SPOSite Checks and repairs the specified site collection and its contents.
Request-SPOUpgradeEvaluationSite Requests to create a copy of an existing site collection for the purposes of validating the effects of upgrade without affecting the original site.
Restore-SPODeletedSite Restores a SharePoint Online deleted site collection from the Recycle Bin.
Set-SPOSite Sets or updates the values of one or more properties for a site collection.
Set-SPOSiteGroup Updates the SharePoint Online owner and permission level on a group inside a site collection.
Set-SPOTenant Sets properties on the SharePoint Online organization.
Set-SPOUser Configures properties on an existing user.
Test-SPOSite Tests a SharePoint Online site collection.
Upgrade-SPOSite Starts the upgrade process on a site collection.

Enjoy!

Regards

Twitter | Technet Profile | LinkedIn

Almost missed it: Download the SharePoint 2013 Preview !


SiteIcon2013

Download Microsoft SharePoint Server 2013 Preview (Download here)

SharePoint Server 2013 Preview is designed to bring people together to get work done. Whether you’re using it to manage your enterprise content, make it easy for business end users to share ideas and information, or help developers build innovative new applications, SharePoint Server 2013’s improvements in scale, security, and flexibility have you covered.

Get started here!

The Product Key and the requirements are listed on the Get Started Page page.

Enjoy!

Regards

Twitter | Technet Profile | LinkedIn

Service Applications in SharePoint 2013


SiteIcon2013

Service Applications

The newly released training material on SharePoint 2013 is a goldmine of information (see privious post).
The slide deck consists of no less than 50 presentations on different topics. One of those are Service Applications, which ones will be there and what has changed…?

I will give you the quick answers here:

General architecture identical as in SharePoint 2010
Numerous new enhancements in platform level
New service applications to provide more enhanced functionalities

Office Web Apps is no longer a service application
Seperated into own product

Web Analytics is no longer service application
Analyses and reporting process incorporated to search service application

Service Applications with their own DBs:
App Management Service (new)
Business Data Connectivity
Managed Metadata Service
Search
Secure Store Service
Machine Translation Services (new)
State Service
Usage and Health Data Collection
User Profile Service Application
Word Automation Service
Access Services App databases (new) (2010 and 2013)

Deploying Service Applications
Deploying them seems to be identical to 2010, no better, no worse. If using the wizard they will all use the same app pool and same account, databases will have an ugly GUID atached to them…powershell will give you all the options to configure Service Applications as you wish, as you allready know.

Part from the changes with the removed Service Applications and the new ones, the list will be identical, all the Service Applications that we know and love, will be there…

Service applications Description
Application Management Service   (new) Is responsible for storing and providing   information concerning SP App licenses and permissions
SharePoint Translation Services   (new) Provides built-in machine   translation capabilities on the SharePoint platform
Access Services 2010 Let’s users view, edit, and   interact with Access 2010 databases in a Web browser.
Access Services Let’s users view, edit, and interact with Access 2013 databases in a Web browser.
Business Data Connectivity service Gives access to line-of-business   data systems.
Excel Services Application Let’s users view and interact   withExcel 2010 files in a Web browser.
Managed Metadata service Manages taxonomy hierarchies,   keywords and social tagging infrastructure, and publish content types across   site collections.
PerformancePoint Service Application Provides the capabilities of   PerformancePoint.
Search service Crawls content, produces index   partitions, and serves search queries.
Secure Store Service Provides single sign-on   authentication to access multiple applications or services.
State service Provides temporary storage of user   session data for SharePoint Server components.
Usage and Health Data Collection   service Collects farm wide usage and   health data, and provides the ability to view various usage and health   reports.
User Profile service Adds support for My Sites, profile   pages, social tagging and other social computing features.
Visio Graphics Service Lets users view and refresh   published Visio 2010 diagrams in a Web browser.
Word Automation Services Performs automated bulk document   conversions.
Microsoft SharePoint Foundation   Subscription Settings Service Provides multi-tenant   functionality for service applications. Tracks subscription IDs and settings   for services that are deployed in partitioned mode. Deployed through Windows   PowerShell only.
(Moved into Search)Web Analytics service Provides Web service interfaces.

Add-on/Installable Service Applications

Service application Description
Office Web Apps services Removed from SharePoint 2013, will   be its own application.
Microsoft Project Server 2010 No information, assuming it will   still be there.

Enjoy!

Regards

Twitter | Technet Profile | LinkedIn

Drop everything – SharePoint 2013 IT Pro and Developer training materials released…


SiteIcon2013

Ok, now we’re talking…

SharePoint 2013 IT Pro and Developer training materials released
http://blogs.msdn.com/b/vesku/archive/2012/07/17/sharepoint-2013-it-pro-and-developer-training-materials-released.aspx

Loads of good stuff available, 14 streamed video modules, everything also available as pptx.

Too bad I’m on holiday…now…the real FUN BEGINS!

 

Enjoy!

Regards

Twitter | Technet Profile | LinkedIn

Office 15 Preview has been released – get it now


Hi readers.

The latest news that almost eluded me completely beeing in a summer daze as I am, were it not for a former colleague who notified me promptly, is this:

This monday the 16th Steve Ballmer himself unveiled the new Office wave 15, later to be called Office 2013. This is great news, it does not contain that which is loved by us all, SHarePoint, but it still is interesting stuff. Lots of things can be read into SharePoint from studying Office…

So, what now…? Get the software or read about it:

Register to download:
http://www.microsoft.com/office/preview/en

Read an excellent review here(complete with screenshots):
http://www.engadget.com/2012/07/16/microsoft-office-15-preview/

Enjoy!

Regards

Twitter | Technet Profile | LinkedIn

PowerShell on Security at The Scripting Guys


As you might know Microsoft has a site called The Scripting Guys. My colleague Niclas Goude will be writing a couple of guest blogs on The Scripting Guys regarding security from the 2:nd to the 6:th of July.

The specific subjects will be:

Monday: Scanning – Direct Link

Tuesday: Brute Force – Direct Link

Wednesday: Shares and Metadata – Direct Link

Thursday: Beyond Local admin – Direct Link

Friday: LSA Secrets – Direct Link

Look them up there: http://blogs.technet.com/b/heyscriptingguy
Or Goudes blog: http://www.powershell.nu

Enjoy!

Regards

Twitter | Technet Profile | LinkedIn

Remove SharePoint DB without having SQL Management Studio access…


Remove SharePoint DB using PowerShell

Just a quick tip that can help a lot in some situations, when in the situation when you for example have deleted a service application and the DB’s are still there, the DBA’s have all left and you have no way of connecting to SQL with a management tool…

This is what you can do, given that you have the permissions…(high?)

Get-SPDatabase
(Will list all databases used by SharePoint, Name and GUID and Type.)

$DatabaseToDelete = Get-SPDatabase <GUID of the database you need to get rid of>
(Load the database as a SPDatabase object)

$DatabaseToDelete.Delete()
(It’s now gone…)

Thats all there is to it.

Enjoy!

Regards

Twitter | Technet Profile | LinkedIn

SharePoint 2012/2013 Wishlist – Dear Microsoft…


SharePoint 2012/2013 Wishlist…dear Microsoft…

Ok, this time I would like to add a post intended for Microsoft and the product group, but also for all of you SharePoint fans out there.
I guess that you have like me and like this time my dear coworker Mattias Gutke who cowrote this list, thought over time that this and this should be done better or added in the next version.

However, I do not know of any good way to get this knowledge across to the product group, or even if there is a way to email someone. Perhaps there is for the MVP’s or the TAP/TechPreview community but for all of us mere mortals??
During my 8+ years at Microsoft there was always talk about the emailaddress mswishlist@microsoft.com. I still today do not know if it even existed or if it was monitored.

So, I’ll just post the list we have gathered over time here and my hope is that it somehow will make it’s way to the top. Please aslo feel free to add your own reasonable requests as a comment and I will be happy to review and possibly add it to the list.

Ok, here we go! The list of features, functionality, added/fixed settings in the next version of SharePoint, SharePoint 2012/2013 (working title SharePoint v. 15)

Dear Microsoft, this is what we want:

  • In CA, add a setting for a common Farm wide prefix for all databases. Skip the guid from the gui if this is set.
    Example: Farmname_databasetype_function
  • Add a possibility to audit all Central administration settings, even when changed from PowerShell. Audit data should be collected at a separately named database server and database(can be the same as the farm SQL)
  • If a service or feature needs to be started in order to create a service application or other objects in CA, prompt to start them.
  • Add a link to the Search administration from the start page in CA when Search is installed.
  • Add a ‘Verify Kerberos setup’ that can access data and verify if a system are configured properly to operate using Kerberos authentication.
  • Add a wizard for setting up Claims authentication from live.com(and possibly other external authenticators)
  • Record actions taken in CA as Powershell commands so that they can be re-executed in another farm or again in the same farm.
  • Save farm settings to xml+wsp, then import settings to new farm. An improved semi-automated way to transfer a test environment to prod or prod to test. Import will implement the exact same settings as in source farm complete with service applications and solutions. Acount and unique settings will be editable easily in the xml.
  • Correlation id link to logfile for admins, even a linenumbers would be great.
    Also for the end user experience they would be able to send (with a button) that id & link to an admin. with the option to write error/problem desctiption. with choices??? i.e Minor incident, Critical for business etc.
  • Easier to get UPS up and running in some way. installed default? but not activated/configured feature/service
  • Much easier navigation within CA, everything is still a mess. Hate to se a couple of settings as a preview but when you go into i.e Monitoring you will find even more, show everything at the beginning or nothing exectp the title of the section.
  • Visual Farm topology in CA would be nice to have, with clickable areas to get more information.
  • When copy a item to another library within the site collection a browse button should be available, you should not have to specify a URL!!!
  • Clean up permission pages, and default should only be 3 sharepoint groups, visitor, member owner
  • Add support to export/import termstore synonyms.
  • Add support for Managed metadata/Termstore in SharePoint Workspace.
  • Allow the ability to enter metadata on multiple-document upload
  • PDF-ifilter out of the box!
  • Auto-remove from SharePoint if AD-object is terminated/removed.
  • You should not have to have sharepoint installed on your VS dev machine, connect and publish to any external sharepoint farm. It should be enough to install an SDK for SharePoint.
  • A way to in the GUI or Visual Studio, select the components that you want to be part of a new Web Template/Site Definition.
  • If a new update/CU/SP is available for each product/feature/service, In the upgrade/version/patch level page in CA. Link to the correct place to get that patch/CU/SP, dont want to google it up every time!!!
    One place to select update farm (select in list to what cu/SP)!
  • Same for Language packs as for CU/SP, one place to select in CA and the languages should be downloaded and installed.
  • Export some configuration in CA as a powershellscript
  • Add an extended default example metadata classification tree to the term store.
  • Add easier export import of metadata from the term store.
  • built in warm-up-script functionality.
  • Built in Scedule task functionality.
  • Under site settings, red titles are features available but not enabled due to some feature that needs activation like (in red) Navigation – SharePoint Server Publishing Infrastructure feature. Once activated the feature turns blue and the text shoowing witch feature needs to be activated is gone.
  • Or, as above but with most settings available but if the feature is not enabled, you get a dialog that says that this feature will be activated, do you wish to go ahead?
  • Easier cutomization of the ribbon, checkboxes of what options should be available, today it’s too overwhelming experience for endusers. also a tab for admin/owner for the ribbon would be nice to be able to select all non-endusers settings.

For the rest of you – Enjoy!

Regards

  (with great contributions from Mattias Gutke – Enfo Sweden)

Whitepaper – SharePoint 2010 Site Settings made easy


Download

Ok, when lacking a better way of getting this out to the public, I’ll just drop it here for now, this is free and it is a lot of work behind it, please download and use if you find it’s content valuable. Perhaps I will find a better means of getting it out, but this is ok for now.

As you all know, the Site Settings in SharePoint Server 2010 are dynamic, meaning that they change as different features are enabled or disabled. Some are available in the Site Collection root only(SPSite), some in subsites(SPWeb) only.
All of these seetings that have been made available to us in SharePoint Server 2010, I have catalogued and tagged.

You will find all settings explained, when they show up and what they do, what the url is and if it can be controlled using PowerShell.
These are the sections that we have seen so many times but perhaps not reflected over, I know I still saw a setting or two that I did not know existed during mywork with this paper…

Site Settings, 71 all in all available in the following categories:

Users and permissions
Galleries
Site Administration
Site Collection Administration
Look and feel
Site Actions
Reporting Services

Download, but please do not share the document, share the link. That way I will get some form of reward in knowing how many people have downloaded and used my paper. Thanks!

Big THANKS to my present and future Collegues and friends for helping out and supporting the idea:
Mattias Gutke (Enfo Zipper)
Niklas Goude (Truesec)
Anders Grönlund (Enfo Zipper)

I owe you guys big time!

For the rest of you – Enjoy!

Regards

What’s New for SharePoint 2010 Development in Visual Studio 2012 RC


I previously added some info references to the new and coming Visual Studio, that has some new really nice features for us SharePoint fans. This time I have installed the smokin hot new RC of Visual Studio 2012 and I’ll here give you a taste of whats to come, in pictures….

As you can see, the GUI is all Metro now, the logo and all parts of Visual Studio have been Metrofied. Not bad…

Not bad at all….

We have the following project types to select from in the RC. I suspect that there will be change here come release time.
(in 2012 we have 12 templates default in 2010 for SharePoint 2010)

New items list…

And the really nice remote publishing possibility.

For a more complete list of news in VS 2012, see: What’s New for SharePoint 2010 Development in Visual Studio 11

Enjoy!

Regards