Query Storage accounts for type of storage and access tier

Hello Community,

I have received a task (for Auditing) to find Storage accounts having storage type as "Queue". And also to find blobs with access tier as "Archive" . we have hundreds of storage accounts and each having lots of blobs and contents. Is there any way i can achieve this using resource graph explorer or any something else. On PowerShell i tested using Get-AzStorageAccount | Get-AzStorageContainer | Get-AzStorageBlob | where where{$_.AccessTier -eq "Archive"} this is working for scenarios where storage accounts are less, but it stucks where the number is too big, any help will be appreciated. Thank You

PS - i am relatively new to Azure and scripting