named license query

[Katrina_Fellen2]

I am looking for a way to find a list of users that have a named client license assigned to them.  I don't want to rely on the fact that I properly added them to the NAMED CLIENT user group, and the report services doesn't give it to me either.  Can anyone offer how I get that with sQL?

[Victor_Hugo_Flo]

Hello everyone, the query shared by John Anderson works excellent but in my case we have also the "Workflow/WorkView Named User Client licence" how can i add it to the sentence?

Thank you!