All posts by fabiocarvalho

SP Editor – Create and update SharePoint Online/SP2013/SP2016 css/js files, inject files to web, manage web properties and list Webhook

Hi Everyone!!!

Today i will share a fantastic Google Chrome Extension that you can use on your developments on SharePoint.

A Google Chrome Extension for creating and updating files (js, css), injecting files to sites, modifying web/list propertybag values (add, edit, remove, index) and creating webhook subscriptions, edit/add/remove webparts from publishing pages and run sp-pnp-js typescript snippets in SP2013, SP2016 and SharePoint Online from Chrome Developer Tools.

https://chrome.google.com/webstore/search/speditor

Take a look at  the great introduction video by Jeff Jones!

Thanks

Fábio Carvalho
SharePoint Consultant
|create|it|

 

SharePoint Online – Internal Fields Names & how to use SPServices to get them!!!

Hi Everyone,

Today i will show you how can you get internal field names in a SharePoint List Items.
As you know SharePoint have two types of Names – Internal Name and Display Name, it is extremity important when you are developing SharePoint solution get your fields by internal name, the InternalName never changes, you only can change DisplayName, this maintain your solution stable.

So let’s Look some ways to get the Internal Name:

  1. Open the List Settings page
  2. Under the Columns section, select a column to view the Edit Column page
  3. The URL of this page includes the internal name in the query string. For example, the URL for the Created By field includes the following query string List=%7BF641CEF1%2DCDE2%2D49E1%2D9800%2D861A408EF890%7D&Field=Author. The value for the Field parameter, Author, is the internal name for Created By.

You can also apply a sort order on your list view on the column that you want get the internal name, this will generate an URL that contains the Internal Name:

FolderCTID%3D0x012000DDDEBA09D4201845A62AEDBA6A906745-SortField%3DAuthor-SortDir%3DAsc-

Now i will demonstrate how you can get Internal Name by Display Name using SPGetStaticFromDisplay

 

var internalName = $().SPServices.SPGetStaticFromDisplay ({
  listName: "Cars",
  columnDisplayName: "Car Models"
});

Read more: http://sympmarc.com/2015/01/27/get-the-internalname-for-a-sharepoint-list-column/

Thanks

Fábio Carvalho
SharePoint Consultant
|create|it|

 

SharePoint – Get all alerts from a specific SP List/Library using Powershell

Hey Everyone!!!

Today i will talk about List and Library Alerts and how can you get all Active alerts for a specific list using powershell script and how can you disable all alerts.

This is very useful script, when you need move a large list of items on a maintenance routine and you don’t want send a large number of emails/ notifications for users who subscribe alerts, this script help you disable and enable them.

This first PowerShell Script get all SharePoint list alerts with state active.

 

Add-PSSnapin Microsoft.SharePoint.PowerShell –ErrorAction SilentlyContinue

#Variables
$WebURL = "http://YourWebUrl"
$ListName="YourListName"

#Function to Get All Active Alerts on a Given List
Function Get-ListAlerts($WebURL, $ListName)
{
  #Get the Web and List objects
  $Web = Get-SPWeb $WebURL
  $List = $web.Lists.TryGetList($ListName)

  #Get All Alerts created in the list - Which are Active
  $ListAlerts = $Web.Alerts | Where-Object {($_.List.Title -eq $List.Title) -and ($_.Status -eq "ON")}

  foreach($Alert in $ListAlerts)
  {
          write-host "Alert' - $($Alert.Title)' Created for User - '$($Alert.User.Name)'"
  }

 #Dispose web object
 $Web.Dispose()
}

#Call the function Appropriately to Disable or Enable Alerts 
Disable-ListAlerts $WebURL $ListName

 

 

If you want disable all alerts on this specific list you just need run the following script.

 

Add-PSSnapin Microsoft.SharePoint.PowerShell –ErrorAction SilentlyContinue

#Variables
$WebURL = "http://YourWebUrl"
$ListName="YourListName"

#Function to Disable All Active Alerts on a Given List
Function Disable-ListAlerts($WebURL, $ListName)
{
  #Get the Web and List objects
  $Web = Get-SPWeb $WebURL
  $List = $web.Lists.TryGetList($ListName)

  #Get All Alerts created in the list - Which are Active
  $ListAlerts = $Web.Alerts | Where-Object {($_.List.Title -eq $List.Title) -and ($_.Status -eq "ON")}

  Write-host "Total Number of Active Alerts Found in the list: $($ListAlerts.Count)" 
 
  #Iterate through each alert and turn it OFF
  foreach($Alert in $ListAlerts)
  {
     $Alert.Status="OFF"
     $Alert.Update()
     write-host "Disabled the Alert' $($Alert.Title)' Created for User '$($Alert.User.Name)'"
  }
 
 #Dispose web object
 $Web.Dispose()
}

#Call the function Appropriately to Disable or Enable Alerts 
Disable-ListAlerts $WebURL $ListName

 

Thanks

Fábio Carvalho
SharePoint Consultant
|create|it|

SharePoint – Using Flows on yours list items and documents

Hey Everyone!!

Today i will talk about Flows!!! March 2017 bring us a new capabilities about integrating Flows with modern libraries, allowing you create interactive in document libraries and list! Probably they will quickly replace the old Event Handler or Event Timer Jobs!…

Flows, introduce a new way to development scheduler to build and respond your business needs, it is very fast to implement them and very intuitive!…with the ability to build zero code processes directly from a SharePoint list. These Flows operate against the entire scope of a list, waiting for data-or driven triggers to launch each process. Flows operate on a single item or document selected in the modern user experience.

You could create Flows using templates or you could create your owns directly inside SharePoint. Selecting a Flow launches the browser based Flow designer. When you save the Flow it’s also added as a drop-down button in that list or library.

Take a look at the flow templates list that you can use:

https://flow.microsoft.com/en-us/services/shared_sharepointonline/sharepoint/

Thanks

Fábio Carvalho
SharePoint Consultant
|create|it|

SharePoint Online – Storage Metrics – Monitor storage usage in your Site Collection

Hey Everyone!!!

Today i will talk about Storage Metrics in your SharePoint Site Collection!!!

Everyone knows what is the main feature on SharePoint that you could interact with and Structure of SharePoint Site Collections! right!? Site Content and Struct (/_layouts/sitemanager.aspx)!!!

Site Content and Structure page, give you a great overview about all your Site Collection structure. This feature, available since Microsoft Office SharePoint Server 2007, give the capability to navigate dynamically on your site collection hierarchy, it is familiar to Windows Explorer in fact. You can see the site collection hierarchy in the navigation pane as a tree view on the left of the Site Content and Structure page.

But, if you need know more details about storage, probably don’t help you as you expect, so in this case you case access to Storage Metrics (/_layouts/storman.aspx).

 

Storage Metrics underneath Site Collection Administration, access to your all sub-sites and libraries in SharePoint Online ( also available for SharePoint 2010, SharePoint 2013 and SharePoint 2016) and give you the information about how much storage they are consuming.

It is great!!! Because Storage Metrics allows you to drill down to each site, library and even folder to show a very granular report on your storage consumption, this is very important if you need migrate a large lists or even you are planning an migration between SharePoint Versions without any 3rd Party tool.

Take a Look:

 

 

Thanks

Fábio Carvalho
SharePoint Consultant
|create|it|

SharePoint 2016 – Create Service Accounts using PowerShell script

Hey Everyone!!!

Today i will show you how can you create SharePoint 2016 Service Accounts using PowerShell script following the Best Practices.

The script not only create all the accounts but also create the respectives OU (Organizational Unit):

  • SharePoint Accounts
  • SQL Accounts

Service Accounts:

 Name Description Local Rights Domain Rights
SP_FarmThe server farm account is used to perform the following tasks:
-Configure and manage the server farm.
-Act as the application pool identity for the SharePoint Central Administration Web site.
-Run the Microsoft SharePoint Foundation Workflow Timer Service.
SecurityAdmin and DB_Creator rights on the SQL InstanceDomain User
SP_AdminThe server farm account is used to perform the following tasks:
-Setup
-SharePoint Products Configuration Wizard
Local Administrator on all the SharePoint Servers. SecurityAdmin and DB_Creator rights on the SQL InstanceDomain User
SP_PoolThe Pool account is used to run the Web Application PoolsNoneDomain User
SP_ServicesThe Services Account is used to run the Service Application PoolNoneDomain User
SP_CrawlThe Default Content Access Account for the Search Service ApplicationNoneDomain User
SP_SearchService Account to run the SharePoint Search “Windows Service”NoneDomain User
SP_UserProfilesThe User Profile Synchronization AccountNoneDomain User
SP_MySitePoolUsed for the My Sites Web ApplicationNoneDomain User
SP_CacheSuperUserObject Cache Service Account. The goals of the object cache are to reduce the load on the computer on which SQL Server is running, and to improve request latency and throughput. These user account must be properly configured to ensure that the object cache works correctly.None.
SharePoint: Must be an account that has Full Control access to the Web application.
Domain User
SP_CacheSuperReaderObject Cache Service Account. The goals of the object cache are to reduce the load on the computer on which SQL Server is running, and to improve request latency and throughput. These user account must be properly configured to ensure that the object cache works correctly.None.
SharePoint: Must be an account that has Full Read access to the Web application
Domain User
WF_ServiceWorkFlow Manager Service AccountLocal Administrator and SysAdmin rights on the SQL instance.Domain User
SP_MySitePoolUsed for the My Sites Web ApplicationNoneDomain User
SP_VisioUserVisio Unattended IDNoneDomain User
SP_ExcelUserExcel Unattended IDNoneDomain User
SP_PerfPointUserPerformance Point Unattended IDNoneDomain User
SQL_AdminSQL Admin on the SQL Server. Used to Install the SQL Server.Local Administrator on the SQL ServerDomain User
SQL_ServicesIt is the service account for the following SQL Server services: MSSQLSERVER SQLSERVERAGENTNoneDomain User


Script:

 

$mydom = (get-addomain).distinguishedname 
$password = "pass@word1" | ConvertTo-SecureString -AsPlainText -Force 

$ouNameSP = "SharePoint Accounts"
$oudnSP = "OU=$ounameSP,$mydom" 

$ouNameSQL = "SQL Accounts" 
$oudnSQL = "OU=$ounameSQL,$mydom" 

#----------------------------> Organizational Unit <---------------------------- 

New-ADOrganizationalUnit -Name $OUNameSP -Path $mydom 
Write-Host "OU $OUNameSP Created" -foregroundcolor green 

New-ADOrganizationalUnit -Name $OUNameSQL -Path $mydom 
Write-Host "OU $OUNameSQL Created" -foregroundcolor green 

#-----------------------------> SharePoint 2016 <-------------------------------

$usersArraySP = @("SP_Farm","SP_Admin","SP_Pool","SP_Services","SP_Crawl","SP_Search",
                  "SP_UserProfiles","SP_PortalSuperReader","SP_CacheSuperUser","SP_VisioUser",
                  "SP_PerfPointUser","WF_Service","SP_MySitePool","SP_PortalSuperUser")

foreach ($usp in $usersArraySP) {
        New-ADUser -Name $usp -DisplayName $usp -SamAccountName $usp -AccountPassword $password 
        -ChangePasswordAtLogon $false -PassThru -PasswordNeverExpires $true -Path $oudnSP 
        Write-Host "$usp Created" -foregroundcolor green
 }

#----------------------------------> SQL <--------------------------------------
$usersArraySQL = @("SQL_Admin","SQL_Service")

foreach ($usql in $usersArraySQL) {
       New-ADUser -Name $usql -DisplayName $usql -SamAccountName $usql -AccountPassword $password 
       -ChangePasswordAtLogon $false -PassThru -PasswordNeverExpires $true -Path $oudnSQL
       Write-Host "$usql Created" -foregroundcolor green
 }

 

Thanks

Fábio Carvalho
SharePoint Consultant
|create|it|

SharePoint Scenarios – Online, On-Premises or Hybrid!?

Hey Everyone!!!

Today i’m going to talk about SharePoint Scenarios and what are the main difference between this three types of scenarios and what scenario should be the option for your environment…

So, the three types of architecture scenario that you can have on your SharePoint environment are the following:

What should you choose?! Well in fact there are so many question that you need answered before take an decision!?

 

It isn’t easy take a decision, let’s analyse what are the main benefits each architecture:

SharePoint On-Premises:

  • Private Cloud
  • Dedicated environment
  • Internally hosted
  • Internally managed
  • Internal designed
 ProsCons
Control PerformanceCost of internal resources (staff, hardware, software, etc)
Scale Up and Scale OutAdditional Geographic redundancy costs
Reduces Bandwidth requirementsDisaster Recovery dependent on internal capabilities
Full CustomizationScale Up/Out Cost( SW/HW)
Full Server and SQL DatabasePatching Servers/farms
Migrate as NeededExtra configurations for External Collaboration
Seamless Single Sign on with Corporate Active Directory
  • Migration Flow:

SharePoint Online:

  • Public Cloud
  • Partially or fully dedicated
  • Externally hosted
  • Externally or Internally managed
  • Internally managed
  • Minimal customization

Cloud benefits according to cloud users?

  • Increase efficiency (55 %)
  • Improved employee mobility (49 %)
  • Increased ability to Innovate (32 %)
  • Freed current IT staff for other projects (31 %)
  • Reduce IT operation costs (25 %)
  • Enabled us to offer new products/ services (24 %)
 ProsCons
Uptime 99.99%More ISP Bandwidth
Multiple Data centersLimited Customizations
Shorted release cycleRecovery SLAs
Geographically redundant and ScalabilityNo Server access
Managed Services ( SaaS)
Pay as you go ( Low Cost )
Reduced impact on internal IT resources
  • Migration Flow:

SharePoint Hybrid Solution:

What is Hybrid SharePoint?

“Productivity services in SharePoint Online (Office 365) which are securely integrated with on-premises SharePoint Server 2016 to provide unified functionality and access to data.”

Why considering a Hybrid SharePoint Solution?

  • Large existing investments (customized SP deployments w/lots of data and settings,custom solutions, LOB systems, etc…)
  • Functionalities I can’t do in the Cloud that i can do on premises;
  • Keep Sensitive Data on Premise
  • Collaboration with External Partners
  • Capacity Flexibility
  • Intranet – Extranet
  • Geo Location

Same Benefits of Hybrid SharePoint Solution?

SharePoint Business to Business Collaboration: Extranet for Partners with Office 365

“on-premises extranet site involves complex configuration to establish security measures and governance, including granting access inside the corporate firewall, and expensive initial and on-going cost….SharePoint Online, partners connect directly to a members-only site in Office 365, without access to the corporate on-premises environment or any other Office 365 site. Office 365 Extranet sites can be accessed anywhere…”

SharePoint hybrid sites and search

“A hybrid environment can help your company get started in the cloud, taking a first step to explore the cloud functionality at own your pace. It also enables enterprise users to be connected from almost anywhere to the resources and content they need… SharePoint hybrid features, you can consolidate search results between SharePoint Server and Office 365, consolidate user profiles in Office 365, and offload your users’ personal storage to the cloud…”

  • Migration/Interactions Flow:

Thanks

Fábio Carvalho
SharePoint Consultant
|create|it|

 

SharePoint Templates – Understand the differences

Hey Everyone!

Today i will talk about SharePoint Site Templates, and explain the main difference between each template and how it is extremely important to have in mind what each version can offer you in terms of features and capabilities to meets your business needs.

So the first thing you must know is there are 3 main categories of templates:

  • Collaboration
  • Enterprise
  • Publishing

For each category you have different site types, when you create a new site the “site type” define the purpose of the new one and includes all the features.

Collaboration site templates:
  • Team Site – This template can be  used when you what organize and share information with your team or project members, this template includes lists and libraries for: Share Documents, Announcements, Calendars, Links, Tasks, Discussion Board.

  • Blog Site – This template can be  used when you what announce company announcements, post ideas, observations, expertise with your team organization. It is easy  start a new blog, including Comments and Links.

  • Project Site – With this site template it is so much easy to manage your projects, it is an upgrade of Team Site but this one have more functionalities including Projects Summary, Task Lists. Calendar Sharing, Task Scheduler, Visual Timeline of the Project’s Tasks.

  • Community Site – It is more than a Blog Site, this template you can create a place where you can discuss topics that you have in common with others team members, it is more easy and you have more benefits over email, with a full retention of discussion history in compliance with corporate guidelines.
Enterprise site templates:
  • Document Center Site – This template is indicated when you want manage large numbers of documents, it is more easy create folder structures and use file versions also you can use workflows to control document life cycles.

  • Records Center Site – This template is indicated when you what organize, store and manage records such as legal or financial documents, the site includes versioning, auditing, metadata management, eDiscovery feature to help manage records more effectively.

  • Business Intelligence (BI) Center Site – This is one of my favorite site template, you can store, manage, share and view business reports, scorecards and dashboards. This template includes Performance Point Service, a service very important to build dashboards inside of SharePoint.

  • Search Center (Enterprise or Basic) Site – A template dedicated to search features where you can search and apply refiners to your search results.

Publishing site templates:
  • Publishing Site – The template indicated when you want create enterprise intranets, communication portals and public websites. This template by default have publishing features enable including Page Layouts, Column Types, Web Parts, Lists and very important Documents and image libraries for storing web publishing assets.

  • Publishing Site with Workflow – Use the Publishing site with workflow to publish web pages on a schedule by using approval workflows. It includes document and image libraries for storing web publishing assets.

  • Enterprise Wiki – It is a publishing site for sharing and updating large volumes of information across an enterprise,  your organization can centralized knowledge repository.

The follow table show all Templates available for each SharePoint version.

Category
Site Type
Template ID
Site Collection
Site
SharePoint Server 2013
SharePoint Foundation 2013
SharePoint Server 2016
SharePoint Online
CollaborationTeamSTS#0YesYesYesYesYesYes
CollaborationBlogBLOG#0YesYesYesYesYesYes
CollaborationProjectPROJECTSITE#0YesYesYesNoYesYes
CollaborationCommunitySPSCOMMU#0YesYesYesNoYesYes
EnterpriseDocument CenterBDR#0YesYesYesNoYesYes
EnterpriseRecords CenterOFFILE#1YesYesYesNoYesYes
EnterpriseBusiness Intelligence CenterBICenterSite#0YesYesYesNoYesYes
EnterpriseEnterprise Search CenterSRCHCEN#0YesYesYesNoYesYes
EnterpriseBasic Search CenterSRCHCENTERLITE#0NoYesYesNoYesYes
PublishingPublishing SiteBLANKINTERNET#0NoYesYesNoYesYes
PublishingPublishing Site with WorkflowBLANKINTERNET#2NoYesYesNoYesYes
PublishingEnterprise  WikiENTERWIKI#0NoYesYesNoNoYes

 

Also you have different types of site template variation, the following table show ALL the Template ID available, and you can you use powershell command to create them.

New-SPWeb http://createIT/blog -Template "BLOG#0"
Template ID
Title
GLOBAL#0Global template
STS#0Team Site
STS#1Blank Site
STS#2Document Workspace
MPS#0Basic Meeting Workspace
MPS#1Blank Meeting Workspace
MPS#2Decision Meeting Workspace
MPS#3Social Meeting Workspace
MPS#4Multipage Meeting Workspace
CENTRALADMIN#0Central Admin Site
WIKI#0Wiki Site
BLOG#0Blog
SGS#0Group Work Site
TENANTADMIN#0Tenant Admin Site
APP#0App Template
APPCATALOG#0App Catalog Site
ACCSRV#0Access Services Site
ACCSRV#1Assets Web Database
ACCSRV#3Charitable Contributions Web Database
ACCSRV#4Contacts Web Database
ACCSRV#5Projects Web Database
ACCSRV#6Issues Web Database
ACCSVC#0Access Services Site Internal
ACCSVC#1Access Services Site
BDR#0Document Center
DEV#0Developer Site
DOCMARKETPLACESITE#0Academic Library
EDISC#0eDiscovery Center
EDISC#1eDiscovery Case
OFFILE#0(obsolete) Records Center
OFFILE#1Records Center
OSRV#0Shared Services Administration Site
PPSMASite#0PerformancePoint
BICenterSite#0Business Intelligence Center
SPS#0SharePoint Portal Server Site
SPSPERS#0SharePoint Portal Server Personal Space
SPSPERS#2Storage And Social SharePoint Portal Server Personal Space
SPSPERS#3Storage Only SharePoint Portal Server Personal Space
SPSPERS#4Social Only SharePoint Portal Server Personal Space
SPSPERS#5Empty SharePoint Portal Server Personal Space
SPSMSITE#0Personalization Site
SPSTOC#0Contents area Template
SPSTOPIC#0Topic area template
SPSNEWS#0News Site
CMSPUBLISHING#0Publishing Site
BLANKINTERNET#0Publishing Site
BLANKINTERNET#1Press Releases Site
BLANKINTERNET#2Publishing Site with Workflow
SPSNHOME#0News Site
SPSSITES#0Site Directory
SPSCOMMU#0Community area template
SPSREPORTCENTER#0Report Center
SPSPORTAL#0Collaboration Portal
SRCHCEN#0Enterprise Search Center
PROFILES#0Profiles
BLANKINTERNETCONTAINER#0Publishing Portal
SPSMSITEHOST#0My Site Host
ENTERWIKI#0Enterprise Wiki
PROJECTSITE#0Project Site
PRODUCTCATALOG#0Product Catalog
COMMUNITY#0Community Site
COMMUNITYPORTAL#0Community Portal
SRCHCENTERLITE#0Basic Search Center
SRCHCENTERLITE#1Basic Search Center
SRCHCENTERFAST#0FAST Search Center
VISPRUS#0Visio Process Repository

 

Fonts:
Using templates to create different kinds of SharePoint sites
SharePoint templates and their IDs

Thanks

Fábio Carvalho
SharePoint Consultant
|create|it|

SharePoint – Export all solutions wsp using PowerShell script

Hey Everyone,

Today i will post a script very helpful when you are on Migration steps and you need export all wsp solutions.

 

$dirName = "C:\WSP"
if (!(Test-Path -path $dirName))
{
New-Item $dirName -type directory
}
Write-Host Exporting solutions to $dirName
foreach ($solution in Get-SPSolution)
{
    $id = $Solution.SolutionID
    $title = $Solution.Name
    $filename = $Solution.SolutionFile.Name
    Write-Host "Exporting ‘$title’ to …\$filename" -nonewline
    try {
        $solution.SolutionFile.SaveAs("$dirName\$filename")
        Write-Host " – done" -foreground green
    }
    catch
    {
        Write-Host " – error : $_" -foreground red
    }
}

Thanks

Fábio Carvalho
SharePoint Consultant
|create|it|

SharePoint 2016 – TCP/IP Ports

Hey Everyone!!!

Today i will show you the full list of TCP/IP Ports that you must consideration on your SharePoint 2016 Farm.

Full list of ports used by SharePoint 2016:

Protocol
Port
Usage
Comment
TCP80httpClient to SharePoint web server traffic
(SharePoint – Office Online Server/Office Web Apps communication)
TCP443https/sslEncrypted client to SharePoint web server traffic
(Encrypted SharePoint – Office Online Server/Office Web Apps communication)
TCP1433SQL Server default communication port.May be configured to use custom port for increased security
UDP1434SQL Server default port used to establish connectionMay be configured to use custom port for increased security
TCP445SQL Server using named pipesWhen SQL Server is configured to listen for incoming client connections by using named pipes over a NetBIOS session, SQL Server communicates over TCP port 445
TCP25SMTP for e-mail integrationCannot in 2016 be configured (Use SMTP ports other than the default (25).)
TCP16500-16519Ports used by the search index componentIntra-farm only
Inbound rule Added to Windows firewall by SharePoint. (GPO may override this change)
TCP22233-22236Ports required for the AppFabric Caching ServiceUsed by the Distributed Cache…
TCP808Search – Query processing component
Windows Communication Foundation communication
Search – Query processing component
(WCF)
TCP32843Communication between Web servers and service applicationshttp (default) To use custom port, see references section
Inbound rule Added to Windows firewall by SharePoint
TCP32844Communication between Web servers and service applicationshttps
Inbound rule Added to Windows firewall by SharePoint
TCP32845net.tcp binding: TCP 32845 (only if a third party has implemented this option for a service application) Custom Service Applications
Inbound rule Added to Windows firewall by SharePoint
TCP32846Microsoft SharePoint Foundation User Code Service (for sandbox solutions) Inbound on all Web Servers
Inbound rule Added to Windows firewall by SharePoint
Outbound on all Web and App servers with service enabled.
TCP636User Profile Synchronization Service/Active Directory ImportSynchronizing profiles between SharePoint 2016 and AD using SLDAP (Secure LDAP)
TCP5725User Profile Synchronization ServiceSynchronizing profiles between SharePoint 2016 and Active Directory Domain Services (AD DS)
TCP + UDP389User Profile Synchronization ServiceLDAP Service
TCP + UDP88User Profile Synchronization ServiceKerberos
TCP + UDP53User Profile Synchronization ServiceDNS
UDP464User Profile ServiceKerberos change password
TCP809Office Online Server/Office Web AppsOffice Online Server/Office Web Apps intra-farm communication.

 

Reference Links:

Security for SharePoint Server 2016
Set-SPServiceHostConfig
TCP/IP Communications (Windows Server AppFabric Caching)

Thanks

Fábio Carvalho
SharePoint Consultant
|create|it|