SQL Server Reporting Services (SSRS) is powerful way of presenting reports and data to your end users in SharePoint. But sometimes, the out of the box experience of some features of SSRS doesn’t work for your situation. A nice example of this is the field delimiter for CSV exports. This is by default a comma. But… Continue reading Customize SSRS extension settings in SharePoint Integrated Mode
Tag: PowerShell
Process items in a Drop Off library using PowerShell
Everyone knows the Drop Off library in SharePoint, right? It routes documents to a final destination, based on rules you define. This works OK for documents which are uploaded manually to the Drop Off library but I found out that it doesn’t work for documents which are uploaded with PowerShell (or any other method which… Continue reading Process items in a Drop Off library using PowerShell
Filter a View on Liked By in SharePoint 2013
SharePoint 2013 allows users to rate individual items in a list or library. This rating can be in the form of a “star” rating from 0 to 5 or in the form of “likes”. This is disabled by default for a list or library. The rating data is stored in 5 columns which are added… Continue reading Filter a View on Liked By in SharePoint 2013
Close disconnected remote sessions using PowerShell
Do you know this situation? You are responsible for some servers and you planned to do some patching during the weekend. You open a remote desktop to the server with the administrator user and you see that the session is still active. Visual Studio is open with unsaved source code, some config files are open, even… Continue reading Close disconnected remote sessions using PowerShell
Configure Object Caching accounts using PowerShell
If you want your Object Caching to work properly in SharePoint, you need to set 2 user accounts: Portal Super Reader Portal Super User Additionally, they must be configured correctly. That is, you need to do 2 things: Add a “Full Control” user policy to your web application for the Portal Super User and use… Continue reading Configure Object Caching accounts using PowerShell
Enabling BLOB Cache in SharePoint using PowerShell
One of the ways of improving performance of your SharePoint is by enabling the BLOB Cache. The BLOB cache is a disk-based cache that stores binary large objects (BLOB’s) on the web server to reduce the load on the database server by avoiding unneccessary round trips to that server. Read all about it on TechNet. The BLOB Cache… Continue reading Enabling BLOB Cache in SharePoint using PowerShell
Creating Managed & Crawled Properties using PowerShell
Have you ever created and mapped a decent amount of managed properties in SharePoint using the UI? If you have, you probably know that it’s not the most exciting job. Lots of clicking, waiting, reloading,… If you are someone like me… someone who doesn’t like doing things manually… and you are reading this, you are… Continue reading Creating Managed & Crawled Properties using PowerShell
Find all termsets used for site navigation
SharePoint 2013 gives you the ability to use termsets for navigation. When you use the UI (TermStore Management), you can enable a specific termset to be used for navigation by enabling the “Use this Term Set for Site Navigation” option on the INTENDED USE tab of the termset. If you are used to work with PowerShell and I… Continue reading Find all termsets used for site navigation
Fix variation labels with a wrong locale
Last week, I was doing some support for a customer which had some issues with variations on their intranet which is based on SharePoint 2010. They have 3 variations: English (Source) Dutch French While investigating an issue, I started playing around with the browser language and noticed the following : Browser language = English => Redirect to… Continue reading Fix variation labels with a wrong locale
Get sites, webs, lists and number of items with their permission inheritance in SharePoint
Working with permissions in SharePoint can become complicated very quickly. Especially when you are starting to break the inheritance on several levels. Finding out which sites and lists have their inheritance broken is a task which can set you back a few hours, depending on the size of your SharePoint environment. Since I’m always short… Continue reading Get sites, webs, lists and number of items with their permission inheritance in SharePoint