MySQL command: How to find all Jira active users based on email address.

[Iro Karavasili]

Hello,

I need some help with a MySQL command.
I try to find all active users that have eg "@domain.com" email address.
Any help?

Thank you in advance,
Iro

[Tuncay Senturk]

Try this one

SELECT * FROM cwd_user where active = 1 AND email_address LIKE '%@domain.com'

[Sreenivasaraju P]

Hi @Iro Karavasili

Please try

select user_name from cwd_user where active=1 and email_address like '%@domain.com%';

[Iro Karavasili]

Thanks you both.!
Just found it:
SELECT DISTINCT cwd_user.lower_user_name, cwd_user.display_name FROM cwd_user WHERE cwd_user.lower_email_address like '%domain.com' AND cwd_user.active = 1;