topic Re: How to find multiple users in Management Console? in Administration and Deployment

How to find multiple users in Management Console?

Otis_ — Tue, 29 Oct 2013 22:38:10 GMT

I would like to check against an excel worksheet to see which users exist on a particular metadata server. My approach so far has been to search for individual users one by one with the user manager plugin in the management console. Are there any approaches to search for many users with one search string or automate the task somehow?

I'm using version 9.3 M1.

Re: How to find multiple users in Management Console?

SASKiwi — Wed, 30 Oct 2013 01:25:22 GMT

You could try the following which will output some SAS datasets with the info you want (you will need admin access to your metadata server - substitute your own metadata userid and password):

options metaserver=sasmetadata metauser="sasadm@saspw" metapass="password";

%mduextr(libref=work);

Re: How to find multiple users in Management Console?

MichelleHomes — Wed, 30 Oct 2013 12:34:08 GMT

The Metacoda Security Plug-ins User Reviewer may also help you achieve what you are after within the SAS Management Console, http://www.metacoda.com/en/metacoda-security-plug-ins/user-reviewer/ Click on the screenshots on the page to have a look at what it provides. You can search for users and the reviewer also produces reports on the results.

We provide 30-day free evaluations if you want to try out the software.

Kind Regards,

Michelle

Re: How to find multiple users in Management Console?

Otis_ — Wed, 30 Oct 2013 20:23:25 GMT

The %MDUEXTR macro made it easy to view user information in excel.

%MDUEXTR :: SAS(R) 9.3 Intelligence Platform: Security Administration Guide