Public/Get-RubrikSQLInstance.ps1

#requires -Version 3
function Get-RubrikSQLInstance
{
<#
    .SYNOPSIS
    Gets internal Rubrik object that represents a SQL Server instance

    .DESCRIPTION
    Returns internal Rubrik object that represents a SQL Server instance. This

    .NOTES
    Written by Mike Fal for community usage
    Twitter: @Mike_Fal
    GitHub: MikeFal

    .LINK
    https://rubrik.gitbook.io/rubrik-sdk-for-powershell/command-documentation/reference/get-rubriksqlinstance

    .EXAMPLE
    Get-RubrikSQLInstance -Name MSSQLSERVER
    Retrieve all default SQL instances managed by Rubrik

    .EXAMPLE
    Get-RubrikSQLInstance -ServerInstance msf-sql2016
    Retrieve the default SQL instance on host msf-sql2016

    .EXAMPLE
    Get-RubrikSQLInstance -Hostname msf-sql2016
    Retrieves all the SQL instances on host msf-sql2016

    .EXAMPLE
    Get-RubrikSQLInstance -PrimaryClusterID local
    Only return SQLInstances of the Rubrik cluster that is hosting the current REST API session.

    .EXAMPLE
    Get-RubrikSQLInstance -PrimaryClusterID 8b4fe6f6-cc87-4354-a125-b65e23cf8c90
    Only return SQLInstances of the specified id of the Rubrik cluster that is hosting the current REST API session.
#>


[CmdletBinding(DefaultParameterSetName = 'Query')]
  Param(
       # Name of the instance
       [Parameter(
        ParameterSetName='Query',
        Position = 0)]
       [Alias('InstanceName')]
       [String]$Name,
       # SLA Domain policy assigned to the database
       [String]$SLA,
       # Name of the database host
       [String]$Hostname,
       #ServerInstance name (combined hostname\instancename)
       [String]$ServerInstance,
       # Filter the summary information based on the primarycluster_id of the primary Rubrik cluster. Use: local as the primary_cluster_id of the Rubrik cluster that is hosting the current REST API session.
       [Alias('primary_cluster_id')]
       [String]$PrimaryClusterID,
       # Rubrik's database id value
       [Parameter(
        ParameterSetName='ID',
        Position = 0,
        Mandatory = $true,
        ValueFromPipelineByPropertyName = $true)]
       [String]$id,
       # SLA id value
       [String]$SLAID,
       # Rubrik server IP or FQDN
       [String]$Server = $global:RubrikConnection.server,
       # API version
       [ValidateNotNullorEmpty()]
       [String]$api = $global:RubrikConnection.api
  )

  Begin {

    # The Begin section is used to perform one-time loads of data necessary to carry out the function's purpose
    # If a command needs to be run with each iteration or pipeline input, place it in the Process section

    # Check to ensure that a session to the Rubrik cluster exists and load the needed header data for authentication
    Test-RubrikConnection

    # API data references the name of the function
    # For convenience, that name is saved here to $function
    $function = $MyInvocation.MyCommand.Name

    # Retrieve all of the URI, method, body, query, result, filter, and success details for the API endpoint
    Write-Verbose -Message "Gather API Data for $function"
    $resources = Get-RubrikAPIData -endpoint $function
    Write-Verbose -Message "Load API data for $($resources.Function)"
    Write-Verbose -Message "Description: $($resources.Description)"

    #region one-off
    if($ServerInstance){
        $SIobj = ConvertFrom-SqlServerInstance $ServerInstance
        $Hostname = $SIobj.hostname
        $Name = $SIobj.instancename
    }
    #endregion
  }

  Process {

      # If connected to RSC, redirect to new GQL cmdlet
      if ($global:rubrikConnection.RSCInstance) {
        Write-Verbose -Message "Cluster connected to RSC instance, redirecting to Get-RubrikRSCSqlInstance"
        $response = Get-RubrikRSCSQLInstance @PSBoundParameters
        return $response
      }

    $uri = New-URIString -server $Server -endpoint ($resources.URI) -id $id
    $uri = Test-QueryParam -querykeys ($resources.Query.Keys) -parameters ((Get-Command $function).Parameters.Values) -uri $uri
    $body = New-BodyString -bodykeys ($resources.Body.Keys) -parameters ((Get-Command $function).Parameters.Values)
    $result = Submit-Request -uri $uri -header $Header -method $($resources.Method) -body $body
    $result = Test-ReturnFormat -api $api -result $result -location $resources.Result
    $result = Test-FilterObject -filter ($resources.Filter) -result $result
    $result = Set-ObjectTypeName -TypeName $resources.ObjectTName -result $result

    return $result

  } # End of process
} # End of function