23Jun
Get all images list for VMs in Azure
When you build your environment in Azure Cloud using IaaC (Infrastructure as a Code) approach, sometimes you will face issues during re-deployment. That's because guys from Microsoft update their VM images with new versions of software. As a result, these new images have new IDs and you must update your ARM or Powershell scripts.
I wrote a script that will help to find new versions of images.
Login-AzureRmAccount;
#Select Region
$location = (Get-AzureRmLocation).location | Out-GridView -Title "Select Azure location" -PassThru;
#Select publisher
$publisher = Get-AzureRmVMImagePublisher -Location $location | Select -ExpandProperty PublisherName | Out-GridView -Title "Select Publisher" -PassThru;
#Get all offers for selected publisher
$Alloffers = @(Get-AzureRmVMImageOffer -Location $location -Publisher $publisher | Select -ExpandProperty Offer);
#Get all images for all skus of all offers for the selected publisher
foreach ($Offer in $Alloffers)
{
$Allskus = (Get-AzureRmVMImageSku -Location $location -Publisher $publisher -Offer $offer | Select -ExpandProperty Skus);
foreach ($sku in $Allskus)
{
$Allimages += @(Get-AzureRmVMImage -Location $location -PublisherName $publisher -Offer $offer -Skus $sku);
}
}
$Allversions = $Allimages | select Version,Skus,Offer,PublisherName | Sort-Object Skus;
Write-Output $Allversions;
Here is example output:
Version Skus Offer PublisherName ------- ---- ----- ------------- 11.5.65235 Enterprise SQL2012SP3-WS2012R2 MicrosoftSQLServer 11.3.65235 Enterprise SQL2012SP3-WS2012R2-BYOL MicrosoftSQLServer 11.7.65235 Enterprise SQL2012SP3-WS2012R2-BYOL MicrosoftSQLServer 12.0.44499 Enterprise SQL2014SP1-WS2012R2-BYOL MicrosoftSQLServer 12.9.50001 Enterprise SQL2014SP2-WS2012R2 MicrosoftSQLServer 12.9.50005 Enterprise SQL2014SP2-WS2012R2-BYOL MicrosoftSQLServer 13.5.31640 Enterprise SQL2016-WS2012R2 MicrosoftSQLServer 13.0.400110 Enterprise SQL2016SP1-WS2016 MicrosoftSQLServer 13.0.400110 Enterprise SQL2016SP1-WS2016-BYOL MicrosoftSQLServer 11.5.65235 Enterprise SQL2012SP3-WS2012R2 MicrosoftSQLServer 11.5.65235 Enterprise SQL2012SP3-WS2012R2 MicrosoftSQLServer 11.3.65235 Enterprise SQL2012SP3-WS2012R2-BYOL MicrosoftSQLServer 12.0.44499 Enterprise SQL2014SP1-WS2012R2-BYOL MicrosoftSQLServer 12.9.50001 Enterprise SQL2014SP2-WS2012R2 MicrosoftSQLServer 12.9.50005 Enterprise SQL2014SP2-WS2012R2-BYOL MicrosoftSQLServer 13.5.31640 Enterprise SQL2016-WS2012R2 MicrosoftSQLServer 13.0.21640 Enterprise SQL2016-WS2012R2-BYOL MicrosoftSQLServer 13.0.400110 Enterprise SQL2016SP1-WS2016 MicrosoftSQLServer 13.0.500110 Enterprise SQL2016SP1-WS2016 MicrosoftSQLServer 13.0.400110 Enterprise SQL2016SP1-WS2016-BYOL MicrosoftSQLServer 13.0.500110 Enterprise SQL2016SP1-WS2016-BYOL MicrosoftSQLServer 11.7.65235 Enterprise SQL2012SP3-WS2012R2-BYOL MicrosoftSQLServer 13.0.400110 Enterprise SQL2016SP1-WS2016-BYOL MicrosoftSQLServer 13.0.21640 Enterprise SQL2016-WS2012R2-BYOL MicrosoftSQLServer 13.0.400110 Enterprise SQL2016SP1-WS2016 MicrosoftSQLServer 12.9.50005 Enterprise SQL2014SP2-WS2012R2-BYOL MicrosoftSQLServer 13.0.21640 Enterprise SQL2016-WS2012R2-BYOL MicrosoftSQLServer 12.9.50001 Enterprise SQL2014SP2-WS2012R2 MicrosoftSQLServer 12.0.44499 Enterprise SQL2014SP1-WS2012R2-BYOL MicrosoftSQLServer 11.7.65235 Enterprise SQL2012SP3-WS2012R2-BYOL MicrosoftSQLServer 13.5.31640 Enterprise SQL2016-WS2012R2 MicrosoftSQLServer 11.3.65235 Enterprise SQL2012SP3-WS2012R2-BYOL MicrosoftSQLServer 2.0.0 Evaluation SQL2017-RHEL73 MicrosoftSQLServer 2.0.0 Evaluation SQL2017-RHEL73 MicrosoftSQLServer 2.0.0 Evaluation SQL2017-RHEL73 MicrosoftSQLServer 13.0.400111 Express SQL2016SP1-WS2016 MicrosoftSQLServer 13.0.400111 Express SQL2016SP1-WS2016 MicrosoftSQLServer 12.9.50001 Express SQL2014SP2-WS2012R2 MicrosoftSQLServer 12.9.50001 Express SQL2014SP2-WS2012R2 MicrosoftSQLServer 13.0.500110 Express SQL2016SP1-WS2016 MicrosoftSQLServer 11.5.65235 Express SQL2012SP3-WS2012R2 MicrosoftSQLServer 11.5.65235 Express SQL2012SP3-WS2012R2 MicrosoftSQLServer 12.9.50001 Express SQL2014SP2-WS2012R2 MicrosoftSQLServer 11.5.65235 Express SQL2012SP3-WS2012R2 MicrosoftSQLServer 13.0.400111 Express SQL2016SP1-WS2016 MicrosoftSQLServer 13.5.31640 SQLDEV SQL2016-WS2012R2 MicrosoftSQLServer 13.0.21640 SQLDEV SQL2016-WS2016 MicrosoftSQLServer 13.0.400111 SQLDEV SQL2016SP1-WS2016 MicrosoftSQLServer 13.0.500110 SQLDEV SQL2016SP1-WS2016 MicrosoftSQLServer 13.0.400111 SQLDEV SQL2016SP1-WS2016 MicrosoftSQLServer 13.0.21640 SQLDEV SQL2016-WS2016 MicrosoftSQLServer 13.0.21640 SQLDEV SQL2016-WS2016 MicrosoftSQLServer 13.0.400111 SQLDEV SQL2016SP1-WS2016 MicrosoftSQLServer 13.5.31640 SQLDEV SQL2016-WS2012R2 MicrosoftSQLServer 13.5.31640 SQLDEV SQL2016-WS2012R2 MicrosoftSQLServer 13.0.500110 Standard SQL2016SP1-WS2016 MicrosoftSQLServer 12.9.50001 Standard SQL2014SP2-WS2012R2 MicrosoftSQLServer 13.0.400110 Standard SQL2016SP1-WS2016-BYOL MicrosoftSQLServer 11.5.65236 Standard SQL2012SP3-WS2012R2 MicrosoftSQLServer 13.0.21640 Standard SQL2016-WS2012R2-BYOL MicrosoftSQLServer 11.5.65236 Standard SQL2012SP3-WS2012R2 MicrosoftSQLServer 13.0.400110 Standard SQL2016SP1-WS2016-BYOL MicrosoftSQLServer 11.7.65236 Standard SQL2012SP3-WS2012R2-BYOL MicrosoftSQLServer 12.7.50005 Standard SQL2014SP2-WS2012R2-BYOL MicrosoftSQLServer 13.0.400110 Standard SQL2016SP1-WS2016 MicrosoftSQLServer 12.7.50005 Standard SQL2014SP2-WS2012R2-BYOL MicrosoftSQLServer 12.0.444999 Standard SQL2014SP1-WS2012R2-BYOL MicrosoftSQLServer 13.0.500110 Standard SQL2016SP1-WS2016-BYOL MicrosoftSQLServer 13.0.21640 Standard SQL2016-WS2012R2-BYOL MicrosoftSQLServer 12.7.50005 Standard SQL2014SP2-WS2012R2-BYOL MicrosoftSQLServer 12.9.50001 Standard SQL2014SP2-WS2012R2 MicrosoftSQLServer 13.0.400110 Standard SQL2016SP1-WS2016 MicrosoftSQLServer 13.0.400110 Standard SQL2016SP1-WS2016-BYOL MicrosoftSQLServer 12.0.444999 Standard SQL2014SP1-WS2012R2-BYOL MicrosoftSQLServer 13.0.400110 Standard SQL2016SP1-WS2016 MicrosoftSQLServer 12.0.444999 Standard SQL2014SP1-WS2012R2-BYOL MicrosoftSQLServer 12.9.50001 Standard SQL2014SP2-WS2012R2 MicrosoftSQLServer 13.0.21640 Standard SQL2016-WS2012R2-BYOL MicrosoftSQLServer 11.7.65236 Standard SQL2012SP3-WS2012R2-BYOL MicrosoftSQLServer 11.7.65236 Standard SQL2012SP3-WS2012R2-BYOL MicrosoftSQLServer 11.5.65236 Standard SQL2012SP3-WS2012R2 MicrosoftSQLServer 12.9.50001 Web SQL2014SP2-WS2012R2 MicrosoftSQLServer 12.5.50000 Web SQL2012SP3-WS2012R2 MicrosoftSQLServer 12.5.50000 Web SQL2012SP3-WS2012R2 MicrosoftSQLServer 13.0.400110 Web SQL2016SP1-WS2016 MicrosoftSQLServer 12.5.50000 Web SQL2012SP3-WS2012R2 MicrosoftSQLServer 13.0.400110 Web SQL2016SP1-WS2016 MicrosoftSQLServer 13.0.500110 Web SQL2016SP1-WS2016 MicrosoftSQLServer 12.9.50001 Web SQL2014SP2-WS2012R2 MicrosoftSQLServer 12.9.50001 Web SQL2014SP2-WS2012R2 MicrosoftSQLServer 13.0.400110 Web SQL2016SP1-WS2016 MicrosoftSQLServer
Tags: script, powershell (en), azure (en)