Retrieve List of active users and information

[Jed_Klei]

Hello 

I am looking for a script that will be able to pull user information , such as username , groups , related authdomains for Viya 3.5.

Most scripts I see are for sas 9.

Is there a script or tool that could be used to retrieve this info, or code that could be executed on SAS Studio?

Thank you for your reponse. 

[JuanS_OCS]

Hi @Jed_Klei ,

you might want to look into the sas-admin CLI https://documentation.sas.com/doc/en/calcdc/3.4/calcli/n01xwtcatlinzrn1gztsglukb34a.htm

You can also query, programatically, through the RestAPIs SAS VIya offers: 

https://developer.sas.com/rest-apis

[gwootton · Accepted solution]

You may want to check out this topic, which has a sample program for reporting on users and groups.
https://communities.sas.com/t5/Administration-and-Deployment/SAS-VIYA-Fetching-List-of-Users-Groups-...

This pulls information from the identities service. The credentials service has endpoints for authentication domains (/credentials/domains) and for each domain you could call /credentials/domains/domain-id/credentials, which would indicate the identity (user or group) associated with each credential in that particular domain.

[Jed_Klei]

Thank you for this.

I do experience the same issues mentioned in the post to link provided.

This is using the updated code.

My issue is the program completes with error but the temp file Work.Users is populated with 15900 users.

I then increased the obs, and each time i incremented it userinfo was loaded into the Work.userinfo,that are active and retrieved from LDAP.

Will changing the obs to 15901 ensure all users info are loaded into the temp Work.userinfo file?

[gwootton]

The table work.users is built from a loop of all users found in the identities service. Removing the obs limit, or setting it to a value higher than the total number of users, would ensure all users are added.
Without knowing the error you are encountering, I can't say why you are encountering an error.