OPTIONAL MATCH (existing:Profile {profileType: 'OrchAdminProfile', profileId: 100001}) WHERE existing IS NULL MATCH (i:Identity { email: 'automationqa@theorchard.com' })-[:HAS_PROFILE]-(p:Profile { profileType: 'OrchAdminProfile' }) WITH p ORDER BY p.profileId DESC WITH head(collect(p)) as p SET p.profileId = 100001; OPTIONAL MATCH (existing:Profile {profileType: 'OrchAdminProfile', profileId: 100007}) WHERE existing IS NULL MATCH (i:Identity { email: 'sony_role_23@theorchard.io' })-[:HAS_PROFILE]-(p:Profile { profileType: 'OrchAdminProfile' }) WITH p ORDER BY p.profileId DESC WITH head(collect(p)) as p SET p.profileId = 100007; OPTIONAL MATCH (existing:Profile {profileType: 'OrchAdminProfile', profileId: 100008}) WHERE existing IS NULL MATCH (i:Identity { email: 'sony_role_22@theorchard.io' })-[:HAS_PROFILE]-(p:Profile { profileType: 'OrchAdminProfile' }) WITH p ORDER BY p.profileId DESC WITH head(collect(p)) as p SET p.profileId = 100008; OPTIONAL MATCH (existing:Profile {profileType: 'OrchAdminProfile', profileId: 100009}) WHERE existing IS NULL MATCH (i:Identity { email: 'sony_role_21@theorchard.io' })-[:HAS_PROFILE]-(p:Profile { profileType: 'OrchAdminProfile' }) WITH p ORDER BY p.profileId DESC WITH head(collect(p)) as p SET p.profileId = 100009; OPTIONAL MATCH (existing:Profile {profileType: 'OrchAdminProfile', profileId: 100010}) WHERE existing IS NULL MATCH (i:Identity { email: 'sony_role_20@theorchard.io' })-[:HAS_PROFILE]-(p:Profile { profileType: 'OrchAdminProfile' }) WITH p ORDER BY p.profileId DESC WITH head(collect(p)) as p SET p.profileId = 100010; OPTIONAL MATCH (existing:Profile {profileType: 'OrchAdminProfile', profileId: 100011}) WHERE existing IS NULL MATCH (i:Identity { email: 'sony_role_19@theorchard.io' })-[:HAS_PROFILE]-(p:Profile { profileType: 'OrchAdminProfile' }) WITH p ORDER BY p.profileId DESC WITH head(collect(p)) as p SET p.profileId = 100011; OPTIONAL MATCH (existing:Profile {profileType: 'OrchAdminProfile', profileId: 100012}) WHERE existing IS NULL MATCH (i:Identity { email: 'sony_role_17@theorchard.io' })-[:HAS_PROFILE]-(p:Profile { profileType: 'OrchAdminProfile' }) WITH p ORDER BY p.profileId DESC WITH head(collect(p)) as p SET p.profileId = 100012; OPTIONAL MATCH (existing:Profile {profileType: 'OrchAdminProfile', profileId: 100013}) WHERE existing IS NULL MATCH (i:Identity { email: 'sony_role_16@theorchard.io' })-[:HAS_PROFILE]-(p:Profile { profileType: 'OrchAdminProfile' }) WITH p ORDER BY p.profileId DESC WITH head(collect(p)) as p SET p.profileId = 100013; OPTIONAL MATCH (existing:Profile {profileType: 'OrchAdminProfile', profileId: 100014}) WHERE existing IS NULL MATCH (i:Identity { email: 'sony_role_14@theorchard.io' })-[:HAS_PROFILE]-(p:Profile { profileType: 'OrchAdminProfile' }) WITH p ORDER BY p.profileId DESC WITH head(collect(p)) as p SET p.profileId = 100014; OPTIONAL MATCH (existing:Profile {profileType: 'OrchAdminProfile', profileId: 100015}) WHERE existing IS NULL MATCH (i:Identity { email: 'sony_role_13@theorchard.io' })-[:HAS_PROFILE]-(p:Profile { profileType: 'OrchAdminProfile' }) WITH p ORDER BY p.profileId DESC WITH head(collect(p)) as p SET p.profileId = 100015; OPTIONAL MATCH (existing:Profile {profileType: 'OrchAdminProfile', profileId: 100016}) WHERE existing IS NULL MATCH (i:Identity { email: 'sony_role_12@theorchard.io' })-[:HAS_PROFILE]-(p:Profile { profileType: 'OrchAdminProfile' }) WITH p ORDER BY p.profileId DESC WITH head(collect(p)) as p SET p.profileId = 100016; OPTIONAL MATCH (existing:Profile {profileType: 'OrchAdminProfile', profileId: 100017}) WHERE existing IS NULL MATCH (i:Identity { email: 'sony_role_11@theorchard.io' })-[:HAS_PROFILE]-(p:Profile { profileType: 'OrchAdminProfile' }) WITH p ORDER BY p.profileId DESC WITH head(collect(p)) as p SET p.profileId = 100017; OPTIONAL MATCH (existing:Profile {profileType: 'OrchAdminProfile', profileId: 100018}) WHERE existing IS NULL MATCH (i:Identity { email: 'sony_role_10@theorchard.io' })-[:HAS_PROFILE]-(p:Profile { profileType: 'OrchAdminProfile' }) WITH p ORDER BY p.profileId DESC WITH head(collect(p)) as p SET p.profileId = 100018; OPTIONAL MATCH (existing:Profile {profileType: 'OrchAdminProfile', profileId: 100019}) WHERE existing IS NULL MATCH (i:Identity { email: 'sony_role_09@theorchard.io' })-[:HAS_PROFILE]-(p:Profile { profileType: 'OrchAdminProfile' }) WITH p ORDER BY p.profileId DESC WITH head(collect(p)) as p SET p.profileId = 100019; OPTIONAL MATCH (existing:Profile {profileType: 'OrchAdminProfile', profileId: 100020}) WHERE existing IS NULL MATCH (i:Identity { email: 'sony_role_08@theorchard.io' })-[:HAS_PROFILE]-(p:Profile { profileType: 'OrchAdminProfile' }) WITH p ORDER BY p.profileId DESC WITH head(collect(p)) as p SET p.profileId = 100020; OPTIONAL MATCH (existing:Profile {profileType: 'OrchAdminProfile', profileId: 100021}) WHERE existing IS NULL MATCH (i:Identity { email: 'sony_role_07@theorchard.io' })-[:HAS_PROFILE]-(p:Profile { profileType: 'OrchAdminProfile' }) WITH p ORDER BY p.profileId DESC WITH head(collect(p)) as p SET p.profileId = 100021; OPTIONAL MATCH (existing:Profile {profileType: 'OrchAdminProfile', profileId: 100022}) WHERE existing IS NULL MATCH (i:Identity { email: 'sony_role_06@theorchard.io' })-[:HAS_PROFILE]-(p:Profile { profileType: 'OrchAdminProfile' }) WITH p ORDER BY p.profileId DESC WITH head(collect(p)) as p SET p.profileId = 100022; OPTIONAL MATCH (existing:Profile {profileType: 'OrchAdminProfile', profileId: 100023}) WHERE existing IS NULL MATCH (i:Identity { email: 'sony_role_05@theorchard.io' })-[:HAS_PROFILE]-(p:Profile { profileType: 'OrchAdminProfile' }) WITH p ORDER BY p.profileId DESC WITH head(collect(p)) as p SET p.profileId = 100023; OPTIONAL MATCH (existing:Profile {profileType: 'OrchAdminProfile', profileId: 100024}) WHERE existing IS NULL MATCH (i:Identity { email: 'sony_role_04@theorchard.io' })-[:HAS_PROFILE]-(p:Profile { profileType: 'OrchAdminProfile' }) WITH p ORDER BY p.profileId DESC WITH head(collect(p)) as p SET p.profileId = 100024; OPTIONAL MATCH (existing:Profile {profileType: 'OrchAdminProfile', profileId: 100025}) WHERE existing IS NULL MATCH (i:Identity { email: 'sony_role_03@theorchard.io' })-[:HAS_PROFILE]-(p:Profile { profileType: 'OrchAdminProfile' }) WITH p ORDER BY p.profileId DESC WITH head(collect(p)) as p SET p.profileId = 100025; OPTIONAL MATCH (existing:Profile {profileType: 'OrchAdminProfile', profileId: 100026}) WHERE existing IS NULL MATCH (i:Identity { email: 'sony_role_02@theorchard.io' })-[:HAS_PROFILE]-(p:Profile { profileType: 'OrchAdminProfile' }) WITH p ORDER BY p.profileId DESC WITH head(collect(p)) as p SET p.profileId = 100026; OPTIONAL MATCH (existing:Profile {profileType: 'OrchAdminProfile', profileId: 100027}) WHERE existing IS NULL MATCH (i:Identity { email: 'sony_role_01@theorchard.io' })-[:HAS_PROFILE]-(p:Profile { profileType: 'OrchAdminProfile' }) WITH p ORDER BY p.profileId DESC WITH head(collect(p)) as p SET p.profileId = 100027; OPTIONAL MATCH (existing:Profile {profileType: 'OrchAdminProfile', profileId: 100028}) WHERE existing IS NULL MATCH (i:Identity { email: 'ishapoval@theorchard.com' })-[:HAS_PROFILE]-(p:Profile { profileType: 'OrchAdminProfile' }) WITH p ORDER BY p.profileId DESC WITH head(collect(p)) as p SET p.profileId = 100028; OPTIONAL MATCH (existing:Profile {profileType: 'OrchAdminProfile', profileId: 100030}) WHERE existing IS NULL MATCH (i:Identity { email: 'rvanstiphout@theorchard.com' })-[:HAS_PROFILE]-(p:Profile { profileType: 'OrchAdminProfile' }) WITH p ORDER BY p.profileId DESC WITH head(collect(p)) as p SET p.profileId = 100030; OPTIONAL MATCH (existing:Profile {profileType: 'OrchAdminProfile', profileId: 100031}) WHERE existing IS NULL MATCH (i:Identity { email: 'buvarov@theorchard.com' })-[:HAS_PROFILE]-(p:Profile { profileType: 'OrchAdminProfile' }) WITH p ORDER BY p.profileId DESC WITH head(collect(p)) as p SET p.profileId = 100031; OPTIONAL MATCH (existing:Profile {profileType: 'OrchAdminProfile', profileId: 100037}) WHERE existing IS NULL MATCH (i:Identity { email: 'aduduskar@theorchard.com' })-[:HAS_PROFILE]-(p:Profile { profileType: 'OrchAdminProfile' }) WITH p ORDER BY p.profileId DESC WITH head(collect(p)) as p SET p.profileId = 100037; OPTIONAL MATCH (existing:Profile {profileType: 'OrchAdminProfile', profileId: 100038}) WHERE existing IS NULL MATCH (i:Identity { email: 'dtertyshnik@theorchard.com' })-[:HAS_PROFILE]-(p:Profile { profileType: 'OrchAdminProfile' }) WITH p ORDER BY p.profileId DESC WITH head(collect(p)) as p SET p.profileId = 100038; OPTIONAL MATCH (existing:Profile {profileType: 'OrchAdminProfile', profileId: 100040}) WHERE existing IS NULL MATCH (i:Identity { email: 'aabouargub@theorchard.com' })-[:HAS_PROFILE]-(p:Profile { profileType: 'OrchAdminProfile' }) WITH p ORDER BY p.profileId DESC WITH head(collect(p)) as p SET p.profileId = 100040; OPTIONAL MATCH (existing:Profile {profileType: 'OrchAdminProfile', profileId: 100042}) WHERE existing IS NULL MATCH (i:Identity { email: 'victoria.lowther@sonymusic.com' })-[:HAS_PROFILE]-(p:Profile { profileType: 'OrchAdminProfile' }) WITH p ORDER BY p.profileId DESC WITH head(collect(p)) as p SET p.profileId = 100042; OPTIONAL MATCH (existing:Profile {profileType: 'OrchAdminProfile', profileId: 100043}) WHERE existing IS NULL MATCH (i:Identity { email: 'maya.primor@sonymusic.com' })-[:HAS_PROFILE]-(p:Profile { profileType: 'OrchAdminProfile' }) WITH p ORDER BY p.profileId DESC WITH head(collect(p)) as p SET p.profileId = 100043; OPTIONAL MATCH (existing:Profile {profileType: 'OrchAdminProfile', profileId: 100044}) WHERE existing IS NULL MATCH (i:Identity { email: 'nicole.samul@sonymusic.com' })-[:HAS_PROFILE]-(p:Profile { profileType: 'OrchAdminProfile' }) WITH p ORDER BY p.profileId DESC WITH head(collect(p)) as p SET p.profileId = 100044; OPTIONAL MATCH (existing:Profile {profileType: 'OrchAdminProfile', profileId: 100045}) WHERE existing IS NULL MATCH (i:Identity { email: 'markus.kramme@sonymusic.com' })-[:HAS_PROFILE]-(p:Profile { profileType: 'OrchAdminProfile' }) WITH p ORDER BY p.profileId DESC WITH head(collect(p)) as p SET p.profileId = 100045; OPTIONAL MATCH (existing:Profile {profileType: 'OrchAdminProfile', profileId: 100047}) WHERE existing IS NULL MATCH (i:Identity { email: 'ajey.pandey@sonymusic.com' })-[:HAS_PROFILE]-(p:Profile { profileType: 'OrchAdminProfile' }) WITH p ORDER BY p.profileId DESC WITH head(collect(p)) as p SET p.profileId = 100047; OPTIONAL MATCH (existing:Profile {profileType: 'OrchAdminProfile', profileId: 100048}) WHERE existing IS NULL MATCH (i:Identity { email: 'nidhi.sahu@sonymusic.com' })-[:HAS_PROFILE]-(p:Profile { profileType: 'OrchAdminProfile' }) WITH p ORDER BY p.profileId DESC WITH head(collect(p)) as p SET p.profileId = 100048; OPTIONAL MATCH (existing:Profile {profileType: 'OrchAdminProfile', profileId: 100050}) WHERE existing IS NULL MATCH (i:Identity { email: 'yzozulya@theorchard.com' })-[:HAS_PROFILE]-(p:Profile { profileType: 'OrchAdminProfile' }) WITH p ORDER BY p.profileId DESC WITH head(collect(p)) as p SET p.profileId = 100050; OPTIONAL MATCH (existing:Profile {profileType: 'OrchAdminProfile', profileId: 100051}) WHERE existing IS NULL MATCH (i:Identity { email: 'iyepes-arroyo@theorchard.com' })-[:HAS_PROFILE]-(p:Profile { profileType: 'OrchAdminProfile' }) WITH p ORDER BY p.profileId DESC WITH head(collect(p)) as p SET p.profileId = 100051; OPTIONAL MATCH (existing:Profile {profileType: 'OrchAdminProfile', profileId: 100052}) WHERE existing IS NULL MATCH (i:Identity { email: 'dbogdanov@theorchard.com' })-[:HAS_PROFILE]-(p:Profile { profileType: 'OrchAdminProfile' }) WITH p ORDER BY p.profileId DESC WITH head(collect(p)) as p SET p.profileId = 100052; OPTIONAL MATCH (existing:Profile {profileType: 'OrchAdminProfile', profileId: 100053}) WHERE existing IS NULL MATCH (i:Identity { email: 'ymuryi@theorchard.com' })-[:HAS_PROFILE]-(p:Profile { profileType: 'OrchAdminProfile' }) WITH p ORDER BY p.profileId DESC WITH head(collect(p)) as p SET p.profileId = 100053; OPTIONAL MATCH (existing:Profile {profileType: 'OrchAdminProfile', profileId: 100054}) WHERE existing IS NULL MATCH (i:Identity { email: 'ziggy.pothoff@sonymusic.com' })-[:HAS_PROFILE]-(p:Profile { profileType: 'OrchAdminProfile' }) WITH p ORDER BY p.profileId DESC WITH head(collect(p)) as p SET p.profileId = 100054; OPTIONAL MATCH (existing:Profile {profileType: 'OrchAdminProfile', profileId: 100056}) WHERE existing IS NULL MATCH (i:Identity { email: 'anavalu@theorchard.com' })-[:HAS_PROFILE]-(p:Profile { profileType: 'OrchAdminProfile' }) WITH p ORDER BY p.profileId DESC WITH head(collect(p)) as p SET p.profileId = 100056; OPTIONAL MATCH (existing:Profile {profileType: 'OrchAdminProfile', profileId: 100057}) WHERE existing IS NULL MATCH (i:Identity { email: 'atestemail880@gmail.com' })-[:HAS_PROFILE]-(p:Profile { profileType: 'OrchAdminProfile' }) WITH p ORDER BY p.profileId DESC WITH head(collect(p)) as p SET p.profileId = 100057; OPTIONAL MATCH (existing:Profile {profileType: 'OrchAdminProfile', profileId: 100058}) WHERE existing IS NULL MATCH (i:Identity { email: 'emmyteest@gmail.com' })-[:HAS_PROFILE]-(p:Profile { profileType: 'OrchAdminProfile' }) WITH p ORDER BY p.profileId DESC WITH head(collect(p)) as p SET p.profileId = 100058; OPTIONAL MATCH (existing:Profile {profileType: 'OrchAdminProfile', profileId: 100059}) WHERE existing IS NULL MATCH (i:Identity { email: 'vimal.nagaraj.dtg@sonymusic.com' })-[:HAS_PROFILE]-(p:Profile { profileType: 'OrchAdminProfile' }) WITH p ORDER BY p.profileId DESC WITH head(collect(p)) as p SET p.profileId = 100059; OPTIONAL MATCH (existing:Profile {profileType: 'OrchAdminProfile', profileId: 100060}) WHERE existing IS NULL MATCH (i:Identity { email: 'gquintino@theorchard.com' })-[:HAS_PROFILE]-(p:Profile { profileType: 'OrchAdminProfile' }) WITH p ORDER BY p.profileId DESC WITH head(collect(p)) as p SET p.profileId = 100060; OPTIONAL MATCH (existing:Profile {profileType: 'OrchAdminProfile', profileId: 100062}) WHERE existing IS NULL MATCH (i:Identity { email: 'amhatre@theorchard.com' })-[:HAS_PROFILE]-(p:Profile { profileType: 'OrchAdminProfile' }) WITH p ORDER BY p.profileId DESC WITH head(collect(p)) as p SET p.profileId = 100062; OPTIONAL MATCH (existing:Profile {profileType: 'OrchAdminProfile', profileId: 100063}) WHERE existing IS NULL MATCH (i:Identity { email: 'automationqa@theorchard.io' })-[:HAS_PROFILE]-(p:Profile { profileType: 'OrchAdminProfile' }) WITH p ORDER BY p.profileId DESC WITH head(collect(p)) as p SET p.profileId = 100063; OPTIONAL MATCH (existing:Profile {profileType: 'OrchAdminProfile', profileId: 100067}) WHERE existing IS NULL MATCH (i:Identity { email: 'yostapyuk@theorchard.com' })-[:HAS_PROFILE]-(p:Profile { profileType: 'OrchAdminProfile' }) WITH p ORDER BY p.profileId DESC WITH head(collect(p)) as p SET p.profileId = 100067; OPTIONAL MATCH (existing:Profile {profileType: 'OrchAdminProfile', profileId: 100068}) WHERE existing IS NULL MATCH (i:Identity { email: 'fsantos@theorchard.com' })-[:HAS_PROFILE]-(p:Profile { profileType: 'OrchAdminProfile' }) WITH p ORDER BY p.profileId DESC WITH head(collect(p)) as p SET p.profileId = 100068; OPTIONAL MATCH (existing:Profile {profileType: 'OrchAdminProfile', profileId: 100069}) WHERE existing IS NULL MATCH (i:Identity { email: 'jcoello@theorchard.com' })-[:HAS_PROFILE]-(p:Profile { profileType: 'OrchAdminProfile' }) WITH p ORDER BY p.profileId DESC WITH head(collect(p)) as p SET p.profileId = 100069; OPTIONAL MATCH (existing:Profile {profileType: 'OrchAdminProfile', profileId: 100070}) WHERE existing IS NULL MATCH (i:Identity { email: 'oleh.zhovnuvatyi.sme@sonymusic-pde.com' })-[:HAS_PROFILE]-(p:Profile { profileType: 'OrchAdminProfile' }) WITH p ORDER BY p.profileId DESC WITH head(collect(p)) as p SET p.profileId = 100070;