DEPURACIÓN DE USUARIOS EN EDM

Anexos

SQL paso 5

SELECT * FROM MD_SITE_USER WHERE IS_DISABLED='N' AND USER_NAME NOT LIKE 'EDM%' 

AND USER_NAME NOT LIKE 'TOW%' AND USER_NAME NOT LIKE 'USR%' AND USER_NAME NOT LIKE 'tow%'

AND USER_NAME NOT LIKE 'usr%' AND USER_NAME NOT LIKE 'use%'

AND USER_NAME NOT LIKE 'edm%' AND USER_NAME NOT LIKE 'DSS'

AND USER_NAME NOT LIKE 'edm%' AND USER_NAME NOT LIKE 'autosync'

AND USER_NAME NOT LIKE 'edm%' AND USER_NAME NOT LIKE 'COREADMIN'

AND USER_NAME NOT LIKE 'edm%' AND USER_NAME NOT LIKE 'OWGER'

AND USER_NAME NOT LIKE 'edm%' AND USER_NAME NOT LIKE 'QETOW_BATCH'

AND USER_NAME NOT LIKE 'edm%' AND USER_NAME NOT LIKE 'DSSQUERY'

AND USER_NAME NOT LIKE 'edm%' AND USER_NAME NOT LIKE 'DWEDM'

AND USER_NAME NOT LIKE 'edm%' AND USER_NAME NOT LIKE 'towrep'

AND USER_NAME NOT LIKE 'edm%' AND USER_NAME NOT LIKE 'USE%'

AND USER_NAME NOT LIKE 'edm%' AND USER_NAME NOT LIKE 'OWREP'

ORDER BY USER_NAME_FULL

SQL paso 6

UPDATE (SELECT * FROM MD_SITE_USER WHERE IS_DISABLED='N' AND USER_NAME NOT LIKE 'EDM%'

AND USER_NAME NOT LIKE 'TOW%' AND USER_NAME NOT LIKE 'USR%' AND USER_NAME NOT LIKE 'TOW%'

AND USER_NAME NOT LIKE 'usr%' AND USER_NAME NOT LIKE 'use%'

AND USER_NAME NOT LIKE 'edm%' AND USER_NAME NOT LIKE 'DSS'

AND USER_NAME NOT LIKE 'edm%' AND USER_NAME NOT LIKE 'autosync'

AND USER_NAME NOT LIKE 'edm%' AND USER_NAME NOT LIKE 'COREADMIN'

AND USER_NAME NOT LIKE 'edm%' AND USER_NAME NOT LIKE 'OWGER'

AND USER_NAME NOT LIKE 'edm%' AND USER_NAME NOT LIKE 'QETOW_BATCH'

AND USER_NAME NOT LIKE 'edm%' AND USER_NAME NOT LIKE 'DSSQUERY'

AND USER_NAME NOT LIKE 'edm%' AND USER_NAME NOT LIKE 'DWEDM'

AND USER_NAME NOT LIKE 'edm%' AND USER_NAME NOT LIKE 'towrep'

AND USER_NAME NOT LIKE 'edm%' AND USER_NAME NOT LIKE 'USE%'

AND USER_NAME NOT LIKE 'edm%' AND USER_NAME NOT LIKE 'OWREP'

AND USER_NAME NOT LIKE 'edm%' AND USER_NAME NOT LIKE 'GUEST')

set IS_DISABLED='Y'

SQL paso 8

MERGE into MD_SITE_USER t1

using (SELECT * FROM USUARIOS_AD) t2

on (UPPER(t1.USER_NAME)=UPPER(t2.CUENTA))

when matched then update set t1.is_disabled='N'