Get PWA Instance details via SharePoint Management Shell in Project Server

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.

Application Management

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

missing-view-edit-delete-options-within-manage-project-web-apps-in-project-server (2)

To know the root cause of missig  “View, Edit, Delete” options within 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  a PWA Instance details with its related content database via SharePoint Management Shell, by following the mentioned steps below:

Steps:

  • Run SharePoint Managemen Shell  as Administrator.

Run SharePoint Management Shell as Administrator - Devoworx

  • Run the following cmdlet.
Get-SPProjectWebInstance -Url http://server/pwa
  • This cmdlet should show all related information for a particular PWA Instance as:
    • The name of the service application that connected to this instance.
    • The name and port of the web application that hold 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: 

  • Via Central Administration.
    • Open Central Administration > Application Management > Site Collections > View all site collections.View all site collections - SharePoint - devoworx
    • Make sure that you select 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

  • Via SharePoint Management Shell.
    • Run SharePoint Management Shell as administrator.
    • Run the following cmdlet.
Get-SPContentDatabase -site http://pwa/epm
  • This cmdlet should show all related information for specific Content DataBase of  PWA Instance 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 - DevoworxEnjoy 🙂

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s