Get a list of active users and their groups

[Iro Karavasili]

Hello all,

Is there a mySQL query we could use in order to get a list with all active users and their groups?

Thank you

[Nic Brough -Adaptavist-]

You could try to build one, but you'll find it hideously complex, and hence, probably inaccurate.

Why do you think you need to do this?

[Iro Karavasili]

There is a request for this and I was wondering if there is a query someone has already used. :)

[Nic Brough -Adaptavist-]

"There is a request for this" - OK, but why?  Why are they asking?  What does the requestor hope to get from the data?

[Iro Karavasili]

@Nic Brough -Adaptavist-  we need to make a cross-check to users and the groups they belong to... I just asked if someone is familiar with this and could help.