BookmarkSubscribeRSS Feed
japsas100
Pyrite | Level 9

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.

4 REPLIES 4
Resa
Pyrite | Level 9

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.

japsas100
Pyrite | Level 9

@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?

gwootton
SAS Super FREQ

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;
--
Greg Wootton | Principal Systems Technical Support Engineer
Resa
Pyrite | Level 9

@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.

 

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

Get Started with SAS Information Catalog in SAS Viya

SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 4 replies
  • 1066 views
  • 6 likes
  • 3 in conversation