topic Re: Get list of all users email address from metadata in Administration and Deployment

Get list of all users email address from metadata

Akshay1005 — Thu, 25 Aug 2022 08:15:48 GMT

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

Re: Get list of all users email address from metadata

JosvanderVelden — Thu, 25 Aug 2022 08:52:40 GMT

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

Re: Get list of all users email address from metadata

gwootton — Thu, 25 Aug 2022 13:30:01 GMT

Does this program give you what you need?

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

Re: Get list of all users email address from metadata

jklaverstijn — Fri, 26 Aug 2022 09:02:24 GMT

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.