How to get the users email from Query Builder

general discussion
1

I’m looking to pull out the e-mail address from Users in CMC. I have three queries I’ve used in QB, so my knowledge is severely limited . . .

I ran this query but don’t see an e-mail address, although it does have their user name (si_name), which I could fiddle with to get their email address.

select *
from ci_infoobjects
where si_kind = ‘FavoritesFolder’
order by si_name

gadsden_consulting :us: (BOB member since 2015-06-18)

2

You could try this tool:-

https://bobj-board.org/t/89434

Mak 1 :uk: (BOB member since 2005-01-06)

3

select SI_NAME,SI_EMAIL_ADDRESS from CI_SYSTEMOBJECTS where SI_KIND=‘User’

ABILtd :uk: (BOB member since 2006-02-08)