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 |