Get list of all users email address from metadata

[Akshay1005]

Hello,

Is there any SAS code that can helps us retrieve email address of all users declared in the metadata?

Dunno by accessing the PERSON, EMAIl, etc... table

Than]king you in advance for help.

Regards,

Akshay

[JosvanderVelden]

Did you see the threads https://communities.sas.com/t5/Administration-and-Deployment/Querying-the-metadata-for-a-list-of-use... & https://communities.sas.com/t5/Administration-and-Deployment/Obtaining-my-email-address-from-metadat.... See also documentation: https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/lrmeta/p1kjy5liyi86w8n1vfopazyeb70u.htm#n1wj0...

[gwootton]

Does this program give you what you need?

https://github.com/greg-wootton/sas-programs/blob/main/Metadata%20Management/get_emails.sas

[jklaverstijn]

Any time I need user related metadata I normally take the quick and easy way and use the SAS supplied macro %MDUEXTR. It probably gives you more than you need but it saves an awful lot of coding. Do it as a first step in a EG project and the rest will be clever joining, filtering and reporting on the resulting tables. In code:

%MDUEXTR(LIBREF=WORK);

One of the resulting tables is EMAIL (all have obvious names) that can be joined with others, like PERSONS, for additional context.

Hope this helps,

- Jan.