Get-SCSQLProfile
Gets a SQL Server profile.
Syntax
GetAll (Default)
Get-SCSQLProfile
[-VMMServer <ServerConnection>]
[<CommonParameters>]
GetByName
Get-SCSQLProfile
-Name <String>
[-VMMServer <ServerConnection>]
[<CommonParameters>]
GetByVMTemplate
Get-SCSQLProfile
-VMTemplate <Template>
[-VMMServer <ServerConnection>]
[<CommonParameters>]
All
Get-SCSQLProfile
[-VMMServer <ServerConnection>]
[-All]
[<CommonParameters>]
ID
Get-SCSQLProfile
[-VMMServer <ServerConnection>]
[-ID <Guid>]
[<CommonParameters>]
Description
The Get-SCSQLProfile cmdlet gets a Microsoft SQL Server profile.
Examples
Example 1: Get a SQL Server profiles
PS C:\> Get-SCSQLProfile -Name "SQLProfile01"
This command gets the SQL Server profile named SQLProfile01.
The second command displays information about the SQL Server profile object stored in $SQLProfile.
Parameters
-All
Indicates that this cmdlet gets all subordinate objects independent of the parent object.
For example, the command Get-SCVirtualDiskDrive -All gets all virtual disk drive objects regardless of the virtual machine object or template object that each virtual disk drive object is associated with.
Parameter properties
| Type: | SwitchParameter |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
All
| Position: | Named |
| Mandatory: | False |
| Value from pipeline: | False |
| Value from pipeline by property name: | False |
| Value from remaining arguments: | False |
-ID
Specifies the unique ID of the SQL Server profile that this cmdlet gets.
Parameter properties
| Type: | Guid |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
ID
| Position: | Named |
| Mandatory: | False |
| Value from pipeline: | False |
| Value from pipeline by property name: | False |
| Value from remaining arguments: | False |
-Name
Specifies the name of the SQL Server profile that this cmdlet gets.
Parameter properties
| Type: | String |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
GetByName
| Position: | Named |
| Mandatory: | True |
| Value from pipeline: | False |
| Value from pipeline by property name: | False |
| Value from remaining arguments: | False |
-VMMServer
Specifies the VMM server on which this cmdlet operates.
Parameter properties
| Type: | ServerConnection |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
(All)
| Position: | Named |
| Mandatory: | False |
| Value from pipeline: | True |
| Value from pipeline by property name: | False |
| Value from remaining arguments: | False |
-VMTemplate
Specifies a VMM template that is used to create virtual machines. This cmdlet gets SQL Server profiles for the template that this parameter specifies.
Parameter properties
| Type: | Template |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
GetByVMTemplate
| Position: | Named |
| Mandatory: | True |
| Value from pipeline: | True |
| Value from pipeline by property name: | False |
| Value from remaining arguments: | False |
CommonParameters
This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutBuffer, -OutVariable, -PipelineVariable, -ProgressAction, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.
Outputs
SQLProfile
This cmdlet returns a SQLProfile object.