0

Using the Azure Resource Graph Explorer https://portal.azure.com/#blade/HubsExtension/BrowseResource/resourceType/Microsoft.Storage%2FStorageAccounts

I need to show an additional column:

URI or URL to access
Tags
Size

This query does not show those two additional columns I required:

resources
| where type =~ 'Microsoft.Storage/storageAccounts'
| extend allowBlobPublicAccess = parse_json(properties).allowBlobPublicAccess
| project subscriptionId, resourceGroup, name, allowBlobPublicAccess

This PowerShell is also not helping at all: Get-AzStorageAccount

Alexander Sloutsky
  • 2,827
  • 8
  • 13
Senior Systems Engineer
  • 1,061
  • 2
  • 27
  • 63
  • 1
    Note that we prefer a technical style of writing here. We gently discourage greetings, hope-you-can-helps, thanks, advance thanks, notes of appreciation, regards, kind regards, signatures, please-can-you-helps, chatty material and abbreviated txtspk, pleading, how long you've been stuck, voting advice, meta commentary, etc. Just explain your problem, and show what you've tried, what you expected, and what actually happened. – halfer Sep 30 '20 at 07:41
  • 1
    Hi SSE. Again your determination to treat Stack Overflow as a chatroom, and to create work for volunteer editors, has me perpetually mystified. Why would you draw negative attention to your questions when you want assistance from volunteers? – halfer Sep 30 '20 at 07:42
  • Hi @halfer, sure I will take note to be as straightforward as it is above. – Senior Systems Engineer Sep 30 '20 at 07:43

1 Answers1

1

It seems that Size is not appearing in the data that Azure Resource Explorer exposes.

For the rest columns - you can use following query to fetch it:

resources
| where type =~ 'Microsoft.Storage/storageAccounts'
| extend props = parse_json(properties)
| extend blobEndpoint = tostring(props.primaryEndpoints.blob), allowBlobPublicAccess=props.allowBlobPublicAccess
| project tags, subscriptionId, resourceGroup, name, blobEndpoint, allowBlobPublicAccess
Alexander Sloutsky
  • 2,827
  • 8
  • 13
  • Hi @alexander, does the result: This XML file does not appear to have any style information associated with it. The document tree is shown below. mean the BLOB is accessible from the external? – Senior Systems Engineer Oct 02 '20 at 07:45