Forum Discussion

Jurgen's avatar
Jurgen
New Member
7 years ago

MicrosoftAzureConsumptionInsights Resource Group Tags

Hi,   I'm looking for a way to retrieve all of the 'Resource Group' tags, instead of those of the Azure resources.   Any thoughts anyone?   Many thanks for the assist.   Jurgen
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

This is definitely the way to get consumption insights data (including Resource Tags)... but does not seem to provide any way to get at the tags of the respective parent Resource Groups.

 

I'm guessing that Jurgen wants this so that he (like me) won't need to go through his Azure resources and apply tags to all of them just so that the Resource tags match the Resource Group tags.

 

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi, i have the same use-case. Did you manage to include the Resource Groups as lines in the usage details? I'm also looking for a way to report in Power BI on Azure tags on Resource Groups, not individual resources...

  • elakey's avatar
    elakey
    New Member
    6 years ago

    I have the same question.  Has anyone found a solution?

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Here's what I do ...

       

      Weekly, I run a powershell script that dumps all our custom RG tags into a text file full of SQL statements.  I then run this to bulk load all our tags into an Azure SQL DB.

       

      In Power BI, this DB table is joined up with the consumption data to be able to show RG tags.

       

       

      #  Do this before running this script:
#  Login-AzureRmAccount

$todaysDate = Get-Date -UFormat '+%Y-%m-%d'
$results = @{}

$subscriptions=Get-AzureRMSubscription

Clear-Content c:\temp\AzureRGTags_SQLInsert_$todaysDate.sql

Add-Content c:\temp\AzureRGTags_SQLInsert_$todaysDate.sql "DELETE FROM AzureResourceGroupHistoricalPLTags WHERE DateReported = '$todaysDate';"

foreach ($vsub in $subscriptions) { 

	Select-AzureRmSubscription $vsub.SubscriptionID
	$rgs = (Get-AzureRmResourceGroup)

	foreach ($rg in $rgs) { 
		
		$ResourceGroupName=$rg.ResourceGroupName
		$SubscriptionId=$vsub.SubscriptionID
		$DateReported=$todaysDate
		$SubscriptionName=$vsub.Name
			
		if ($rg.tags -ne $null) {
			$pldepartment = $rg.tags.pldepartment
			$plclient = $rg.tags.plclient
			$plregion = $rg.tags.plregion
			$plenvironment = $rg.tags.plenvironment
			$plproduct = $rg.tags.plproduct
			$pldonotinherit = $rg.tags.pldonotinherit
			$plowner = $rg.tags.plowner
			if ($rg.tags.pldescription -ne $null) {$pldescription = $rg.tags.pldescription.Replace("'","")} else {$pldescription = 'notag'}
		} else {
			$pldepartment = ''
			$plclient = ''
			$plregion = ''
			$plenvironment = ''
			$plproduct = ''
			$pldonotinherit = ''
			$plowner = ''
			$pldescription = ''
		}
		
		Add-Content c:\temp\AzureRGTags_SQLInsert_$todaysDate.sql "INSERT INTO AzureResourceGroupHistoricalPLTags (ResourceGroupName,SubscriptionId,DateReported,SubscriptionName,pldepartment,plclient,plregion,plenvironment,plproduct,pldonotinherit,plowner,pldescription) VALUES ('$ResourceGroupName','$SubscriptionId','$DateReported','$SubscriptionName','$pldepartment','$plclient','$plregion','$plenvironment','$plproduct','$pldonotinherit','$plowner','$pldescription')"

	}
}