I have a reference script below from (stackoverflow) which will fetch the storage account container details. it will output the subscription, storageaccount, container name and RG name.

I have a PS script that runs a script in a list of VMs within some subscription and gets a state of some agents and exports them on a CSV file.