locked
How to Get Database name of running Service Application RRS feed

  • Question

  • Hi,

    Is there any way/Powershell command to get specific SharePoint Service Application Database Name?


    Vishal Goyal

    Saturday, September 26, 2015 6:50 AM

All replies

  • You can see by CA or using this ps script

    Get-SPDatabase | Sort-Object Name | Format-Table Name


    • Marked as answer by Vishal_Goyal Saturday, September 26, 2015 7:28 AM
    • Unmarked as answer by Vishal_Goyal Saturday, September 26, 2015 7:28 AM
    Saturday, September 26, 2015 6:54 AM
  • I have got the Database name by below steps-

    Central Admin-Application Management-Service Application-Manage Service Application-Select Service Name-Select Properties in Ribbon


    Vishal Goyal

    • Marked as answer by Vishal_Goyal Saturday, September 26, 2015 7:27 AM
    • Unmarked as answer by Vishal_Goyal Saturday, September 26, 2015 7:27 AM
    • Marked as answer by Vishal_Goyal Saturday, September 26, 2015 7:27 AM
    • Unmarked as answer by Vishal_Goyal Saturday, September 26, 2015 7:28 AM
    Saturday, September 26, 2015 7:26 AM
  • There is no direct command to get database used by service application. What you can do is view settings of service application in central administration as already figured by you. Alternatively you can run get-spdatabase command against database id and check typename. This would give you a fair idea of associated service application.

    Below are a couple of runs:

    1. For App management service app:

    2. for word automation service app:

    Hope this helps.


    Thanks Mohit


    • Edited by mohit.goyal Saturday, September 26, 2015 8:01 AM
    Saturday, September 26, 2015 8:01 AM