$vms=Get-AzureRmVM -ResourceGroupName '<your resource group>' ;

foreach ($vm in $vms) {

if($vm.StorageProfile.ImageReference.Offer -match "SQL")
{
$VM.Name, "---", $vm.StorageProfile.ImageReference.Offer  |out-file c:\scripts\SQL.txt -Append;
}
    }