Get-SCSQLDeployment

Gets a SQL Server deployment.

Description

The Get-SCSQLDeployment cmdlet gets a SQL Server deployment.

For more information about Get-SCSQLDeployment, type: "Get-Help Get-SCSQLDeployment -online".

Parameters

ID

Required? true
Accept Pipeline Input? false
Position? named
Specifies the numerical identifier (as a globally unique identifier, or GUID) for a specific object.

VMMServer

Required? false
Accept Pipeline Input? true (ByValue)
Position? named
Specifies a VMM server object.

SQLConfigurationFile

Required? false
Accept Pipeline Input? false
Position? named
Specifies a SQL Server configuration file.

VMMServer

Required? false
Accept Pipeline Input? true (ByValue)
Position? named
Specifies a VMM server object.

SQLProfile

Required? true
Accept Pipeline Input? true (ByValue)
Position? named
Specifies a SQL Server profile object.

Name

Required? false
Accept Pipeline Input? false
Position? named
Specifies the name of a VMM object.

VMMServer

Required? false
Accept Pipeline Input? true (ByValue)
Position? named
Specifies a VMM server object.

Examples

1: Get a specific SQL Server deployment object from an existing SQL Server profile
PS C:\> $SQLProfile = Get-SCSQLProfile -Name "SQLProfile01"
PS C:\> $SQLDeployment = Get-SCSQLDeployment -SQLProfile $SQLProfile -Name "SQL Deployment 01"
PS C:\> $SQLDeployment
The first command gets the SQL Server profile object named SQLProfile01 and stores the object in the $SQLProfile variable.

The second command gets the SQL Server deployment object named SQL Deployment 01 from the SQL Profile stored in $SQLProfile, and then stores the object in the $SQLDeployment variable.

The third command displays the details of the SQL Server deployment stored in $SQLDeployment to the user.

See Also