Blog by Nico Martenshttps://sharepointrelated.com
SharePoint / Office365Thu, 25 Oct 2018 08:01:54 +0000en-UShourly1https://wordpress.org/?v=4.9.8https://sharepointrelated.com/wp-content/uploads/2014/11/nico_small-150x150.jpgBlog by Nico Martenshttps://sharepointrelated.com
3232107583792Azure PowerShell – Get basic VM configurationhttps://sharepointrelated.com/2018/10/25/azure-powershell-get-basic-vm-configuration/
https://sharepointrelated.com/2018/10/25/azure-powershell-get-basic-vm-configuration/#respondThu, 25 Oct 2018 08:01:54 +0000https://sharepointrelated.com/?p=996Summary: This blog post describes an easy way to get basic Azure VM configuration with Azure PowerShell As an IT-Pro, I love using PowerShell to get easy access to information, without needing to click through interfaces. This is getting more important every day as the User Interface (especially for Azure and Office 365) have been changing Read more about Azure PowerShell – Get basic VM configuration[…]

]]>Summary: This blog post describes an easy way to get basic Azure VM configuration with Azure PowerShell

As an IT-Pro, I love using PowerShell to get easy access to information, without needing to click through interfaces. This is getting more important every day as the User Interface (especially for Azure and Office 365) have been changing quite regularly. Getting information can be hard because of this change.

However, if you are using PowerShell, the way of getting information stays the same, as the core for PowerShell doesn’t change that often and it can be used repeatedly.

Getting basic Azure VM information

Azure gives us great PowerShell cmdlets that help us get the information we need. However, because of the scale of Azure, some information might not be where you expect it to be.
A simple example: If you want to know how many CPU’s or memory have been assigned to your VM, you have to get the “VMSize”, which has its own cmdlet.

This would be:

Get-AzureRmVmSize -Location "West Europe"

.
This produces a list of (in my case) 214 different VM types that are available in the region. Each of these VM types have different configurations.
If you have 100 VMs in Azure, you would have to look up each of the VM types to get the basic information.

]]>https://sharepointrelated.com/2018/10/25/azure-powershell-get-basic-vm-configuration/feed/0996SharePoint Online Management PowerShell modulehttps://sharepointrelated.com/2018/09/14/sharepoint-online-powershell-module/
https://sharepointrelated.com/2018/09/14/sharepoint-online-powershell-module/#respondFri, 14 Sep 2018 06:35:20 +0000https://sharepointrelated.com/?p=977Summary: This blog post describes why you do not need the SharePoint Online Management Shell anymore! If you worked with PowerShell for SharePoint Online in the last year, you had to download a new PowerShell console from: https://www.microsoft.com/en-us/download/details.aspx?id=35588. On the 31st of August 2018 Microsoft released a new* PowerShell module to the PowerShell gallery: Microsoft.Online.SharePoint.PowerShell. This Read more about SharePoint Online Management PowerShell module[…]

On the 31st of August 2018 Microsoft released a new* PowerShell module to the PowerShell gallery: Microsoft.Online.SharePoint.PowerShell. This means we can now install the SharePoint Online PowerShell module straight from the PowerShell Gallery, which makes it very easy to get.

The PowerShell Gallery is the central repository for sharing and acquiring PowerShell code including PowerShell modules, scripts, and DSC resources: https://www.powershellgallery.com

Getting the SharePoint Online PowerShell module

Just like any other module published in the PowerShellGallery, you can install the module by running just 1 line of PowerShell code into your regular PowerShell console.
Make sure that you started PowerShell as administrator and run:

Install-Module Microsoft.Online.SharePoint.PowerShell -Force

If you already installed the SharePoint Online Management Shell by downloading it, you should remove it.

Please note that you won’t have any “SharePoint Online Management Shell” after you install the module from the PowerShell Gallery.
You can just use any cmdlet provided by this module from your regular PowerShell console.

Updating
Another major advantage of installing the module via the PowerShell Gallery is updating the module.
Before, you had to go to the Microsoft download page again and install the latest version.
With the PowerShell Gallery module, all you need to run is:

Update-Module Microsoft.Online.SharePoint.PowerShell

To do
If only the Exchange Online PowerShell module would add MFA, we wouldn’t need to install any custom programs to start using PowerShell for Office 365.
Hopefully, this will happen too!

]]>https://sharepointrelated.com/2018/09/14/sharepoint-online-powershell-module/feed/0977PowerShell – Easy & secure connection to Office 365https://sharepointrelated.com/2018/06/12/powershell-easy-secure-office365/
https://sharepointrelated.com/2018/06/12/powershell-easy-secure-office365/#commentsTue, 12 Jun 2018 14:04:12 +0000https://sharepointrelated.com/?p=946Introduction Are you tired of remembering all those cmdlets to connect to Exchange Online, SharePoint Online. So many different cmdlets for the different services. With this PowerShell module you don’t need to remember anything (not even your password!) I published my first PowerShell module to the PowerShell Gallery: https://www.powershellgallery.com/packages/Office365.Connect/. The module contains 2 cmdlets that you Read more about PowerShell – Easy & secure connection to Office 365[…]

Are you tired of remembering all those cmdlets to connect to Exchange Online, SharePoint Online. So many different cmdlets for the different services. With this PowerShell module you don’t need to remember anything (not even your password!)

I published my first PowerShell module to the PowerShell Gallery: https://www.powershellgallery.com/packages/Office365.Connect/. The module contains 2 cmdlets that you can use to connect and disconnect from Office 365 PowerShell. It leverages the Windows Credential Manager to securely connect to any Office 365 service.
It also supports using Multi-factor authentication (MFA). Read more about this below.
In the image below you can see I can connect to these services, and it already specified an account to use. The script I ran to use this

Connect-Office365 -Tenant "sharepointrelated"

The script checks the Windows Credential Manager to see if there’s an entry named “sharepointrelated”. If there is, it uses the credentials entered there to connect to the tenant.

Windows Credential Manager
To ensure secure use of credentials, we leverage the Windows Credential Manager (You can find this in Control Panel). All you need to do is add any tenant you want to manage as a “Windows generic credential“.

Here’s an example that I have setup to demonstrate it:

Other modules
If you don’t have the required modules to connect to any of the Office 365 services using PowerShell, the Connect-Office365 cmdlet will provide an option to automatically install the required modules for you.

Installation

As any other PowerShell module published in the PowerShell Gallery, you can install the module using the following cmdlet. Make sure you run PowerShell as administrator:

Install-Module Office365.Connect

Use Guide – PowerShell

After you installed the module from the PowerShell gallery, you can start using cmdlets Connect-Office365 and Disconnect-Office365.

Here are some basic examples that you can use.

Connect Office 365 without MFA

Connect-Office365 -Tenant "Contoso"

This allows you to connect to Office 365 services using PowerShell, without the use of MFA.

Connect Office 365Using with MFA
If the tenant you want to manage uses MFA for your account (you always should for administrator accounts), you will need to specify this while connecting. For instance:

Connect-Office365 -Tenant "Fabrikam" -MFA

Disconnect all Office 365 services
If you are done managing Office 365, you can disconnect all sessions by using:

Disconnect-Office365

This will disconnect all services.

Disconnect specific Office 365 services
If you want to disconnect specific services, you can do this by doing:

Disconnect-Office365 -Teams -SharePoint

The above cmdlet will disconnect from Microsoft Teams and SharePoint Online, but any other services that you might be connected to will remain connected.

Credits

A big thanks to Ryan Yates for assisting me on my first Github project and helping me publish this to the PowerShell Gallery.
Also a thank you to my colleague Staffan Nelemans for helping me troubleshoot some issues I had while converting my initial PowerShell script to a module.

]]>https://sharepointrelated.com/2018/02/22/portiva-everything-possible/feed/0910Creating a site collection for each web templatehttps://sharepointrelated.com/2017/12/17/creating-site-collection-web-template/
https://sharepointrelated.com/2017/12/17/creating-site-collection-web-template/#respondSun, 17 Dec 2017 14:49:08 +0000https://sharepointrelated.com/?p=896Summary: This blog post provides a PowerShell script that creates a site collection for each SharePoint WebTemplate available. I found that after years of consulting, I still didn’t know all the web templates SharePoint has to offer, so I decided to create a PowerShell script that creates a site collection for each web template. It Read more about Creating a site collection for each web template[…]

]]>Summary: This blog post provides a PowerShell script that creates a site collection for each SharePoint WebTemplate available.

I found that after years of consulting, I still didn’t know all the web templates SharePoint has to offer, so I decided to create a PowerShell script that creates a site collection for each web template.

It creates the site collections under the “/sites/” wildcard inclusion Managed Path.

]]>Summary: This blog post describes how to get document previews for SharePoint Online and SharePoint on-premises results after configuring Cloud Hybrid Search.

After setting up Cloud Hybrid Search, you might find that document previews are working for your SharePoint Online content, but not for your on-premises content.

Microsoft uses Office Online Server (OOS) in Office 365 to enable document previews for your SharePoint Online files.
Unfortunately, it is not possible to leverage OOS from Office 365 for your on-premises content.
This is why deploying Office Web Apps or Office Online Server is required in order to get document previews for your on-premises content.

Choosing between Office Web Apps and Office Online Server
When choosing the right product for your organization, keep in mind that Office Web Apps is not supported for SharePoint 2016.

Considerations
– If you have multiple on-premises SharePoint farms, you can connect all these SharePoint farms to a single Office Online Server farm.
– Make sure to make the Office Online Server farm accessible from outside the organization network if required.
– Please use HTTPS for Office Online Server.

]]>https://sharepointrelated.com/2017/12/08/document-previews-using-cloud-search/feed/0891Office 365 Mail pushing Microsoft Teamshttps://sharepointrelated.com/2017/09/07/office-365-mail-pushing-microsoft-teams/
https://sharepointrelated.com/2017/09/07/office-365-mail-pushing-microsoft-teams/#commentsThu, 07 Sep 2017 08:16:10 +0000https://sharepointrelated.com/?p=880Office 365 Mail has an option that allows you to chat with your contacts using Skype for Business without leaving the browser. This feature was announced in June 2015: https://blogs.office.com/en-us/2015/06/08/new-user-experiences-in-office-365-on-the-web/ However, Microsoft changed the way this works for some tenants. Clicking the Skype for Business icon now, results in the following: It pushes me to Start Read more about Office 365 Mail pushing Microsoft Teams[…]

This change affects all users, even users that are not in first-release mode. Even when Teams licenses are not activated for the user, it still pushes for Microsoft Teams, which results in an error.

I couldn’t find any announcement by Microsoft that this change was about to happen, so we had no way to test this new “feature” and communicate this with our employees. It would be great to have a way to disable this feature, to allow people to use the in-line chat when Microsoft Teams is not enabled in their tenant.

Update: After refreshing my page, it goes back to the old user interface, opening the in-line Skype for Business chat functionality. It seems this was a temporary bug/feature.

But still, the text was pretty clear: “Skype for Business is now Microsoft Teams!“.
We’ll see what happens in the future.

]]>https://sharepointrelated.com/2017/09/07/office-365-mail-pushing-microsoft-teams/feed/19880All you need to know about Hybrid Auditing in SharePoint 2016https://sharepointrelated.com/2017/02/20/hybrid-auditing-sharepoint-2016/
https://sharepointrelated.com/2017/02/20/hybrid-auditing-sharepoint-2016/#commentsMon, 20 Feb 2017 12:51:57 +0000https://sharepointrelated.com/?p=809Summary: This blog post will show you how to configure Hybrid Auditing in SharePoint 2016. It will also point out some considerations when deploying this new feature. Microsoft released a new hybrid feature for SharePoint 2016: Hybrid Auditing. This feature will automatically upload your on-premises user activity logs to Office 365, so administrators can generate reports Read more about All you need to know about Hybrid Auditing in SharePoint 2016[…]

]]>Summary: This blog post will show you how to configure Hybrid Auditing in SharePoint 2016. It will also point out some considerations when deploying this new feature.
Microsoft released a new hybrid feature for SharePoint 2016: Hybrid Auditing. This feature will automatically upload your on-premises user activity logs to Office 365, so administrators can generate reports for users across SharePoint on-premises and Office 365.

* Note: This feature is still in preview! The configuration and capabilities might change in the future.

Verify your configuration

If you want to verify that the configuration was successful, here are some tips:

Get Microsoft SharePoint Insights configuration
If you want to make sure that you Hybrid Auditing configuration was done correctly, you can use the following PowerShell cmdlet to see the current configuration:

Get-SPInsightsConfig

This will show you the current configuration for your Hybrid Auditing feature. This might also help you to find any issues you’re facing.

Configure usage and health data collection
In Central Administration, under Monitoring -> Configure usage and health data collection make sure “Enable usage data collection” is checked.
For now I am not sure which checkboxes are required for the hybrid functionality, but these are the ones I have active at the moment.

Troubleshooting

After configuring Hybrid Auditing, I found that I wasn’t getting any on-premises results from the Office 365 Security & Compliance center.
Here you can find some issues that I ran in to and the solution for these issues.

Failed to start a service (Microsoft SharePoint Insights service) that is needed for Hybrid Auditing (Preview) scenario

After running the Hybrid picker I would get this error. It seems that there is a time-out when the picker tries to stop and start the Microsoft SharePoint Insights service. To get around this error, make sure the Microsoft SharePoint Insights service is started from the Services on Server or Services in Farm menu in Central Administration.

I have changed my log location in my on-premises farm
Whenever you change your log location, this change is not automatically picked up by the Microsoft SharePoint Insights service.
Instead, you should run the Hybrid Picker again, then restart the Microsoft SharePoint Insights service from Central Administration.
Your logs will appear in Office 365 after performing these steps.

During my testing, I found that the user mapping isn’t done correctly. As this is a preview feature, I am hoping this will be resolved when the feature will be GA.

I have a user named Kim Akers. In Active Directory, this user is known as:

Userprincipalname: kimakers@sharepointrelated.com

User logon name (pre-Windows 2000): sprelated\kimakers

Kim works in both SharePoint 2016 (on-premises) and SharePoint Online.
Opening the Security & Compliance Center in the Office 365 Admin Portal, the “Users” field automatically resolves “Kim” as “Kim Akers”. See the screenshot below as a reference:

The results coming back for this search only show the SharePoint Online activities for Kim.
This is because the results for the on-premises activities for Kim are actually displayed under the user sprelated\kimakers.

Until now, I haven’t found a way to find results for on-premises users directly. The only way to find on-premises activities is to leave the “Users” field empty. This means you will get all results, without any user filter. This makes it hard to find the activities for on-premises users.

If you have any trouble configuring Hybrid Auditing, contact me on Twitter or LinkedIn and I will help wherever I can.

In SharePoint Online, the maximum numbers in your term store is only 200.000.

This means that you can only have a maximum of 200.000 terms in your on-premises Managed Metadata Service Application if you are planning to use hybrid taxonomy. Take this into consideration when you configure hybrid taxonomy.

2. Preview

Hybrid taxonomy is currently still in preview. Keep in mind that things might change along the way.

]]>https://sharepointrelated.com/2016/11/30/hybrid-taxonomy-considerations/feed/0786Hybrid features in SharePoint 2013 and 2016https://sharepointrelated.com/2016/10/05/hybrid-features-sharepoint-2013-and-2016/
https://sharepointrelated.com/2016/10/05/hybrid-features-sharepoint-2013-and-2016/#commentsWed, 05 Oct 2016 08:00:06 +0000https://sharepointrelated.com/?p=703Summary: This post provides an overview of all hybrid SharePoint features that were released by Microsoft for SharePoint 2013 and SharePoint 2016. During Ignite 2016 in Atlanta, Microsoft released some really cool hybrid features, that I would like to share some information about. The really cool thing about this is that they are not only Read more about Hybrid features in SharePoint 2013 and 2016[…]

]]>Summary: This post provides an overview of all hybrid SharePoint features that were released by Microsoft for SharePoint 2013 and SharePoint 2016.

During Ignite 2016 in Atlanta, Microsoft released some really cool hybrid features, that I would like to share some information about. The really cool thing about this is that they are not only available for SharePoint 2016, but Microsoft actually made most of them available in SharePoint 2013. The following table will show the availability per feature, so you know which one is available to your environment.

For more information on any specific hybrid feature, click the feature in the table below.

[table “” not found /]

(1) Breaks ALL existing server-to-server trusts. Provider-hosted add-ins are the most commonly found that use server-to-server trust. Make sure to read this blog post for a solution.(2) There have been major improvements in the CU’s after the initial August 2015 CU for Cloud Hybrid Search. I advise downloading the last CU that has no regressions.

In the last months I have been actively configuring and testing hybrid capabilities in SharePoint 2013. If you have any questions during configuring hybrid features in SharePoint, make sure to contact me on Twitter for the fastest response! I’ll be glad to help with any question.