New-SCSQLProfile

Creates a SQL Server profile.

Description

The New-SQLProfile cmdlet creates a SQL Server profile.

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

Parameters

Name

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

Description

Required? false
Accept Pipeline Input? false
Position? named 
States a description for the specified object.

JobVariable

Required? false
Accept Pipeline Input? false
Position? named 
Specifies that job progress is tracked and stored in the variable named by this parameter.

Owner

Required? false
Accept Pipeline Input? false
Position? named 
Specifies the owner of a VMM object in the form of a valid domain user account.

Example format: -Owner "Contoso\ReneeLo"
Example format: -Owner "ReneeLo@Contoso"

PROTipID

Required? false
Accept Pipeline Input? false
Position? named 
Specifies the ID of the PRO tip that triggered this action. This allows for auditing of PRO tips.

RunAsynchronously

Required? false
Accept Pipeline Input? false
Position? named 
Indicates that the job runs asynchronously so that control returns to the command shell immediately.

SQLProfile

Required? false
Accept Pipeline Input? false
Position? named 
Specifies a SQL Server profile object.

Tag

Required? false
Accept Pipeline Input? false
Position? named 
Specifies a word or phrase to associate with an object so that you can search for all objects with the specified set of tags. You can search for a subset of tags, or you can search for the full set of tags.

UserRole

Required? false
Accept Pipeline Input? false
Position? named 
Specifies a user role object.

VMMServer

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

Examples

1: Create a SQL Server profile. 
PS C:\> $SQLProfile = New-SCSQLProfile -Name "SQLProfile01" -Description "SQL Profile 01" -Tag "Standard SQL Profile"
PS C:\> $SQLProfile 

The first command creates a SQL Server profile object named SQLProfile01 and stores the object in the $SQLProfile variable.

The second command displays information about the SQL Server profile object stored in $SQLProfile to the user.

See Also