This is something you can achieve by extending the custom client settings and collect the information using hardware inventory.
Refer to these posts https://mickitblog.blogspot.com/2016/10/sccm-mapped-drives-report.html
https://osd365.com/network-drive-inventory-using-sccm-microsoft-endpoint-configuration-manager/
Thanks,
Eswar
www.eskonr.com