Inquire about automating creation of NSG firewall rules

Question

Inquire about automating creation of NSG firewall rules

안 남기 181

For example, in Excel, the source address, destination address, port number...After receiving that information, I would like to ask if there is a way to automatically generate NSG firewall rules or other ways to automate them.

KapilAnanth-MSFT 49,536 Reputation points Microsoft Employee Moderator

2022-11-21T08:21:16.577+00:00

Hi @안 남기 ,

Welcome to the Microsoft Q&A Platform. Thank you for reaching out & I hope you are doing well.
I understand that you would like to automate the creation of NSG rules from Excel file.

I see @JimmySalian-2011 has provided a detailed summary of how this can be accomplished.

Let us know if you'd require more details on this.
If not, request you to "Accept the answer" and close this thread.

Cheers,
Kapil

Accepted answer

0 additional answers

Your answer

KapilAnanth-MSFT 49,536 Reputation points Microsoft Employee Moderator

2022-11-21T08:21:16.577+00:00

Hi @안 남기 ,

Welcome to the Microsoft Q&A Platform. Thank you for reaching out & I hope you are doing well.
I understand that you would like to automate the creation of NSG rules from Excel file.

I see @JimmySalian-2011 has provided a detailed summary of how this can be accomplished.

Let us know if you'd require more details on this.
If not, request you to "Accept the answer" and close this thread.

Cheers,
Kapil

Answer 1

JimmySalian-2011 42,491

Hi,

Not sure if you have explored Bicep codes for deploying the resources in Azure, but I will suggest you to kindly check this article and process to deploy the NSG rules. Or Terraform to deploy it.

manage-route-tables-and-network-security-groups-in-azure-with-bicep-and-azure-devops-pipelines
automate-azure-nsg-rule-changes-terraform-devops-anil-shafeeque

This is the script using Excel and PS.
Add-Multiple-Rules-to-NSG-using-PowerShell-and-CSV

Hope this helps.
JS

==
Please Accept the answer if the information helped you. This will help us and others in the community as well.

안 남기 181 Reputation points

2022-11-22T06:59:48.487+00:00

I will make sure to choose the answer after checking.
Thank you for checking.
안 남기 181 Reputation points

2022-11-26T00:42:40.663+00:00

I'm sorry for the delay in choosing the answer.
I was so busy that I didn't have time to test it.
I'll test it myself later.
Thank you for sharing a good answer.

Share via

Inquire about automating creation of NSG firewall rules

0 additional answers

Your answer