Azure Resource Manager overview
Using linked templates with Azure Resource Manager
Best practices for creating Azure Resource Manager templates
"outputs": {
}
"outputs": {
"SomeString": {
"type": "string",
"value": "Whatever you want to print out"
},
"ServerNameParam": {
"type": "string",
"value": "[parameters('yourservernameName')]"
}
}
You will get:
Name Type Value
=============== ========================= ==========
someString String What ever you want to put here
serverNameParam String yourservername2
"outputs": {
"ServerResourceID": {
"type": "string",
"value": "[resourceId('Microsoft.Sql/servers', parameters('yourservernameName'))]"
},
"DbResourceID": {
"type": "string",
"value": "[resourceId('Microsoft.Sql/servers/databases', parameters('yourservernameName'), parameters('dbnameName'))]"
}
}
The output looks like this:
Name Type Value
=============== ========================= ==========
serverResourceID String /subscriptions/12345678-1234-abcd-a1b2-a1a1a1a1a1a1/resourceGroups/resourcegroupname/providers/Microsoft.Sql/servers/yourservername
dbResourceID String /subscriptions/12345678-1234-abcd-a1b2-a1a1a1a1a1a1/resourceGroups/resourcegroupname/providers/Microsoft.Sql/servers/yourservername/databases/dbname
"outputs": {
"ServerObject": {
"type": "object",
"value": "[reference(parameters('yourservernameName'))]"
},
"DbObject": {
"type": "string",
"value": "[reference(parameters('dbnameName'))]"
}
}
The output
Name Type Value
=============== ========================= ==========
serverObject Object {
"fullyQualifiedDomainName": "yourservername.database.windows.net",
"administratorLogin": "VeryWiseAdmin",
"administratorLoginPassword": "ReplaceWithTheMostSecurePasswordThatEverExisted&NeverShareLikeThisWithAnyone!",
"externalAdministratorLogin": null,
"externalAdministratorSid": null,
"version": "12.0",
"state": "Ready"
}
dbObject Object {
"databaseId": "f5cae93b-5770-4907-b25f-687dfce1f3d5",
"edition": "Basic",
"status": "Online",
"serviceLevelObjective": "Basic",
"collation": "SQL_Latin1_General_CP1_CI_AS",
"maxSizeBytes": "1073741824",
"creationDate": "2016-11-29T15:44:27.453Z",
"currentServiceObjectiveId": "dd6d99bb-f193-4ec1-86f2-43d3bccbc49c",
"requestedServiceObjectiveId": "dd6d99bb-f193-4ec1-86f2-43d3bccbc49c",
"requestedServiceObjectiveName": "Basic",
"sampleName": null,
"defaultSecondaryLocation": "North Europe",
"earliestRestoreDate": "2016-11-29T15:55:00.003Z",
"elasticPoolName": null,
"containmentState": 2,
"readScale": "Disabled"
}
"outputs": {
"SqlServerURL": {
"type": "string",
"value": "[reference(parameters('yourservernameName')).fullyQualifiedDomainName]"
}
}
The output
Name Type Value
=============== ========================= ==========
sqlServerURL String yourservername.database.windows.net
"outputs": {
"DbAdoConnString": {
"type": "string",
"value": "[concat('Server=tcp:',reference(parameters('yourservernameName')).fullyQualifiedDomainName,',1433;Initial Catalog=',parameters('dbnameName')';Persist Security Info=False;User ID=',reference(parameters('yourservernameName')).administratorLogin,';Password=',reference(parameters('yourservernameName')).administratorLoginPassword,';MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;')]"
}
}
The output
Name Type Value
=============== ========================= ==========
dbAdoConnString String Server=tcp:yourservername.database.windows.net,1433;Initial Catalog=dbname;Persist Security Info=False;User ID=VeryWiseAdmin;Password= ReplaceWithTheMostSecurePasswordThatEverExisted&NeverShareLikeThisWithAnyone!;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;
Note
The listkeys function is not available for all resources, amongst others you cannot use it with Azure SQL Database.
If you try, the resources will be deployed but the output is not displayed and you get error:
"Resource not found for the segment 'listkeys'."
# log in
Login-AzureRmAccount
# existing resource group where you would like to deploy
$RGName="resourcegroupname"
# path to the
$TemplateFile="c:\path\file.json"
# validate the template
Test-AzureRmResourceGroupDeployment -ResourceGroupName $RGName -TemplateFile $TemplateFile
# deploy to the specified resource group
New-AzureRmResourceGroupDeployment -ResourceGroupName $RGName -TemplateFile $TemplateFile
# list all the deplyoments for the resource group
Get-AzureRmResourceGroupDeployment -ResourceGroupName $RGName
# stop a deployment, this may be helpful for large deployment files which have many resources and you realize you didn't want to deploy just yet
Stop-AzureRmResourceGroupDeployment -ResourceGroupName $RGName -Name "export"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.