-
Notifications
You must be signed in to change notification settings - Fork 33
dx_get_env
Marcin Przepiorowski edited this page Jul 3, 2024
·
6 revisions
dx_get_env [-engine|d <delphix identifier> | -all ]
[-name env_name | -reference reference ]
[-backup]
[-replist ]
[-userlist ]
[-cluster ]
[-sourcelist [-dbname name]]
[-format csv|json ]
[-help|? ]
[-debug ]
Get the information about host environment.
Delphix Engine selection - if not specified a default host(s) from dxtools.conf will be used.
- -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
- -name Environment Name
- -reference Environment reference
- -backup Display dxtoolkit commands to recreate environments ( support for SI Oracle / MS SQL )
- -replist Display repository list (Orcle Home / MS SQL instance / etc ) for environment
- -cluster Print ; segrageted list of cluster nodes from the environment into a new column called cluster nodes
- -userlist Print list of user for each environment
- -sourcelist Print list of source databases ( discovered or added )
- -dbname name Print source database(s) with the "name"
- -format Display output in csv or json format If not specified pretty formatting is used.
- -help Print this screen
- -debug Turn on debugging
Display all environments
dx_get_env -d Landshark
Appliance Environment Name Type Status OS Version Environment Users
-------------------- ------------------------------ ------------------------- -------- -------------------------------------------------- ------------------------------
dxtest marcinsybasesrc.xxx.com unix enabled Red Hat Enterprise Linux release 8.3 (Ootpa) *sybase;
dxtest marcinorasrc.xxx.com unix enabled Red Hat Enterprise Linux Server release 7.8 (Maipo *oracle;oracle2
dxtest marcinposttgt.xxx.com unix enabled Red Hat Enterprise Linux release 8.6 (Ootpa) *postgres;
dxtest marcinoratgt.xxx.com unix enabled Red Hat Enterprise Linux Server release 7.8 (Maipo *oracle;
dxtest marcinsybasetgt.xxx.com unix enabled Red Hat Enterprise Linux release 8.3 (Ootpa) *sybase;
dxtest marcinmssqltgt.xxx.com windows enabled Windows Server 2016 Standard *QA-AD\ADuser;
dxtest marcinmssqlsrc.xxx.com windows enabled Windows Server 2016 Standard *QA-AD\ADuser;
Display all environments with repositories list
dx_get_env -d Landshark -replist
Appliance Environment Name Repository list
-------------------- ------------------------------ ------------------------------
Landshark racattack
/u01/app/oracle/11.2.0.4/racho
Landshark LINUXTARGET
agilemasking
LINUXTARGET
/u01/app/oracle/product/11.2.0
Landshark LINUXSOURCE
webapp
agilemasking
LINUXSOURCE
/u01/app/oracle/product/11.2.0
Landshark envtest
/u01/app/oracle/11.2.0.4/db1
Landshark WINDOWSSOURCE
MSSQLSERVER
Landshark WINDOWSTARGET
MSSQLSERVER
MSSQL2012
Display all environments with cluster list
dx_get_env -d Landshark -cluster
Appliance Environment Name Type Status OS Version Hostname
-------------------- ------------------------------ ------------------------- --------------- -------------------------------------------------------- ---------------------
Landshark5 racattack-cl rac enabled Red Hat Enterprise Linux Server release 7.9 (Maipo) server1;10.***.**.01
Landshark5 LINUXTARGET unix enabled Red Hat Enterprise Linux Server release 7.9 (Maipo) server2;10.***.**.02
Landshark5 LINUXSOURCE unix enabled Red Hat Enterprise Linux Server release 7.9 (Maipo) server3;10.***.**.03
Landshark5 WINDOWSTARGET windows enabled Red Hat Enterprise Linux Server release 7.9 (Maipo) server4;10.***.**.04
Landshark5 WINDOWSSOURCE windows enabled Red Hat Enterprise Linux Server release 7.9 (Maipo) server5;10.***.**.05
Display all environments with user list
dx_get_env -d Landshark -userlist
Appliance Environment Name User name Status Auth Type
-------------------- ------------------------------ ----------------------- --------------- ---------------
Landshark5 racattack-cl *delphix enabled password
Landshark5 LINUXTARGET *delphix enabled password
Landshark5 LINUXSOURCE *delphix enabled systemkey
Landshark5 WINDOWSTARGET *delphix enabled password
Landshark5 WINDOWSSOURCE *delphix enabled systemkey
Display all databases
dx_get_env -d dxtest -sourcelist
Appliance Environment Name Repository DB name DB type dSource/VD dSource/VDB name
-------------------- ------------------------------ ------------------------------ ------------------------------ ------------------------------ ---------- ------------------------------
dxtest marcinsybasesrc.xxx.com ASE160_SRC db_rhel83_160_0 sybase not ingested
dxtest marcinsybasesrc.xxx.com ASE160_SRC db_rhel83_160_1 sybase dSource db_rhel83_160_1
dxtest marcinsybasesrc.xxx.com ASE160_SRC db_rhel83_160_2 sybase not ingested
dxtest marcinsybasesrc.xxx.com ASE160_SRC db_rhel83_160_3 sybase not ingested
dxtest marcinorasrc.xxx.com /u01/app/oracle/product/19.0.0 ORACLEXXCA1DPDB1 oracle PDB dSource ORACLEXXCA1DPDB1
dxtest marcinorasrc.xxx.com /u01/app/oracle/product/19.0.0 ORACLEXXCA1DPDB2 oracle PDB not ingested
dxtest marcinorasrc.xxx.com /u01/app/oracle/product/19.0.0 ORACLEXXCA1DPDB3 oracle PDB not ingested
dxtest marcinorasrc.xxx.com /u01/app/oracle/product/19.0.0 ORACLESI oracle dSource ORACLESI85E9
dxtest marcinorasrc.xxx.com /u01/app/oracle/product/19.0.0 ORACLEXX oracle CDB CDB CDOMLOSRCA1D
dxtest marcinorasrc.xxx.com /u01/app/oracle/product/19.0.0 CDOMSHSR oracle CDB CDB CDOMSHSRF517
dxtest marcinposttgt.xxx.com Postgres vFiles (15.2) Postgres-5444 - /mnt/provision postgresql VDB postsing
dxtest marcinposttgt.xxx.com Postgres vFiles (15.2) Postgres-5445 - /mnt/provision postgresql VDB post
dxtest marcinposttgt.xxx.com Postgres vFiles (15.2) singledb postgresql dSource singledb
dxtest marcinposttgt.xxx.com Postgres vFiles (15.2) postds postgresql dSource postds
dxtest marcinposttgt.xxx.com Postgres vFiles (15.2) dxttest3 postgresql not ingested
dxtest marcinoratgt.xxx.com /u01/app/oracle/product/19.0.0 tdetest oracle PDB VDB tdetest
dxtest marcinoratgt.xxx.com /u01/app/oracle/product/19.0.0 pdbtest oracle PDB VDB pdbtest
dxtest marcinoratgt.xxx.com /u01/app/oracle/product/19.0.0 pdbtest2 oracle PDB VDB pdbtest2
dxtest marcinoratgt.xxx.com /u01/app/oracle/product/19.0.0 oratest oracle VDB oratest
dxtest marcinoratgt.xxx.com /u01/app/oracle/product/19.0.0 oratest2 oracle VDB oratest2
dxtest marcinsybasetgt.xxx.com ASE160_TGT dxrnuv2Prvcrr93H7A_l83_160_1 sybase dSource db_rhel83_160_1
dxtest marcinsybasetgt.xxx.com ASE160_TGT sybasetest sybase VDB sybasetest
dxtest marcinmssqltgt.xxx.com SQL2016 dummystg mssql dSource dummystg
dxtest marcinmssqltgt.xxx.com SQL2016 ec2d3f84-b46d-75e3-0c32-04d637 mssql dSource SourceXYZ
dxtest marcinmssqltgt.xxx.com SQL2016 mssqltest mssql VDB mssqltest
dxtest marcinmssqlsrc.xxx.com SQL2016 SourceXYZ mssql dSource SourceXYZ
Test if one database have been discovered on the environment
dx_get_env -d dxtest -sourcelist -dbname oratest -name marcinoratgt.xxx.com
Appliance Environment Name Repository DB name DB type dSource/VD dSource/VDB name
-------------------- ------------------------------ ------------------------------ ------------------------------ ------------------------------ ---------- ------------------------------
dxtest marcinoratgt.xxx.com /u01/app/oracle/product/19.0.0 oratest oracle VDB oratest
Delphix