PowerShell Session State Demonstration

ShowSessionState.ps1

function Show-SessionStateDemo
{
[CmdletBinding()]
  param (

  [Parameter()]
  $Server,

  [Parameter()]
  $Database,

  [Parameter()]
  $Query
  
  )

  begin {
   
   $privateServerVariable = '_privServer'
   
   if($Server) {
    $PSCmdlet.SessionState.PSVariable.Set($privateServerVariable,$Server)
   }

   else {
    try {
      $Server = $PSCmdlet.SessionState.PSVariable.GetValue($privateServerVariable).ToString()
    }
    Catch {Throw 'The parameter "Server" is required'}
    }
  
  }

  process {
  
  [psobject]@{
    'Database' = $Database
    'Server' = $Server
    'Query' = $Query
     }
  }

}