SharePoint (and Project Server) Shenanigans

So today my colleague needed help with returning the Project Server database names from PowerShell.

The usual process occurs here within CPS in this scenario, email to the whole team asking the question and this results in a variety of response from the sensible to the ridiculous to achieve the end goal.

The sensible suggestions is as follows:

PowerShell:

Get-SPProjectWebInstance

Example Output: