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
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.