Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT users.name AS user_name, users.friendly_name AS user_friendly_name, users.licensing_role_name, users.domain_name, sites.name AS site_name
- FROM _users users
- INNER JOIN _sites sites
- ON users.site_id = sites.id
- WHERE domain_name = 'add domain name here'
- AND users.licensing_role_name = 'Interactor'
- ORDER BY users.name ASC;
Advertisement
Add Comment
Please, Sign In to add comment