Whitelist an Azure firewall IP using PowerShell

-

 

1. Connect via PowerShell in Azure portal:

PS /home/azureuser> Connect-AzAccount -UseDeviceAuthentication

2. Run in PowerShell:

PS /home/azureuser>$new_ip = (Invoke-WebRequest ifconfig.me/ip).Content; Set-AzSqlServerFirewallRule -ResourceGroupName "<res_group_name>" -ServerName "<server_name>" -FirewallRuleName "test" -StartIpAddress "$new_ip" -EndIpAddress "$new_ip";


Comments

Post a Comment

Popular posts from this blog

Excel: highlighting a row or a column based a value, the current date example.

-
Image
Sometimes you need to to be able to look at your spreadsheet and quickly see the row or column relate to a certain value. Conditional highlighting will definitely help with that. I will show using the current date as an example. Select the working range. Go to Conditional Formatting. Set the formula: The dollar sign ($) will anchor either a row (A$1) or a column ($A1), so that the formula will be applied to, respectively, all the columns in the anchored row or all the rows in the anchored column.  Click Format and select the highlighting effects that you need. Click OK and observe the highlighted row or a column:
Read more