How to list all storage containers which are public in Azure in the form of Export

Neena Sharma 25

Hello,

I am trying to find a way to export all storage containers which are public in Azure. Any leads will be highly appreciated.

Regards,

Neena Sharma

Ramya Harinarthini_MSFT 5,351 Reputation points Microsoft Employee

2023-10-09T05:45:33.5766667+00:00

Neena Sharma •

Just checking in to see if the below answer helped. If this answers your query, do click "Accept the answer” for the same, which might be beneficial to other community members reading this thread. And, if you have any further query do let us know.
Ramya Harinarthini_MSFT 5,351 Reputation points Microsoft Employee

2023-10-11T05:15:57.33+00:00

Neena Sharma •

Just checking in to see if the below answer helped. If this answers your query, do click "Accept the answer” for the same, which might be beneficial to other community members reading this thread. And, if you have any further query do let us know.
Ramya Harinarthini_MSFT 5,351 Reputation points Microsoft Employee

2023-10-12T08:18:18.0233333+00:00

@Neena Sharma

Just checking in to see if the below answer helped. If this answers your query, do click "Accept the answer” for the same, which might be beneficial to other community members reading this thread. And, if you have any further query do let us know.
Ramya Harinarthini_MSFT 5,351 Reputation points Microsoft Employee

2023-10-17T14:16:42.1066667+00:00

@Neena Sharma

Just checking in to see if the below answer helped. If this answers your query, do click "Accept the answer” for the same, which might be beneficial to other community members reading this thread. And, if you have any further query do let us know.
Ramya Harinarthini_MSFT 5,351 Reputation points Microsoft Employee

2023-10-20T11:56:22.6166667+00:00

@Neena Sharma

Just checking in to see if the below answer helped. If this answers your query, do click "Accept the answer” for the same, which might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

1 answer

Ramya Harinarthini_MSFT 5,351 Reputation points Microsoft Employee

2023-09-29T06:51:55.5633333+00:00

@Neena Sharma Welcome to Microsoft Q&A, thank you for posting your here!!

Azure Storage blob inventory provides a list of the containers in your storage account, along with their associated properties. It generates an output report in either comma-separated values (CSV) or Apache Parquet format on a daily or weekly basis. You can use the report to check the list of containers along with their properties such as Public, immutability policy status, legal hold status your storage account.

Enable blob inventory report from Azure Portal: https://learn.microsoft.com/en-us/azure/storage/blobs/blob-inventory-how-to?tabs=azure-portal

Provide the Rule name and In the Container, field select the container name where the inventory report can be saved.

Source Link: https://learn.microsoft.com/en-us/azure/storage/blobs/blob-inventory

The output will be saved in the container that you have selected in the container field in the year/month/data format.

If you enable firewall rules for your storage account, inventory requests might be blocked. You can unblock these requests by providing exceptions for trusted Microsoft services. For more information, see the Exceptions section in Configure firewalls and virtual networks.

Most inventory runs complete within 24 hours. For hierarchical namespace enabled accounts, a run can take as long as two days, and depending on the number of files being processed, the run might not complete by end of that two days. The maximum amount of time that a run can complete before it fails is six days.

Hope this helps!
Kindly let us know if the above helps or you need further assistance on this issue.

Please do not forget to "Accept the answer” and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.
Please sign in to rate this answer.
Aditya Garg 61 Reputation points

2023-09-30T18:31:23.38+00:00

Thanks for this amazing answer.

I wonder if the same view is possible for multiple storage accounts and multiple subscriptions spread across the tenant? (listing all containers in subscription/across subscriptions which have public access enabled)

Ramya Harinarthini_MSFT 5,351 Reputation points Microsoft Employee

2023-10-04T09:21:25.3933333+00:00

Aditya Garg

Azure Storage Blob inventory report can only be generated at the Storage account level not at the Azure Subscription or tenant level.

Below Azure CLI command helps you list all the containers with properties. However, you have to customize to run across all subscription and tenants.

Source Link: https://learn.microsoft.com/en-us/cli/azure/storage/container?view=azure-cli-latest#az-storage-container-list()

az storage container list --account-name <accountname> --auth-mode login

[ { "deleted": null, "encryptionScope": { "defaultEncryptionScope": "$account-encryption-key", "preventEncryptionScopeOverride": false }, "immutableStorageWithVersioningEnabled": false, "metadata": null, "name": "dfs", "properties": { "etag": "\"0x8DBA475A66FD14F\"", "hasImmutabilityPolicy": false, "hasLegalHold": false, "lastModified": "2023-08-24T07:42:21+00:00", "lease": { "duration": null, "state": "available", "status": "unlocked" }, "publicAccess": null }, "version": null }, { "deleted": null, "encryptionScope": { "defaultEncryptionScope": "$account-encryption-key", "preventEncryptionScopeOverride": false }, "immutableStorageWithVersioningEnabled": false, "metadata": null, "name": "hsfgftfd", "properties": { "etag": "\"0x8DB8390B209AD8E\"", "hasImmutabilityPolicy": false, "hasLegalHold": false, "lastModified": "2023-07-13T11:02:48+00:00", "lease": { "duration": null, "state": "broken", "status": "unlocked" }, "publicAccess": null }, "version": null }, { "deleted": null, "encryptionScope": { "defaultEncryptionScope": "$account-encryption-key", "preventEncryptionScopeOverride": false }, "immutableStorageWithVersioningEnabled": false, "metadata": null, "name": "immutable", "properties": { "etag": "\"0x8DBA7DFFC5002B0\"", "hasImmutabilityPolicy": false, "hasLegalHold": false, "lastModified": "2023-08-28T16:01:05+00:00", "lease": { "duration": null, "state": "available", "status": "unlocked" }, "publicAccess": null }, "version": null }, { "deleted": null, "encryptionScope": { "defaultEncryptionScope": "$account-encryption-key", "preventEncryptionScopeOverride": false }, "immutableStorageWithVersioningEnabled": false, "metadata": null, "name": "test", "properties": { "etag": "\"0x8DB9808F5C04699\"", "hasImmutabilityPolicy": false, "hasLegalHold": false, "lastModified": "2023-08-08T12:14:05+00:00", "lease": { "duration": null, "state": "available", "status": "unlocked" }, "publicAccess": "container" }, "version": null }, { "deleted": null, "encryptionScope": { "defaultEncryptionScope": "$account-encryption-key", "preventEncryptionScopeOverride": false }, "immutableStorageWithVersioningEnabled": false, "metadata": null, "name": "test123", "properties": { "etag": "\"0x8DB9808D048FB63\"", "hasImmutabilityPolicy": false, "hasLegalHold": false, "lastModified": "2023-08-08T12:13:02+00:00", "lease": { "duration": null, "state": "broken", "status": "unlocked" }, "publicAccess": "blob" }, "version": null } ]

Hope this helps!
Kindly let us know if the above helps or you need further assistance on this issue.

Please do not forget to "Accept the answer” and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

How to list all storage containers which are public in Azure in the form of Export

1 answer

Your answer