Hi,
I have 2 tables and need to check if the name in table 1 "User_Zos" exactly occurs in table 2 "FileName in Cyberark" or partially occurs in table 2 or does not occur. I then want to have an additional column in table 1 that displays the value Exact, Partial or not.
Does anyone have a solution for this?
For example:
Table 1:
| User_ZOS | lpar | Environment | Cyberark |
| ABHS | SON | application | Not found in Cyberark |
| ADHCU | AKS | infra | EU-CIOO_PAYMENTS_SO-4STO |
| ADP0DUPS | SON | infra | EU-CIOO_PAYMENTS_SO-4STO |
| ADP0DUPX | XAT | infra | EU-CIOO_PAYMENTS_SO-4STO |
| ADP1DUPS | SON | infra | EU-CIOO_PAYMENTS_SO-4STO |
| ADP2DUPS | SON | infra | EU-CIOO_PAYMENTS_SO-4STO |
| ADP3DUPS | SON | infra | EU-CIOO_PAYMENTS_SO-4STO |
| ADP4DUPS | SON | infra | EU-CIOO_PAYMENTS_SO-4STO |
| ADP5DUPS | SON | infra | EU-CIOO_PAYMENTS_SO-4STO |
| ADP6DUPS | SON | infra | EU-CIOO_PAYMENTS_SO-4STO |
| ADP7DUPS | SON | infra | EU-CIOO_PAYMENTS_SO-4STO |
| ADP8DUPS | SON | infra | EU-CIOO_PAYMENTS_SO-4STO |
| ADP9DUPS | SON | infra | EU-CIOO_PAYMENTS_SO-4STO |
| ADPADUPS | SON | infra | EU-CIOO_PAYMENTS_SO-4STO |
| ADT0DUPS | SON | infra | EU-CIOO_PAYMENTS_SO-4STO |
| ADT1DUPS | SON | infra | EU-CIOO_PAYMENTS_SO-4STO |
| PCP | SON | infra | EU-CIOO_PAYMENTS_SO-4STO |
| AG0D | DPS | application | Not found in Cyberark |
Table 2:
| FileID | SafeID | SafeName | FileName in CyberArk |
| 10 | 10041 | EU-INF_WINDOWS-1CPM | WSAE000768.eu.rabonet.com-PSM02_F_WINDOWS-1CPM |
| 10 | 10104 | EU-ITI-AVV-Admin-1AUT | S-1-5-21-1214440339-329068152-725345543-206677 |
| 10 | 10106 | EU-IS_SDI-1CPM | ilo-sdi01w01esx003.sdi.eu.rabonet.com-administrator |
| 10 | 10112 | EU-IS_SDI-4STO | apptio@vsphere.local |
| 10 | 10202 | EU-CIOO_CTI-4STO | httpsmy.silobreaker.comSecureLogin.aspx-rabobank.display |
| 10 | 10231 | EU-ITS_RF_DET_MCA-4STO | mca.test.RSKeystore |
| 10 | 10278 | REU-INF_WINDOWS-1CPM | ace2e1e6-008b-439e-8476-df8ab77c4308.session |
| 10 | 10285 | EU-SYS_DIS_DIO_I_CRMIUP-4SDC | ESOA1OD1-csoa2od1_saf |
| 10 | 10329 | RDS-ITI_LINUX-1AUT | S-1-5-21-1957994488-682003330-948186599-143096 |
| 10 | 10498 | OC-RANZITS_DIGITALCHNNL-4SDC | rabonetoc-oc.mis.infabg |
| 10 | 10507 | EU-SYS_RF_ARA-4SDC | RABONETEU-eu.ADHCU |
| 10 | 10508 | EU-SYS_RF_ARA-4STO | RABODMZ-dmz.ARRIBAIRUAT |
| 10 | 10525 | OC-RANZITS_MDM-4SDC | mdmftprod.oc.rabonet.com-RDW |
| 10 | 10542 | AM-SAO_OPSCLNTDATAMGT-3EXT | RABONETAM - UAT-sao.FEPWEBUAT |
| 10 | 10567 | PasswordManagerD_Info | Policy-1UnixSSHRootAutoDC.ini |
| 10 | 10568 | RAP-SIN-ITI-WINDOWS-1CPM | c4be70f7-2b93-4099-af7e-e568e49ab0f0.session |
| 10 | 10579 | EU-MIDDLEWARE_SERVICES-1CPM | WSDE000394.eu.rabodev.com-PSM01__SERVICES-1CPM |
| 10 | 10641 | EU-RNL_W10LA_RB90-1ADC | S-1-5-21-1214440339-329068152-725345543-503508 |
| 10 | 10645 | EU-RNL_W10LA_RB92-1ADC | S-1-5-21-1214440339-329068152-725345543-514095 |
| 10 | 10647 | EU-RNL_W10LA_RB94-1ADC | S-1-5-21-1214440339-329068152-725345543-528089 |
| 10 | 10658 | EU-CIOO_DIS_CRMNOODREAD-1CDC | rabobank.corp-ND_RYK08 |
| 10 | 10659 | EU-CIOO_DIS_CRMNOODREAD-1CPM | ldapkrs.ZOS.rabobank.nl-NDRYK07 |
| 10 | 10707 | RDS-ITI_WINDOWS_MFA-1CPM | ATLS167001.am.rabonet.com-PSM02_NDOWS_MFA-1CPM |
| 10 | 10731 | EU-INF_POSTGRESQL-4STO | pcp |
For these tables there is a relation between User_ZOS and FileName in
Regards,
Tonni
