Get-sqmServerSetting - sqmSQLTool PowerShell Cmdlet Documentation

Get-sqmServerSetting

SQL Config sqmSQLTool v1.8.2+

Reads one or all server properties from a SQL Server instance.

Examples

# Read BackupDirectory from the local server

# Read BackupDirectory from the local server
$backupPath = Get-sqmServerSetting -Name "BackupDirectory"

# Show all properties

# Show all properties
Get-sqmServerSetting -All

# All properties from a remote instance with credentials

# All properties from a remote instance with credentials
$cred = Get-Credential
Get-sqmServerSetting -SqlInstance "SQL01" -SqlCredential $cred -All