Architecting, installing and maintaining your SAS environment

How to find multiple users in Management Console?

Reply
Occasional Contributor
Posts: 6

How to find multiple users in Management Console?

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.

Super User
Posts: 3,250

Re: How to find multiple users in Management Console?

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);

Occasional Contributor
Posts: 6

Re: How to find multiple users in Management Console?

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

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

Trusted Advisor
Posts: 1,319

Re: How to find multiple users in Management Console?

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

Ask a Question
Discussion stats
  • 3 replies
  • 500 views
  • 3 likes
  • 3 in conversation