Yes, it is possible but out of the box wherein you need to extend the hardware inventory in client settings to collect the data.
Refer to this blog post for instructions http://eskonr.com/2017/03/sccm-configmgr-report-for-local-admins-and-local-group-members/
Regards,
Eswar
www.eskonr.com
If the response is helpful, please click "Accept Answer" and upvote it.