10-29-2013 06:38 PM
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.
10-29-2013 09:25 PM
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";
10-30-2013 04:23 PM
The %MDUEXTR macro made it easy to view user information in excel.
10-30-2013 08:34 AM
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.