I would like to be able to filter results based on resource groups names. Not the long subscriptionid.

[bbengs75]

No description provided.

[tdjastrzebski]

Just create a new db view containing extracted ResourceGroup and ResourceName

create view dbo.AzureUsageRecordsView
as
select *,
ResourceGroup = case when len(ResourceUri) > 68 then substring(ResourceUri, 68, charindex('/', ResourceUri, 68) - 68) else '' end,
ResourceName = case when len(ResourceUri) > 2 then substring(ResourceUri, len(ResourceUri) - charindex('/', reverse(ResourceUri))+2, charindex('/', reverse(ResourceUri))-1) else '' end
from dbo.AzureUsageRecords

[tdjastrzebski]

resource group names have been added to master branch - use dbo.AzureUsageRecordsView