How can I see which Smart List is associated to which member?
I had to do that on a PBCS implementation and as you know there is no access to the backend. Luckily the client named the Smart lists similar to the member names, however there were some which was shared between members!!!!
On OnPrem, it is easier I can query the tables :)
This query will give you the Smart List name along with the members it is assigned to.
What if you would like to know which Smart List members are used in which forms, you can run the below given query to get to that.
OnPrem got the answer for that too :)
I did write SQLs for the above ones and you can look them up here