Parse IIS logs for SharePoint with powershell

Submitted by Vladilen on Wed, 03/01/2017 - 01:50

I found pretty useless IIS Log Parser (with Studio) for SharePoint. 
The reasons are - blank spaces and "%20" symbols in Url in SharePoint IIS logs which confuses IIS Log Parser and  prevents you from search through logs using IIS Log Parser 

i.e., if your SharePoint users want to investigate their file "/sites/Very%20Important%20site/much%20more%20important%20unique%20file.docx" - you will stuck.

finally, I found plain Powershell commands the most useful to parse IIS logs, like this:

OneNote properties in SharePoint

Submitted by Vladilen on Fri, 12/16/2016 - 16:15

OneNote document is not a one file, but a number of files in a folder. You can save OneNote document in SharePoint and it would looks like a file, but internal implementation of OneNote in SharePoint is actually a folder content type.

And if you try to assign properties to OneNote document - you just can't.

I haven't seen any clear instructions from Microsoft on the subject. And here we have an “unsupported” workarounds. Actually, there are two: “Change Content Type” way and “Quick Edit View” way.

Project Server 2016

Submitted by Vladilen on Tue, 11/15/2016 - 06:50

As you know, Project Server 2016 is actually a service application on SharePoint Server 2016.
Which means if you want Project Server 2016, you must have SharePoint 2016 first.
But if you have SharePoint 2016 farm, it's much easier to get Project 2016. Moreover, once you build robust, scalable and high-available SharePoint, you get the same to you Project "for free".
NB: Project is licensed separately.

Hybrid SharePoint 2013/2016

Submitted by Vladilen on Sat, 10/29/2016 - 20:05

Step-by-step script of my recent Hybrid SharePoint 2016 - Office 365 implementation:


Office 365 Prerequisites

  • set and configure custom domain name
  • synchronize users (e.g. like this)
  • provide Office 365 licenses for hybrid users
  • (for hybrid search or Sharepoint 2016 DLP) provide license for farm account

On-Premises AD prerequisites

  • AD group "HybridUsers" for hybrid users

On-premises SharePoint Prerequisites