ListAzureSubscriptionDetails.ps1

# First download an Azure Publish File
# Get-AzurePublishSettingsFile
# save the file somewhere special

#Import file
Import-AzurePublishSettingsFile \path\to\pushlish-settings-file.publishsettings


Login-AzureRmAccount

# List all subscriptions
$subscriptions = Get-AzureSubscription



$detailItems = @()



# Subscription Overview
$subscriptions | Select SubscriptionName, SubscriptionId @{N="Cluster";E={$_}}

Foreach ($subscription in $subscriptions) {

	"Selecting " + $subscription."SubscriptionName" + " " + $subscription."SubscriptionId" 
 	 Select-AzureSubscription $subscription."SubscriptionName" 


 	 # Look at arm resources

 	 "Set ARM Resource for " + $subscription."SubscriptionId" 
 	 Set-AzureRmContext -SubscriptionID $subscription."SubscriptionId" 


 	 # List ARM Resource Groups
 	 $resourceGroups = Get-AzureRmResourceGroup
 	 Foreach ($resourceGroup in $resourceGroups) {


 	 

 	 	$vms = Get-AzureRmVM -ResourceGroupName $resourceGroup."ResourceGroupName"

 	 	Foreach ($vm in $vms) {


 	 		try {

	 	 		 $temp = [pscustomobject]@{
			      "SubscriptionName" = $subscription.SubscriptionName
			      "SubscriptionId" = $subscription.SubscriptionId
			      "ResourceGroupName" = $resourceGroup."ResourceGroupName"
			      "VmName" = $vm."Name"
			      "VmLocation" = $vm."Location"
			      "VmSize" = $vm."HardwareProfile"."VmSize"
			      "AdminUsername" = $vm."OSProfile"."AdminUsername"
			    }


			    $detailItems += $temp
			}
			catch {
				"something went wrong"
			}

 	 		#$subscription."SubscriptionName" + ", " + $subscription."SubscriptionId" + ", " + $resourceGroup."ResourceGroupName" + ", " + $vm."Name" + ", " + $vm."Location" + ", " + $vm."HardwareProfile"."VmSize" + ", " + $vm."OSProfile"."AdminUsername"

 	 	}


 	 }


}

# Export to file

$detailItems  | Export-Csv -Path out.csv -Encoding ascii -NoTypeInformation