This PowerShell script will collect usage information on all of the storage accounts you have access to as well as getting their location and SKU. It will output in a table format
First, you will need to install the ARMClient.exe application. This is what makes the REST calls to the the metrics APIs.