One Liners in SharePoint for Databases

#Get the database servers related to SQL Server Reporting Services

Get-SPDatabase | ?{$_.Name -like "SQL Server Reporting Services*"}|select Name,DatabaseConnectionstring

#Get all Sharepoint Content Databases

Get-SPDatabase

#View all content database

Get-SPDatabase |select TYpe  -Unique

#View all servers hosting SharePoint content database

Get-SPDatabase |select Server -Unique

#View details of Managed Metadata service

Get-SPDatabase | ?{$_.Name -like "*Managed Metadata*"}|Format-List

#Scaled Out Database for Service Applications
#View all scaled out database for a service application
#example gets all scale-out databases for the given service application by using the $serviceApplication
#variable.
$serviceApplication = Get-SPServiceApplication -Name "App Management Service"
Get-SPScaleOutDatabase -ServiceApplication $serviceApplication
#View Name of the Scale out Database
(Get-SPScaleOutDatabase -ServiceApplication $serviceApplication).Name
#View Database Connection String of Scale Out Database
$dbConnection=(Get-SPScaleOutDatabase -ServiceApplication $serviceApplication).DatabaseConnectionString
Get-SPScaleOutDatabaseDataState -ConnectionString $dbConnection
#Get all scale out inconsistencies for the given service application
Get-SPScaleOutDatabaseInconsistency -ServiceApplication $serviceApplication
#View the 10 most recent scale out log entries for the given App Service Application
$serviceApplication.Databases |Get-SPScaleOutDatabaseLogEntry -Count 10
#Server Scale Out Database
 #View Scale out databse of all Service Aplication
$serviceApp = Get-SPServiceApplication
for ($i = 0; $i -lt $serviceApp.Count; $i++)
{
  Get-SPServerScaleOutDatabase -ServiceApplication $serviceApp[$i] 
}
#View for Search App Server Scale out database
Get-SPServerScaleOutDatabase -ServiceApplication (Get-SPServiceApplication -Name "Search Service Application")
#Two line version
$searchApp= Get-SPServiceApplication -Name "Search Service Application"
$serverScaleDB=Get-SPServerScaleOutDatabase -ServiceApplication $searchApp
#database Connection string
$dbString = (Get-SPServerScaleOutDatabase -ServiceApplication $searchApp).DatabaseConnectionString
#View DB Name
(Get-SPServerScaleOutDatabase -ServiceApplication $searchApp).DisplayName
#View Database State
#One Line
Get-SPServerScaleOutDatabaseDataState -ConnectionString (Get-SPServerScaleOutDatabase -ServiceApplication $searchApp).DatabaseConnectionString
#Two Line
$dbString = (Get-SPServerScaleOutDatabase -ServiceApplication $searchApp).DatabaseConnectionString
 Get-SPServerScaleOutDatabaseDataState -ConnectionString $dbString
 #View Database Inconsistency
 #One Line
 Get-SPServerScaleOutDatabaseInconsistency -ServiceApplication (Get-SPServiceApplication -Name "Search Service Application")
 #Two Line
 Get-SPServerScaleOutDatabaseInconsistency -ServiceApplication $searchApp
 #Get 10 entriesLog Entry for Server Scale out database
 #One Line
 Get-SPServerScaleOutDatabaseLogEntry -Database (Get-SPServerScaleOutDatabase -ServiceApplication  (Get-SPServiceApplication -Name "Search Service Application")) -Count 10
 #Two line version
 $serverScaleDB=Get-SPServerScaleOutDatabase -ServiceApplication $searchApp
 Get-SPServerScaleOutDatabaseLogEntry -Database $serverScaleDB -Count 10