Get SQL Server Backup Folder powershell

GetMSSQLBackupFolder.ps1

Import-Module sqlps

Function GetMSSQLBackupFolder
{

  param([string]$ServerInstance)
  
  # taken from https://www.mssqltips.com/sqlservertip/1966/function-to-return-default-sql-server-backup-folder/
  $GetBackupFolder = "EXEC  master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer',N'BackupDirectory'"
  return (Invoke-sqlcmd -ServerInstance $ServerInstance -Query $GetBackupFolder).Data

}

GetMSSQLBackupFolder -ServerInstance "localhost\SQLEXPRESS"