Get-RubrikSQLInstance

SYNOPSIS

Gets internal Rubrik object that represents a SQL Server instance

SYNTAX

Query (Default)

Get-RubrikSQLInstance [[-Name] <String>] [-SLA <String>] [-Hostname <String>] [-ServerInstance <String>]
 [-PrimaryClusterID <String>] [-SLAID <String>] [-Server <String>] [-api <String>] [<CommonParameters>]

ID

Get-RubrikSQLInstance [-SLA <String>] [-Hostname <String>] [-ServerInstance <String>]
 [-PrimaryClusterID <String>] [-id] <String> [-SLAID <String>] [-Server <String>] [-api <String>]
 [<CommonParameters>]

DESCRIPTION

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

EXAMPLES

EXAMPLE 1

Get-RubrikSQLInstance -Name MSSQLSERVER

Retrieve all default SQL instances managed by Rubrik

EXAMPLE 2

Get-RubrikSQLInstance -ServerInstance msf-sql2016

Retrieve the default SQL instance on host msf-sql2016

EXAMPLE 3

Get-RubrikSQLInstance -Hostname msf-sql2016

Retrieves all the SQL instances on host msf-sql2016

EXAMPLE 4

Get-RubrikSQLInstance -PrimaryClusterID local

Only return SQLInstances of the Rubrik cluster that is hosting the current REST API session.

EXAMPLE 5

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.

PARAMETERS

-Name

Name of the instance

Type: String
Parameter Sets: Query
Aliases: InstanceName

Required: False
Position: 1
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-SLA

SLA Domain policy assigned to the database

Type: String
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-Hostname

Name of the database host

Type: String
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-ServerInstance

ServerInstance name (combined hostname\instancename)

Type: String
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-PrimaryClusterID

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.

Type: String
Parameter Sets: (All)
Aliases: primary_cluster_id

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-id

Rubrik's database id value

Type: String
Parameter Sets: ID
Aliases:

Required: True
Position: 1
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: False

-SLAID

SLA id value

Type: String
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-Server

Rubrik server IP or FQDN

Type: String
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: $global:RubrikConnection.server
Accept pipeline input: False
Accept wildcard characters: False

-api

API version

Type: String
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: $global:RubrikConnection.api
Accept pipeline input: False
Accept wildcard characters: False

CommonParameters

This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutVariable, -OutBuffer, -PipelineVariable, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.

INPUTS

OUTPUTS

NOTES

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

RELATED LINKS

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