-
Notifications
You must be signed in to change notification settings - Fork 33
dx_get_users
Marcin Przepiorowski edited this page Jan 10, 2019
·
6 revisions
dx_get_users [ -engine|d <delphix identifier> | -all ] [ -configfile file ]
[ -format output_format ]
[ -save file_name]
[ -audit ]
[ -username <username> ]
[ -profile filename]
[ -export filename ]
[ -help|? ]
[ -debug ]
Get users information from Delphix Engine. Output Column list:
username
first Name
last Name
email
work phone
home phone
mobile phone
authtype - Native or LDAP
principal - LDAP principal
password - hardcoded value for scripts
admin_pr - Y - for delphix admin role, N - for normal user, S - sysadmin account
js_user - Y for Self Service (JS) user only, N - for normal user
- -engine|d Specify Delphix Engine name from dxtools.conf file
- -all Display databases on all Delphix appliance
- -configfile file Location of the configuration file. A config file search order is as follow:
- configfile parameter
- DXTOOLKIT_CONF variable
- dxtools.conf from dxtoolkit location
- **-format csv|json ** Define output format - csv or json Pretty print if not specified
- -save file_name Save data into file instead of screen
- -username username Specify a username to display user profile for
- -export filename Export users into file compatible with dx_ctl_users script
- -profile filename Export users profile into file compatible with dx_ctl_users script. If filename is not specified profile will be displayed on the screen
- -audit Display information about user status (locked / unlocked) and a last login time
- -help Print this screen
- -debug Turn on debugging
- -nohead Turn off csv and pretty print headers
Display all users
dx_get_users -d Landshark5
Username First Name Last Name Email work phone home phone mobile phone Authtype principal password admin_pr js_user
-------------------- -------------------- -------------------- ------------------------------ ------------ ------------ ------------ -------- ------------------------------ -------- -------- --------
sysadmin [email protected] NATIVE password N N
delphix_admin [email protected] NATIVE password Y N
dev_admin Dev Eloper [email protected] 555-555-1212 NATIVE password N N
qa_admin QA Dude [email protected] 555-555-1212 NATIVE password N N
dev Dev Eloper [email protected] 555-555-1212 NATIVE password N Y
qa QA Dude [email protected] 555-555-1212 NATIVE password N Y
Export all users into files which can be used by dx_ctl_users
dx_get_users -d SourceEngine -export /tmp/source/users.csv -profile /tmp/source/profile.csv
Display an audit information about users
dx_get_users -d Landshark5 -audit
Appliance Username Status Last login Authtype principal admin_pr js_user
-------------------- -------------------- ------------ ------------------------- -------- ------------------------------ -------- --------
Landshark5 sysadmin enabled 2018-11-20 01:07:06 GMT NATIVE S N
Landshark5 delphix_admin enabled 2018-11-20 00:45:02 GMT NATIVE Y N
Landshark5 dev enabled 2017-10-25 09:06:17 IST NATIVE N N
Landshark5 js enabled 2018-10-19 12:33:33 IST NATIVE N Y
Landshark5 user enabled N/A LDAP "uid=user,ou=People,DC=CA,DC=D N N
Delphix