BookmarkSubscribeRSS Feed
Otis_
Fluorite | Level 6

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.

3 REPLIES 3
SASKiwi
PROC Star

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

Otis_
Fluorite | Level 6

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

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

MichelleHomes
Meteorite | Level 14

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

//Contact me to learn how Metacoda software can help keep your SAS platform secure - https://www.metacoda.com

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 

CLI in SAS Viya

Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 1550 views
  • 3 likes
  • 3 in conversation