Post a Comment

Popular posts from this blog

For a long time I have
been waiting for the reporting API for Planner and Staffhub. Today I got tired
of waiting and found another way to do it.

I manage to create a
PowerBI report based on all the planner plans I have access to and the same
method will work for Staffhub and properly many other services such as
Microsoft Tasks, Microsoft Forms, etc.

How?Easy, but requires
some Azure, Flow and PowerBI knowledge. These are the steps to
I used: 1.Create an
Azure Blob to hold the data 2.Create a
Flow to save Planner data in the Blob 3.Access the
Blob from PowerBI Azure – Blob!So first, lets create
a Blob. No, not that kind of
Blob. Access the Azure
portal - https://portal.azure.com/ Select New and search
for “storage account” Fill out the form and
click create. I kept all settings to their default Access the new storage
and locate/copy the Storage Account Name and Access Key – you will need this
for connections to Flow and PowerBI. Next let’s create a
Blob Container an…

Firewall port open list
Every time I have to install a new instance of Project Server I forget which ports have to be open.
The ports are divided into 3 lists, one list for the web front end servers, one list for the application server and one list for the SQL server.
These ports are based on a 2013 installation of SharePoint/Project Server. the 2010 installation defer a little bit.

Web Frontend ServerWhen a range is
specified all ports between the range must be opened. Port(s)ProtocolBoundDescription-80 TCPInhttp-443 TCPInhttps/ssl-25 TCPInSMTP
for e-mail integration-16500-16519TCPInPorts used by the search
index component-22233-22236TCPIn/OutPorts required for the
AppFabric Caching Service-32843-32845TCPInCommunication between Web
servers and service applications-32846TCPIn/OutSharePoint User Code Service-808-809TCPInOffice Web Apps-5725TCP