Shared drives inventory with Powershell script

The script starts by importing the ImportExcel module, which is required for exporting data to Excel.
It queries the system to obtain a list of all available drives (excluding the C drive) using the Get-WmiObject cmdlet. Drives with drive type 3 (local hard drives) are selected.
A data array is initialized to store the collected information.
For each drive, the script iterates through all subfolders in that drive using the Get-ChildItem cmdlet, filtering only directories (folders).
For each folder, the script gathers the following information:
Drive letter
Folder name
Folder size, calculated by summing the sizes of all files in the folder and its subfolders
ACL information, obtained using the Get-Acl cmdlet. The ACL data is formatted for display by combining identity references and filesystem rights for each entry.
The collected information for each folder is stored as a custom object in the data array.
Once all drives and folders are processed, the script specifies the desired output Excel file path.
The data in the array is then exported to an Excel file using the Export-Excel cmdlet. The -AutoSize parameter is used to adjust column widths automatically for better visibility, and the data is organized in a table named “FolderInformation” with an additional title “Folder Information.”
After the export process is complete, a message is displayed indicating that the Excel file has been generated.

You can copy the PowerShell script from my blog website

https://www.infoalias.com/generate-excel-report-of-all-shared-drive-information-including-folder-name-size-and-acl-permission/