Microsoft Azure & PowerShell : Export the list of all "Azure VM DISK Images" list to CSV or HTML using PowerShell script.

 

How can I get a list of all “Microsoft Azure VM OS Image lists”, She asked me over the Phone.

Who? Who else! Our own “A! Murky Ana.”

I said: Yes, you can, you just need to use “Get-AzureVMImage” cmdlet , to use it just  install a “Azure PowerShell Module, and run the above cmdlet and that’s all you need to do.

A! Murky Ana. : Can we export the list of Azure VM OS DISK Images  to HTML format or in a .CSV format?

Me: Yes you can.

A! Murky Ana. : How?

Me: You just need to write a small function / script  to do that & a few tiny scripting techniques to do data manipulation.

A! Murky Ana. : Can you do it for me?

Me: No! it’s your quest, you have to deal with this.

A! Murky Ana. : Ok, let's make a deal, You show me once only , the first and the last time  to teach me how to do that, I won’t ask you again, I want to see if that kind of script we can write.

Me.: Ok, First and the last time.

I hang up the phone.

After one day, I call her and told her, did you saw the movie “Galaxy of the Guardian”?

A! Murky Ana. : No?

Me: Go a Get a DVD of it, it’s so cool movie.!

A! Murky Ana. : Don’t you suppose to show me something? A script to Export a Azure Virtual Image list to .CSV file?

Me. Yes, I know, I am sending you the screen sharing link by using http://join.me ,  See it and I will walk through a script which I have written. Please download it from the below link

https://gallery.technet.microsoft.com/Azure-Get-the-List-of-all-520816af

This is a script function, you can run the function simply by using  “Export-AzureVMImageList ” than this will generate a list of all Azure Virtual Image list those are available in to a HTML page and the page will open automatically.

 

To know more about PowerShell Function, visit this link : https://technet.microsoft.com/en-us/library/hh847829.aspx  

 

 

 

If you want to export the Azure VM image list to the .CSV format, then just use the –CSV “Export-AzureVMImageList -CSV ” switch with the function and it will generate a .CSV file containing the same information.

 

Exporting the list either to .CSV or HTML is quite handy, so that you can search the name and DISK image of the OS easily which you want to create, after having a list, it’s a matter of sec milliseconds, copy and paste.,

Remember the download link: https://gallery.technet.microsoft.com/Azure-Get-the-List-of-all-520816af

This script by default export all files  in the user’s temp directory.

You can know about your temp directory by using $env:TEMP variable in the PowerShell console.

 

 

Just for your knowledge, there is three main part of the this current scripts.

1.    The Switch Parameter

2.    IF Else Statement

3.    The ForEach loop

 

The Switch Parameter

 

 

This works like a ON/Off switch. If you use the –CSV parameter with the function, the script set it ON ( $true) and export the Output in the CSV format.  Else it keep it in the OFF state ( $false).

 

To know more about Parameters visit this link : https://technet.microsoft.com/en-us/library/hh847743.aspx

 

The IF-ELSE  Statement

 

 

The IF block checks if the –CSV is ON or OFF, if the –CSV is present in function, then it will run the   IF block code to export the file to .CSV format, otherwise the ELSE block will run and export the file in the HTML format.

 

The ForEach loop.

 

By using For-Each loop , we are manipulation with data and saving it as a single line to a  variable “$body1”

 

That’s it J , you know the trick, Now download the script and play with it. Try to change the default path. Try to change the File Name, or try to add some new parameters.

 

Check the video below on "How you can run the script".

 

Export-AzureVmList

 

 

Me: Happy?

 

A! Murky Ana. :  Yes,

 

Me. : Go and now learn more about "Microsoft Azure and PowerShell"

 

and she hung up the phone!!!

 

HOW RUDE............

 

* All characters appearing in this work are fictitious Any resemblance to real persons, living or dead, is purely coincidental.

 

Regards.

Aman Dhally

If you like, you can follow me on Twitter and Facebook. You can also check my “You Tube” channel for PowerShell video tutorials. You can download all of my scripts from “Microsoft TechNet Gallery”.

 

 

 

 

 

 

 

 

 

PowerShell Script : Inspire Me

 

Everyone needs motivations and inspirations in daily life.

We do feel lost without inspirations.

I love to read inspirational quotes, and I love to store inspirational quotes which I do liked the most.

As I spent lots of time on my PowerShell console, I thought to write a simple PowerShell functions, which display a random quote.

To achieve that, I have write this simple PowerShell script and I hope you will like it

This is simplest script, what I have done is :

·        Create an String Array of the Script

·        Get a Single random item from string array using “Get-Random” cmdlet.

·        Strong that random quote in to a variable

·        Then writing the variable out using “Write-Host”. You can aloso use “Write-Out” too, but “Write-Host” support colour, so do I like it.

·        It’s a function J

Sometime, scripting is not about automating the technical stuff, we can integrate script in our lives too, make a useful utilities from them.

It’s all about creativity. J Sometime in IT and sometime in Life.

Sorry for my insanity ;)

Download Link : http://gallery.technet.microsoft.com/scriptcenter/PowerShell-Script-Inspire-0c163df6

 

:-------------------------------------- Script Code ----------------------------------

#==================| Satnaam Waheguru Ji |===============================   
#              
#            Author  :  Aman Dhally    
#            E-Mail  :  amandhally@gmail.com    
#            website :  www.amandhally.net    
#            twitter :   @AmanDhally    
#            blog    : http://newdelhipowershellusergroup.blogspot.in/   
#            facebook: http://www.facebook.com/groups/254997707860848/    
#            Linkedin: http://www.linkedin.com/profile/view?id=23651495    
#    
#            Creation Date    : 08-july-2014
#            File    :          Let's find Some Inspiration
#           
#            Version : 1
#              
#   
#            My Pet Spider :          /^(o.o)^\     
#  
#------------------------------------------------------------------------------------------------------------  

function Inspire-Me {

# List of Quotes added in to Array
[string[]]$quoteList = 
                "Do Good, Be Good, Be one.",
                "Life is like a flowing river of opportunities.It's up to you to stand up with a bucket or with a spoon.",
                "All the art of living lies in a fine mingling of letting go and holding on. – Henry Ellis",
                "You are not YET complete. You have no right to judge yourself because you are still work in progress !",
                "Wise men talk because they have something to say, Fools, because they have to say something. – Plato",
                "Keep dreaming guys, they do come true. - Divine Arcanas (The Hermit)",
                "If you are going to be thinking, you may as well think big. - Donald Trump",
                "They told me, You Can't, I replied I Will. Divine Arcanas (The Hermit)",
                "People who are crazy enough to think they can change the world, are the ones who do. - Apple Computers",
                "When people underestimate you, there's a power in you to prove they're wrong. Not to prove them, but to prove yourself.",
                "Anyone who judges you by the kind of car you drive or shoes you wear , isn’t someone worth impressing.",
                "When things didn't go as you planned, don't be let down. Make NEW plans. The sun doesn't stop SHINNING just because of dark clouds ",
                "You are never given a desire without also being given the power to make it true.",
                "Do the hard jobs first. The easy jobs will take care of themselves. – Dale Carnegie",
                "Success is doing ordinary things extraordinarily well. – Jim Rohn",
                "Success is the sum of small efforts, repeated day in and day out. – Robert Collier",
                "Attitude is a little thing that makes a big difference. – Winston Churchill",
                "Flaming enthusiasm, backed up by horse sense and persistence, is the quality that most frequently makes for success. – Dale Carnegie",
                "The three great essentials to achieve anything worthwhile are, first, hard work; second, stick-to-itiveness; third, common sense. – Thomas A. Edison",
                "A good leader takes a little more than his share of the blame, a little less than his share of the credit. – Arnold H. Glasgow",
                "Failure is simply the opportunity to begin again, this time more intelligently. – Henry Ford",
                "What great thing would you attempt if you knew you could not fail? – Robert H. Schuller",
                "All the art of living lies in a fine mingling of letting go and holding on. – Henry Ellis"

        #Choosing One Randonm Quote    
        $randomQuote = $quoteList | Get-Random -Count 1

        # Writing Quote
        "`n"
        Write-host "---|Today's Quote |---" -ForegroundColor Green
        "`n"
        Write-host $randomQuote -ForegroundColor Yellow
        "`n"
        Write-Host "---| Have a Nice day. |---" -ForegroundColor Green
        "`n"
}

Inspire-Me

:---------------------------------------------

Download Link : http://gallery.technet.microsoft.com/scriptcenter/PowerShell-Script-Inspire-0c163df6

That's all for today. See you in my next blog post. 

Regards

Aman Dhally

Come and join my journey of : “100 Days of Self Improvement” on

Facebook: https://www.facebook.com/100DoSI 

If you like, you can follow me on Twitter and Facebook. You can also check my “You Tube” channel for PowerShell video tutorials. You can download all of my scripts from “Microsoft TechNet Gallery”.