Remove Azure Analysis Services Firewall Rule in DevOps

0 votes

During a deployment, Azure DevOps creates a firewall rule when deploying to Azure Analysis Services (AAS), like so: enter image description here

There is an option in the 'Azure Analysis Service Deployment' task to not delete the firewall once deployed:

enter image description here

I uncheck this as it allows me to run Powershell against the AAS database after the deployment task (to amend the AD groups inside roles per environment, for example). DevOps has a whole host of dynamic IPs that change weekly and don't appear to match IP lists they send out in the weekly file either (that I've seen, plus amending firewall ranges weekly really is overly cumbersome), so I let the rule sit there whilst I complete my subsequent Powershell scripts.

There is a Powershell cmdlet to create a rule in the AAS firewall called 'New-AzAnalysisServicesFirewallRule'.

However, true to their remarkably consistent form for only giving us the tools we really need, there does not appear to be a 'Remove' equivalent which obviously I would like to run to clean it up at the end. I can't see anything in the Azure REST APIs for it either. Consequently, I am manually deleting the rule in the admin portal post-deployment.

There must be some functionality to do it, hence there is a checkbox for me to re-enable should I so choose. I wonder if anyone has uncovered the secret to programmatically removing an AAS firewall rule (specifically of the vsts-release-aas-rule variety) that they could share?

Mar 17, 2022 in Other DevOps Questions by Kichu
• 19,040 points
563 views

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.

Related Questions In Other DevOps Questions

0 votes
0 answers

How to remove broken Wiki entries in Azure Devops?

I  created an automated release note that ...READ MORE

Apr 22, 2022 in Other DevOps Questions by Kichu
• 19,040 points
490 views
0 votes
1 answer

How can I preview PowerPoint files in Azure DevOps (VSTS)?

No, there are no viewers for attachments ...READ MORE

answered Feb 9, 2022 in Other DevOps Questions by Bhavitha
• 1,000 points
619 views
0 votes
1 answer

JavaScript heap out of memory in Angular 7 using Azure DevOps

Try running the prod build as follows: node ...READ MORE

answered Feb 9, 2022 in Other DevOps Questions by Bhavitha
• 1,000 points
3,142 views
0 votes
0 answers
0 votes
1 answer

Is it possible to have a link to raw content of file in Azure DevOps

Sure, here's the call for the rests: GET ...READ MORE

answered Feb 10, 2022 in Other DevOps Questions by Bhavitha
• 1,000 points
696 views
0 votes
0 answers
0 votes
0 answers

Trigger Azure DevOps CI/CD through powershell script

How can we trigger CI/CD pipelines through ...READ MORE

Mar 30, 2022 in Other DevOps Questions by Kichu
• 19,040 points
967 views
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP