Export Azure Resources to Excel or CSV in Seconds | Azure Portal (No Code)

 In this vide we will talk about below features – 

1. Export to CSV azure resources
2. Customize default Virtual Machines view and then export to CSV
3. Customize default IP address, NSF, UDR view and then export to CSV
4. Create your own view with app services and export to CSV

Azure Migrate – Frequently asked questions – not easily answered

12 min to read.

Abstract

Migration are not new to humans. Migrations are happening since early days of human history. Almost every person on planet earth have migrated one or more times in their life. In today's world I see people are migrating for their Love and Marriages. It is mostly boys who migrate for their love and mostly girls migrate after their marriage. Love and Marriage both are complex! 

When you say you have done Love Marriage - that is a deadly complex combination!

In technology world also, migrations are not new. Migrations of applications is fundamental work to achieve core motive of migration – Betterment.

Workloads / applications will be going through Azure migration. Questions related to Azure migrate are unique and I see many enterprises get stuck just because they are not able to find the right answer.

This blog post dedicated to all those “real world frequently asked Azure migrate questions - not easily answered”.

I am strong believer in Diversity and Inclusion therefore - This FAQ is suitable for people who knows Azure and who don’t know Azure yet!

Lets go!

Note – This is second blog in the popular series of Azure VM Real world frequently asked questions – not easily answered.

Azure Migrate

I just love the Azure Migrate engineering team. They are really awesome guys and most talented. In technology field, believe it or not “Migrations are always complex”. Azure Migrate engineering team is making cloud migration tasks so simple with their hard work and dedication. Really impressed!

Azure migrate is fantastic tool to cater to all of your migration needs. The scope and scenario coverage is really awesome. Below are the tools that are present/ integrated in Azure Migrate which can be used for migration based on your scenario –

Below are the workload types supported by the Azure Migrate –

       1.    Servers – Virtualized, physical, other clouds to Azure
2.      Databases – almost all, Refer below screenshot in related questions below
3.      Data – Migrate to Hot, Cool and Archive tier of Azure Storage using Databox, Import/ Export
4.      Web applications – Migrate to Azure App Service
5.      Virtual Desktops – VDI migrations to Windows Virtual Desktop

I am not going to explain “what is Azure migrate?” We directly dive into questions in next section. As of today I have curated list of around 23+ questions based on experience which are other than official FAQ document. 

If you have any question that is still not answered, use “Contact Me” and I shall get answer for you related to Azure Migration. That’s a promise!

Azure VMs – Export to CSV

Abstract

For human race, there are some common tasks in daily life which you must do. Without which humans can survive but you can’t say if they are “living the life”. For example, taking a bath is one of such tasks. You can survive without taking a bath but you will not like it. These tasks are those which bring “life” to humans daily lives and make them enjoy their stay on earth.

Out of these humans there is special category of humans – I call them “Humans who work in Software field”. They can be sub-categorized into below –

       1.     Software developers
2.      IT administrators
3.      Project managers
4.      Software Engineers
5.      Solution Architects

For all these sub-categories you can apply prefix such as Senior, Junior, Principal, Full Stack, Distinguished and in recent times we have a new addition to this prefix known as “CLOUD”. These are humans who can easily survive without bath but there is one thing without which none of these humans can survive and it is known as “Export to CSV”. It is more or equally important like eating food and drinking water for them.

No matter how many cutting edge features and service Microsoft Azure is bringing, we still feel the product or service is not complete unless you offer “the” functionality of “Export to CSV”. Surprisingly Azure VM export to csv do not exists on Azure portal and you need to write a PowerShell for this. Therefore my lazy followers and friends asked me to write PowerShell to export Azure VM to CSV. So here we are!

Let’s go!

Current state of feedback

Users have provided the feedback to bring the functionality of export to csv for all azure resources on the portal. It is on the roadmap. You can view the details here - https://feedback.azure.com/forums/216843-virtual-machines/suggestions/37934101-virtual-machine-list-export-to-csv.

Why yet another new script?

I spoke to multiple people who are dealing with Azure VMs daily basis and requirements from there for CSV was an eye opener. Many of the scripts available today provides very minimal details about VM when exported to CSV. Most of the Azure Administrator find them not so useful. So after a quick survey with few of Lazy followers I received below list as a top ask for Azure VM to CSV export. In the below list the top ask was to retrieve Azure VNET for Azure VM and Azure VNET subnet for Azure VM using PowerShell. I have addressed this as well in the script.

So, current script provides the CSV output of Azure VMs with great details. Refer below columns list –