Skip to content

Instantly share code, notes, and snippets.

View timwebster9's full-sized avatar

Tim Webster timwebster9

8 followers · 2 following
  • London, UK
View GitHub Profile
@timwebster9
timwebster9 / sql-aad-admin.txt
Created November 24, 2021 10:08
PUT /subscriptions/2ca65474-3b7b-40f2-b242-0d2fba4bde6e/resourceGroups/policy-rg/providers/Microsoft.Sql/servers/timwaadadminonly?api-version=2021-02-01-preview HTTP/1.1
Host: management.azure.com
User-Agent: Go/go1.17.3 (amd64-darwin) go-autorest/v14.2.1 Azure-SDK-For-Go/v59.0.0 sql/v5.0 HashiCorp Terraform/1.0.5 (+https://www.terraform.io) Terraform Plugin SDK/2.8.0 terraform-provider-azurerm/2.86.0 pid-222c6c49-1b0a-5959-a213-6608f9eb8820
Content-Length: 365
Content-Type: application/json; charset=utf-8
X-Ms-Correlation-Request-Id: a4ed4b79-09c1-afad-a8ab-769fdc10e387
Accept-Encoding: gzip
{"identity":{"type":"SystemAssigned"},"location":"uksouth","properties":{"administratorLogin":"missadministrator","administratorLoginPassword":"thisIsKat11","administrators":{"administratorType":"ActiveDirectory","login":"SQLAdmins","sid":"9154dbde-28ff-411a-90b2-04f8568fe54b"},"minimalTlsVersion":"1.2","publicNetworkAccess":"Enabled","version":"12.0"},"tags":{}}: timestamp=2021-11-24T09:24:33.862Z
@timwebster9
timwebster9 / azure-sql-create.txt
Last active October 10, 2021 11:38
PUT /subscriptions/2ca65474-3b7b-40f2-b242-0d2fba4bde6e/resourceGroups/policy-rg/providers/Microsoft.Sql/servers/timw9078safsaf?api-version=2019-06-01-preview HTTP/1.1
Host: management.azure.com
User-Agent: Go/go1.16.7 (amd64-darwin) go-autorest/v14.2.1 Azure-SDK-For-Go/v56.2.0 sql/v3.0 HashiCorp Terraform/1.0.5 (+https://www.terraform.io) Terraform Plugin SDK/2.7.0 terraform-provider-azurerm/2.73.0 pid-222c6c49-1b0a-5959-a213-6608f9eb8820
Content-Length: 243
Content-Type: application/json; charset=utf-8
X-Ms-Correlation-Request-Id: 2f3341bd-c4bc-9c2c-7ce2-c98b670bab9c
Accept-Encoding: gzip
{"identity":{"type":"SystemAssigned"},"location":"uksouth","properties":{"administratorLogin":"missadministrator","administratorLoginPassword":"asfsd7fsd78f9s","minimalTlsVersion":"1.2","publicNetworkAccess":"Enabled","version":"12.0"},"tags":{}}:
@timwebster9
timwebster9 / public-ip-output.txt
Created September 25, 2021 09:12
PUT /subscriptions/2ca65474-3b7b-40f2-b242-0d2fba4bde6e/resourceGroups/policy-rg/providers/Microsoft.Network/publicIPAddresses/policy-pip-standard-3AZ?api-version=2021-02-01 HTTP/1.1
Host: management.azure.com
User-Agent: Go/go1.16.7 (amd64-darwin) go-autorest/v14.2.1 Azure-SDK-For-Go/v56.2.0 network/2021-02-01 HashiCorp Terraform/1.0.5 (+https://www.terraform.io) Terraform Plugin SDK/2.7.0 terraform-provider-azurerm/2.73.0 pid-222c6c49-1b0a-5959-a213-6608f9eb8820
Content-Length: 202
Content-Type: application/json; charset=utf-8
X-Ms-Correlation-Request-Id: 8e82a0a8-ae1f-a139-8100-62d700359d9f
Accept-Encoding: gzip
{"location":"uksouth","properties":{"idleTimeoutInMinutes":4,"publicIPAddressVersion":"IPv4","publicIPAllocationMethod":"Static"},"sku":{"name":"Standard","tier":"Regional"},"tags":{},"zones":["1","2"]}: timestamp=2021-09-25T08:56:06.666+0100
@timwebster9
timwebster9 / New-CloneServicePrincipal.sh
Last active July 23, 2020 14:20 — forked from MarkWarneke/New-CloneServicePrincipal.sh
Create a Clone Service Principal https://markwarneke.me/2020-04-02-Clone-AzureAd-Service-Principal/ you can run the following automation steps. Make sure the authenticated user executing the steps has at least the Application Administrator Azure AD role - as this role is needed for the last step to grant permissions.
#!/usr/bin/env bash
# Name of the Clone Service Principal
appName="CloneServicePrincipal"
# Retrieve the teannt it
tenantId=$(az account show --query tenantId -o tsv)
# Create the Clone Service Principal
appId=$(az ad app create --display-name $appName --query appId -o tsv)
@timwebster9
timwebster9 / terraform_debug
Created June 20, 2018 15:37
empty error message on AKS cluster when VM size is incorrect/not allowed
2018-06-20T16:33:00.645+0100 [DEBUG] plugin.terraform-provider-azurerm_v1.7.0_x4: "code": "BadRequest",
2018-06-20T16:33:00.645+0100 [DEBUG] plugin.terraform-provider-azurerm_v1.7.0_x4: "message": "The VM size of AgentPoolProfile:default is not allowed in your subscription in location 'uksouth'. The available VM sizes are Standard_A1_v2,Standard_A2_v2,Standard_A2m_v2,Standard_A4_v2,Standard_A4m_v2,Standard_A8_v2,Standard_A8m_v2,Standard_B2ms,Standard_B2s,Standard_B4ms,Standard_B8ms,Standard_D16_v3,Standard_D16s_v3,Standard_D2_v3,Standard_D2s_v3,Standard_D32_v3,Standard_D32s_v3,Standard_D4_v3,Standard_D4s_v3,Standard_D64_v3,Standard_D64s_v3,Standard_D8_v3,Standard_D8s_v3,Standard_E16_v3,Standard_E16s_v3,Standard_E2_v3,Standard_E2s_v3,Standard_E32-16s_v3,Standard_E32-8s_v3,Standard_E32_v3,Standard_E32s_v3,Standard_E4_v3,Standard_E4s_v3,Standard_E64-16s_v3,Standard_E64-32s_v3,Standard_E64_v3,Standard_E64s_v3,Standard_E8_v3,Standard_E8s_v3,Standard_F16s_v2,Standard_F2s_v2,Standard_F32s_v2,Standard_F4s_v2,Stan