topic Metadata Details via EG in Administration and Deployment

Metadata Details via EG

japsas100 — Mon, 08 Feb 2021 15:54:09 GMT

Hello,

Is there is any way to get the following details from metadata via SAS EG?

User name

Group details and also associated user under group (for example sassrv link to sas general server group.

Re: Metadata Details via EG

Resa — Mon, 08 Feb 2021 16:02:16 GMT

There are several ways to obtain this information, but I think a good starting point is the SAS blog post: "SAS administrators tip: Keeping track of SAS users".

NOTE: Be aware that the outcome is dependant on the access that you have to metadata. In other words if the account that you are using is not allowed to "see" all users that will be reflected in the outcome.

Re: Metadata Details via EG

japsas100 — Mon, 08 Feb 2021 16:55:41 GMT

@Resa

Thanks for prompt reply.

when I run this script, I noticed, I missed the sassrv user defined in SAS General Servers group. Could you please help how to add the missing user in final output?

Re: Metadata Details via EG

gwootton — Mon, 08 Feb 2021 17:25:57 GMT

The provided code reports on users and their associated identities. The SAS General Servers account is a group identity, so if you want to report on logins and their associated identity (Person or Group) you would want to change the merge DATA step accordingly. Maybe:

data work.metadata_logins (drop=keyid) ;
merge
work.logins (keep=keyid UserID)
work.group_info (keep=id name DisplayName desc in=user rename=(id=keyid desc=description))
work.person (keep=keyid name DisplayName description in=user)
;
by keyid;
if userid ne "";
run;

Re: Metadata Details via EG

Resa — Tue, 09 Feb 2021 17:00:05 GMT

@japsas100 ,

Did @gwootton replied to your question sufficiently?

Just want to make sure you have been able to retrieve the information that you were looking for.