You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 5 Next »

Example Data：

Data source：folder: /Tools → User connections

Tab: LastConnections

SourceUsersDescriptionEmailLast connectionLast web connection
Dscp DP5ACOGNETCH - KU / VANESSE Anneanne.vanesse@solvay.com2023-07-19 12:35:342023-07-25 9:48:05
Dscp DP5ADASCH - SE / DAS Ashishashish.das@solvay.com2019-04-02 0:46:572023-07-20 13:04:58
Dscp DP5ANAKATSUCH - SA / NAKATSUKASA Atsukoatsuko.nakatsukasa@solvay.com2019-04-02 0:46:572023-07-20 12:32:20
Dscp DP5BainbridgeVSBS / BAINBRIDGE Valerie
2023-05-08 18:37:092023-07-13 14:55:28
Dscp 1aelianeSBS / Alexandre Elianealexandre.eliane@solvay.com2022-04-22 11:39:282022-08-03 12:27:20
Dscp 1aniang2SBS / Ahmadou NIANG
2022-06-30 22:55:03
Dscp 1ARAMIRE1SD - AM / Alejandro Ramirezalejandro.ramirez@solvay.com2019-05-02 3:35:30
Dscp 1baer7617SBS - Marie Baer (EU)
2023-02-06 14:26:32
Dscp DiP4AELIANESBS - Alexandre ELIANE (EU)
2022-03-28 14:47:272022-08-03 12:27:20
Dscp DiP4baer7617SBS - Marie Baer (EU)
2023-05-31 18:31:28
Dscp DiP4baer76172SBS - Viewer account - Marie BAER
2023-05-16 17:19:22
Dscp DiP4BE002733PEROX - Nicolas DEPLANQUE (EU) - S&OP Planner
2023-05-31 21:38:552023-07-18 16:00:09
Dscp DiP5ACOGNET

TS/CH - Anne VANESSE (EU) - GBU SCE - Viewer account


2023-07-25 11:48:422023-07-25 9:48:05
Dscp DiP5AELIANESBS - Alexandre ELIANE (EU) - viewer account
2022-07-26 9:20:352022-08-03 12:27:20
Dscp DiP5baer7617SBS - Marie Baer (EU)
2023-07-21 15:57:26
Dscp DiP5baer76172SBS - Viewer account - Marie BAER
2023-06-05 15:57:30
Dscp DP452021853SI - CSR / AIGHABRAH Qamarqamar.al-ghabrah1-ext@solvay.com2023-04-10 16:51:50
Dscp DP4ajaroszeSI - SREP / JAROSZEK Annaanna.jaroszek@solvay.com2019-10-03 7:22:132023-07-19 10:29:58
Dscp DP4ARAUJOESI - CSR / ARAUJO Eliane De Oliveiraeliane.araujo@solvay.com2019-06-05 3:51:572023-02-09 17:07:42
Dscp DP4BAER7617SBS / BAER Marie
2023-05-04 10:34:02

Example Data：

SourceUsersDescriptionEmailLast connectionLast web connection
Dscp DP3AANJOS1NOVECARE - SREP - BR / DOS ANJOS NETO Adriano Antonioadriano.anjos@solvay.com2019-03-11 18:11:352023-07-20 12:37:55
Dscp DP3ADENGNOVECARE - SREP - CN / DENG Weiqing (Aleen)aleen.deng@solvay.com2019-03-08 10:38:052023-03-06 2:27:48
Dscp DP3AFUKUSHINOVECARE - SREP - JP / FUKUSHIMA Akikoakiko.FUKUSHIMA@solvay.com2019-02-17 6:07:402023-03-31 7:01:23
Dscp DP3AGRAETNOVECARE - SREP US / GRAET Alexandrealexandre.graet@solvay.com2019-03-11 15:44:192023-07-18 13:58:28
Dscp DP1ACEVEDODTS - SREP / ACEVEDO Daviddavid.acevedo@solvay.com2020-11-23 3:30:552023-04-26 15:06:15
Dscp DP1AGUPTA1PA - SREP / GUPTA Atulatul.gupta@solvay.com2023-07-24 8:24:472022-08-04 9:05:56
Dscp DP1AILTASPA - SREP / ILTAS Ayferayfer.iltas@solvay.com2021-09-21 11:59:402023-07-24 7:30:01
Dscp DP1AMARTIN3PA - DP / MARTIN Antoineantoine.martin3@solvay.com2023-07-18 10:46:292023-02-08 9:21:27
Dscp DiP1ACOGNETTS/CH - Anne VANESSE (EU) - GBU SCE - Viewer account
2023-01-30 11:01:552023-01-19 10:24:30
Dscp DiP1ADAMSKTS - Kate ADAMS (GB) - DRP
2023-07-25 19:42:342023-05-10 13:58:05
Dscp DiP1AELIANESBS - Alexandre ELIANE (EU) - viewer account
2022-07-26 9:20:352022-08-03 12:27:20
Dscp DiP1AMARTIN3AP-Antoine MARTIN - S&OP Planner
2023-07-18 15:03:462023-02-08 9:21:27
Dscp DiP3AELIANESBS - Alexandre ELIANE (EU) - Viewer
2022-03-08 22:43:522022-08-03 12:27:20
Dscp DiP3ALEN5288NOVECARE - George Alencherry (NA) - S&OP Manager
2023-07-06 1:47:16
Dscp DiP3AWILHELMNovecare - Aurelié Wilhelm (EU) - S&OP Manager
2023-07-24 11:46:232022-08-12 12:52:45
Dscp DiP3baer7617SBS - Marie Baer (EU)
2023-05-31 18:57:52
Dscp DP2ABBOTTSAERO - Sales Coordinator - Steven Abbottsteven.abbott@solvay.com2023-07-25 18:13:152023-02-03 16:00:39
Dscp DP2ALIUAERO - Sales Team - CN / LIU Aloisalois.liu@solvay.com2019-01-20 6:10:28
Dscp DP2BAAN3703AERO - Sales Team - US / BAAN Tanyatanya.baan@solvay.com2019-01-13 6:16:362023-07-18 18:59:08
Dscp DP2BachinskiTAERO - Sales Team - US / BACHINSKI Jamiejamie.bachinski@solvay.com2019-01-20 6:10:282023-06-27 14:21:27
Dscp 2ACHENSP - Sales Manager / CHEN Arthurarthur.chen@solvay.com2019-04-02 0:46:57
Dscp 2aelianeSBS access for Alexandre Elianealexandre.eliane@solvay.com2021-12-03 11:55:262022-08-03 12:27:20
Dscp 2AKAISERSP - Sales Manager / KAISER Adrienadrien.kaiser@solvay.com2019-03-08 10:38:05
Dscp 2ALI5SP - Regional Sales Manager / LI Amberamber.li@solvay.com2021-03-08 13:06:412022-06-23 7:44:08

Vlookup the Last connection & Last web connection to each user by application

Recent connection：=arrayformula(if(G2:$G>H2:$H,G2:$G,H2:$H))

Not connect since Apr 1st,2023 To Deactivate ?（3 months）：=if(I2="No Connection","To Deactivate",if( I2< DATEVALUE("2023/4/1"),"To Deactivate","KEEP"))

DateConnection_TypeActionUserDescriptionEmailLast connectionLast web connectionRecent connectionNot connect since Apr 1st,2023
To Deactivate ?（3 months）
2023-07-26 3:10:03DSCP WEBCONNECTSANIASTS - SREP / SANIA Sampsonsam.sania@solvay.com2020-11-23 3:30:552023-06-15 3:47:296/15/2023KEEP
2023-07-26 1:08:13DSCP WEBCONNECTTORRESHTS - SREP / TORRES Hectorhector.torres@solvay.com2020-11-23 3:30:552023-07-25 15:48:237/25/2023KEEP
2023-07-26 0:40:39DSCP WEBCONNECTJENSENJTS - SREP / JENSEN Justinjustin.jensen@solvay.com2019-06-05 3:51:572023-07-24 20:32:117/24/2023KEEP
2023-07-26 0:26:13DSCPCONNECTdynasys_techSBS - TECH / Admin BD
2023-07-26 0:01:58
7/26/2023KEEP

Sample data in DP2

DateConnection_TypeActionUserDescriptionEmailLast connectionLast web connectionRecent connectionNot connect since Apr 1st,2023
To Deactivate ?（3 months）
2023-07-26 4:12:18DSCPCONNECTdynasys_tech

SBS / Database Administrator


2023-07-26 4:03:44
7/26/2023KEEP
2023-07-26 4:09:36DSCP WEBCONNECTJSKUAERO - Sales Team - KR / KU Ji-suji-su.ku@solvay.com2019-01-20 6:10:282023-07-25 5:31:267/25/2023KEEP
2023-07-26 4:06:07DSCP WEBCONNECTCHENWIAERO - Regional Sales Manager - CN / CHEN Williamwilliam.chen@solvay.com2019-01-23 11:25:092023-07-21 15:40:427/21/2023KEEP
2023-07-26 4:00:04DSCPCONNECTdynasys_tech

SBS / Database Administrator


2023-07-26 4:03:44
7/26/2023KEEP

Sample Data in DP3

DateConnection_TypeActionUserDescriptionEmailLast connectionLast web connectionRecent connectionNot connect since Apr 1st,2023
To Deactivate ?（3 months）
2023-07-26 5:19:09DSCPCONNECTSSATHENOVECARE - SOP Manager - IN / SATHE Swapnilswapnil.sathe@solvay.com2023-07-25 17:07:132023-07-18 7:28:557/25/2023KEEP
2023-07-26 5:16:05DSCPCONNECTCYU2NOVECARE - SOP Manager - CN / YU Ceciliacecilia.yu@solvay.com2023-07-25 18:05:57
7/25/2023KEEP
2023-07-26 4:55:16DSCP WEBCONNECTRLINOVECARE - SREP - SG / LI Jingqiurachel.li2@solvay.com2019-03-10 6:12:392023-07-23 14:37:167/23/2023KEEP
2023-07-26 4:47:11DSCP WEBCONNECTJHUANG2NOVECARE - SREP - CN / HUANG Libiao(Jacky)jacky.huang@solvay.com2019-02-08 22:39:132023-07-14 0:19:147/14/2023KEEP

Sample Data in DP4

DateConnection_TypeActionUserDescriptionEmailLast connectionLast web connectionRecent connectionNot connect since Apr 1st,2023
To Deactivate ?（3 months）
2023-07-25 20:34:46DSCP WEBCONNECTUS10545PE - AM / HANCOCK Stevensteven.hancock@solvay.com2019-04-01 11:00:002023-07-25 18:38:317/25/2023KEEP
2023-07-25 20:02:28DSCP WEBCONNECTUS10545PE - AM / HANCOCK Stevensteven.hancock@solvay.com2019-04-01 11:00:002023-07-25 18:38:317/25/2023KEEP
2023-07-25 15:58:40DSCPCONNECTX8052905SI - DP / Sabine Desirontsabine.desiront@solvay.com2023-07-25 16:07:55
7/25/2023KEEP
2023-07-25 15:58:10DSCP WEBCONNECTKUZN0553SI - CSR / KUZNETSOVA AlinaAlina.Kuznetsova-ext@solvay.com2022-03-17 11:03:312023-07-25 13:58:127/25/2023KEEP

Sample Data in DP5

DateConnection_TypeActionUserDescriptionEmailLast connectionLast web connectionRecent connectionNot connect since Apr 1st,2023
To Deactivate ?（3 months）
2023-07-26 6:00:21DSCPCONNECTdynasys_techAdministrateur de la base de données
2023-07-26 0:01:42
7/26/2023KEEP
2023-07-26 4:39:01DSCP WEBCONNECTJP00231CH - SE / SEIDA Junkojunko.seida@solvay.com2019-03-10 6:12:392023-07-26 2:39:037/26/2023KEEP
2023-07-26 0:24:52DSCP WEBCONNECTGARC9618CH - SE / GARCIA Jose Santosjose.garcia@solvay.com2019-04-02 0:46:572023-07-26 1:07:017/26/2023KEEP
2023-07-26 0:20:06DSCPCONNECTdynasys_techAdministrateur de la base de données
2023-07-26 0:01:42
7/26/2023KEEP
  • No labels