How to retrieive SI_MAIL_ADDRESSES

[sasa888]

Hi all, I would like to know if there is a way just to retrieve this field from InfoObject? Thanks!

 

[SomeHelp]

You can use Query Builder application, which can be found on the User Launchpad under Client Samples. This query pulls email addresses from the CMS database and will display the email address of Crystal Enterprise users.

SELECT SI_EMAIL_ADDRESS FROM CI_SYSTEMOBJECTS
WHERE SI_PROGID ='CrystalEnterprise.User'

You can add these fields to the SQL to pull more user information: SI_NAME, SI_USERFULLNAME, SI_DESCRIPTION

I hope this helps...