SharePoint Diary

How to Add Enterprise Keywords Column To SharePoint List or Library?

September 29, 2014 Managed Metadata, PowerShell, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

Enterprise keywords column in SharePoint (or folksonomy) enables end users to add tags to documents and Items. Here is how to enable enterprise keywords column to SharePoint list and libraries. How to add enterprise keywords column in SharePoint? To make it easy for users to add keywords, you can add Enterprise Keywords column to a list or library. To enable enterprise keywords field in SharePoint, Go to: List/Library Settings >> Enterprise Metadata and Keywords Settings Enable Enterprise Keywords at "Add Enterprise Keywords" section by selecting "Add an Enterprise Keywords column to this list and enable Keyword synchronization" This should bring new column "Enterprise Keywords "to your SharePoint list. Now, users can add Keywords to "Enterprise Keywords" column by simply entering user defined word or phrase. These column values are stored in MMS service application term store and can be refined later. Enable enterprise keywo

How to Add Enterprise Keywords Column To SharePoint List or Library?

Reviewed by Salaudeen Rajack on September 29, 2014 Rating: 5

Change Distributed Cache Service Account in SharePoint 2013 with PowerShell

September 29, 2014 Central Administration, PowerShell, SharePoint, SharePoint 2013, SharePoint 2016

Distributed Cache service caches data for fast retrieval across several features in SharePoint Server 2013, such as : News feeds, Authentication, Security Trimming, OneNote client access, Page load performance, etc. When SharePoint 2013 is installed, AppFabric service is installed as part of the SharePoint pre-requisites, and configured to run under the credentials of Farm account, Which is not ideal and triggers an alert in SharePoint 2013 Health Analyzer. "The server farm account should not be used for other services." Domain\Account the account used for the SharePoint timer service and the central administration site, is highly privileged and should not be used for any other services on any machines in the server farm. The following services were found to use this account: Distributed Cache Service(Windows Service). It also gives the remedy to change service account. So as per the advice, if you try to navigate to the page (or via Central Admin >> Security &

Change Distributed Cache Service Account in SharePoint 2013 with PowerShell

Reviewed by Salaudeen Rajack on September 29, 2014 Rating: 5

Rename SharePoint Service Application, Proxy using PowerShell

September 29, 2014 PowerShell, Service Application, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

If you want to rename a SharePoint service application or Service application proxy, There is now UI available. But PowerShell can help! PowerShell script to rename SharePoint 2013 Service application and Proxy: Add-PSSnapin microsoft.sharepoint.powershell -ErrorAction SilentlyContinue #### rename sharepoint service application proxy### #Get the Service Application proxy $Proxy = Get-SPServiceApplicationProxy | ? {$_.Name -eq "Search SSA Proxy"} #Rename Service application proxy $Proxy.Name = "Search Service Application Proxy" $Proxy.Update() ###sharepoint 2013 rename service application### #Get Service application $Service = Get-SPServiceApplication -Name "Search Service App" #Rename Service application $Service.Name = "Search Service Application" $Service.Update() After the rename: rename SharePoint service application

Rename SharePoint Service Application, Proxy using PowerShell

Reviewed by Salaudeen Rajack on September 29, 2014 Rating: 5

Create New Result Source for Federated Search using PowerShell

September 25, 2014 PowerShell, Search, SharePoint, SharePoint 2013, SharePoint 2016

PowerShell script to Create new result source for Federated search: Add-PSSnapin microsoft.sharepoint.powershell -ErrorAction SilentlyContinue #create a new result source at Search Service Application $SearchServiceApplication = Get-SPEnterpriseSearchServiceApplication $FederationManager = New-Object Microsoft.Office.Server.Search.Administration.Query.FederationManager($SearchServiceApplication) $SearchOwner = Get-SPEnterpriseSearchOwner -Level Ssa $ResultSourceName ="Bing Search Result Source" #For Site Level Result Source, Use: #$SiteCollection = Get-SPSite $SiteUrl -ErrorAction SilentlyContinue #$SearchOwner = Get-SPEnterpriseSearchOwner -Level SPSite -SPSite $SiteCollection #Check if the Result Source is already exists $ResultSource = $FederationManager.GetSourceByName($ResultSourceName,$SearchOwner) if($ResultSource) { $FederationManager.RemoveSource($ResultSource) } # create a new result source $Query = "{SearchTerms}" $ResultSource = $FederationM

Create New Result Source for Federated Search using PowerShell

Reviewed by Salaudeen Rajack on September 25, 2014 Rating: 5

Hide "Site Contents" Link from SharePoint 2013 Quick Launch Navigation

September 23, 2014 CSS, Navigation, Quick Launch, SharePoint, SharePoint 2013, SharePoint 2016

Requirement: Hide site content link from left navigation SharePoint server 2013 How to hide site contents in SharePoint 2013 quick launch? We can use CSS to hide "Site Contents" link from SharePoint 2013 quick launch navigation. Hide all site content from quick launch SharePoint 2013 with CSS Edit your SharePoint Master page, Insert a "Script Editor" web part and add the below code in it. <style> #sideNavBox a[href$="/_layouts/15/viewlsts.aspx"] { display: none; } </style> To remove site content from quick launch of SharePoint 2013 sites, Add this CSS to master page, Or you can have it in Alternate CSS sheet. Save and Publish your master page. Remove Site Contents from SharePoint 2013 (Not recommended) If you want to remove "Site Contents" link permanently, You can: Click on "Edit Links" under Quick Launch, edit and remove the "Site Contents" link. Same can be done by: Go To Site Settings

Hide "Site Contents" Link from SharePoint 2013 Quick Launch Navigation

Reviewed by Salaudeen Rajack on September 23, 2014 Rating: 5

Using SharePoint Designer to Edit Property Bags

September 22, 2014 SharePoint, SharePoint Designer

Property bags are explained in my another article: Property Bags in SharePoint 2013 - Store, Retrieve Custom Configurations , In short: Property bag feature provides a convenient way to store and retrieve custom configurations, instead of having to store them in web.config files. Usually property bag settings are managed programmatically with SharePoint object model code in C# ow with PowerShell. There is no user interface to view/add/edit/delete the property bags key-value, but SharePoint designer can be utilized to manage property bag settings in SharePoint at site level. Here is how: Open your SharePoint site collection with SharePoint Designer Click on the Site Options button from the top right hand corner of the ribbon You'll be presented with a window to manage site’s property bag under "Parameters" tab. From here, you can add, modify or delete properties. In SharePoint 2007, Its under: Site >> Site Settings >> Parameters tab!

Using SharePoint Designer to Edit Property Bags

Reviewed by Salaudeen Rajack on September 22, 2014 Rating: 5

Edit Links Missing in SharePoint 2013 Navigation?

September 21, 2014 Navigation, Office 365, SharePoint, SharePoint 2013, SharePoint 2016, SharePoint Online

Edit Links is a new feature introduced in SharePoint 2013 to provide quick way to Add, Edit, Remove and Re-arrange links in quick launch and top navigation. Edit Links Missing in SharePoint 2013 Navigation? So, You are not getting Edit links in SharePoint 2013 navigation? Well, Check below factors: Edit links available only on certain site templates such as: Team Site, Publishing sites, Personal Site and Project site. SharePoint 2013 edit links permission: You need to have "Edit "permission level at-least. For Contributors and Visitors SharePoint 2013 edit links is not available. If your sub-site is inheriting navigation from Parent site, the link "Edit Links" in top navigation will not appear. To enable edit links SharePoint 2013 - Your site shouldn't inherit navigation from the parent site. Its available only for "Structural Navigation" option under "Navigation Settings" on publishing sites. You may have custom CSS deployed whic

Edit Links Missing in SharePoint 2013 Navigation?

Reviewed by Salaudeen Rajack on September 21, 2014 Rating: 5

Configuring Managed Accounts in SharePoint 2013

September 20, 2014 PowerShell, Security, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

What is Managed Account in SharePoint? Why We Need Managed Accounts? SharePoint uses service accounts for operations such as Farm account, application pools and for service applications. You have to keep a track of all service accounts with their password in a secured file in your system. If the password for any one of those accounts has been changed, the service which uses that specific service account will stop functioning, until you manually update them in SharePoint. So, The solution comes with SharePoint 2010 and 2013 is you can register your service accounts as a Managed accounts, and you don't have to keep-up the passwords once you register them in your farm and you can manage those managed accounts centrally from SharePoint central administration. SharePoint centrally stores managed accounts and passwords and it can change the password regularly-automatically, if needed. If there is a password expiry policy set on Active Directory, Then SharePoint automaticall

Configuring Managed Accounts in SharePoint 2013

Reviewed by Salaudeen Rajack on September 20, 2014 Rating: 5

Create Usage and Health Data Collection Service Application in SharePoint 2013 using PowerShell

September 19, 2014 PowerShell, Service Application, SharePoint, SharePoint 2013, SharePoint 2016

Usage and Health data collection service application in SharePoint collects usage and health data from a variety of sources, including event logs, performance counters, search usage data, site collection and site usage data, and server statistics of the entire farm. There are timer jobs to collect data from log files in 16\LOGS folder where usage usage data is initially logged and then updated to the usage database. Usage and Health Data Collection Service Application can be only created through PowerShell in SharePoint 2013. You'll get empty reports in Web Analytics reports section, if usage and health data collection service application isn't configured properly. Usage and Health Data collection database that should not be part of the Availability Group! Create Usage and Health Data Collection Service Application in SharePoint 2013 using PowerShell: Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue #Configuration Variables $UsageSAName = &qu

Create Usage and Health Data Collection Service Application in SharePoint 2013 using PowerShell

Reviewed by Salaudeen Rajack on September 19, 2014 Rating: 5

Recommended Service Accounts, Permissions and Best Practices for SharePoint

September 18, 2014 Security, SharePoint, SharePoint 2013, SharePoint 2016

Everyone have their own ways of setting up service accounts. Technically its possible to run every SharePoint service under ONE account, lets follow the least privilege principle best practice. Recommended SharePoint 2013 Service Accounts and Naming Conventions: When you are running with multiple SharePoint 2013 environments like Dev, Test and Production (Best Practice!) you can explicitly segregate the service accounts in their names. Such as: SP13_PROD_Setup. Here is my list of SharePoint 2013 service accounts and permissions needed to setup, manage and administer SharePoint: Account Name Description Rights Managed Account? SP13_Setup The Setup account is used to perform the following tasks: -SharePoint Installation -Runs SharePoint Products Configuration Wizard -Configure and manage the server farm, farm configuration wizard Local Administrator on all the SharePoint Servers. On the SQL Server we need to grant S

Recommended Service Accounts, Permissions and Best Practices for SharePoint