Thanks for the response.
We tried T SQL and wasn’t able to get the data in the correct format so we found a solution which was to run a PowerShell script against DB instances. The script pulls back user ID, DB instance and type of account, i.e. Windows User, Group, SQL User etc. Where in a Windows Group it pulls back the members of that group. We are doing a similar thing for Windows OS layer reviews to pull a full list of all users accounts saving us having to create user reviews for each AD group.