Get-SCSQLProfile

Gets a SQL Server profile.

Syntax

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

Required Parameters

-Name

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

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

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

Outputs

SQLProfile

This cmdlet returns a SQLProfile object.