Get PWA Instance details via SharePoint Management Shell in Project Server

In this article, I will explain How To

Get PWA Project Instance Details Using PowerShell


When I tried to get the Project Web App database name for a particular PWA Instance via navigating to:

  • Central Administration > Application Management > Manage Service Application > Manage Project Web Apps.

Manage Service Application in SharePoint

But unfortunately, I couldn’t find  “View, Edit, Delete” options as shown below:

Manage Project Web Apps - Project Server - DevoWorx

To know the root cause of missig  “View, Edit, Delete” options In Manage Project Web App inside Central Administration, you should check View, Edit, Delete options are missing within Manage Project Web Apps in Project Server.

In this hint, I will explain How to get PWA Instance details with its related content database via SharePoint Management Shell, by following the mentioned steps below:


Steps:

Get PWA Instance Details in Project Server Using PowerShell

  • Run SharePoint Managemen Shell as Administrator.

Run SharePoint Management Shell as Administrator - Devoworx

  • Run the following cmdlet.
Get-SPProjectWebInstance -Url http://server/pwa

This “Get-SPProjectWebInstance” cmdlet shows all related information for PWA Instance In Project Server as:

  • The name of the service application that connected to this instance.
  • The name and port of the web application that holds the PWA Instance.
  • The admin account used to provision the PWA Instance.
  • Project Database name
  • Database Server.

Get Project Web Instance via Shell - Project Server - Devoworx

Unfortunately, The previous command didn’t retrieve any details related to PWA Content Database, So in the next section I will show How to get the PWA content database details using PowerShell


Get PWA Instance Content Database In Project Server 

Get PWA Instance Content Database In Project Server Using Central Administration

  • Open Central Administration > Application Management > Site Collections > View all site collections.

View all site collections - SharePoint - devoworx

  • Make sure that you have selected the correct web application > Click on the PWA instance name.
  • In the right side, The related content database should be shown.

Site Collection List - SharePoint - Devoworx

Get PWA Instance Content Database In Project Server Using PowerShell

  • Run SharePoint Management Shell as administrator.
  • Run the following cmdlet.
Get-SPContentDatabase -site http://pwa/epm

This “Get-SPContentDatabase” cmdlet shows all related information for PWA Instance Content DataBase as:

  • Content Database name.
  • The name and port of the web application.
  • Database Server.
  • The number of site collections that have been created inside the content database.

Get-SPContentDatabase - SharePoint - Devoworx


Applies To
  • Project Server 2016.
  • Project Server 2013.
  • Project Server 2010.
Advertisements

3 thoughts on “Get PWA Instance details via SharePoint Management Shell in Project Server

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s