Get-SCSQLProfile

Gets a SQL Server profile.

Syntax

Get-SCSQLProfile [-All] [-VMMServer <ServerConnection>] [<CommonParameters>]
Get-SCSQLProfile [-ID <Guid>] [-VMMServer <ServerConnection>] [<CommonParameters>]
Get-SCSQLProfile -Name <String> [-VMMServer <ServerConnection>] [<CommonParameters>]
Get-SCSQLProfile [-VMMServer <ServerConnection>] -VMTemplate <Template> [<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.

Type:SwitchParameter
Required:False
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-ID

Specifies the unique ID of the SQL Server profile that this cmdlet gets.

Type:Guid
Required:False
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-Name

Specifies the name of the SQL Server profile that this cmdlet gets.

Type:String
Required:True
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-VMMServer

Specifies the VMM server on which this cmdlet operates.

Type:ServerConnection
Required:False
Position:Named
Default value:None
Accept pipeline input:True (ByValue)
Accept wildcard characters: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.

Type:Template
Required:True
Position:Named
Default value:None
Accept pipeline input:True (ByValue)
Accept wildcard characters:False

Outputs

SQLProfile

This cmdlet returns a **SQLProfile** object.