Tools → User Connections

StepsTasksActionComments
1

Get connected to Tools

https://dynasys-test.syensqo.com/RDWeb/Pages/en-US/Default.aspx/Tools


2Open #User connections
3Input the year and month , then Refresh
4Get the list on your request, Tab #LastConnections


Example Data：
SourceUsersDescriptionEmailLast connectionLast web connection
Dscp DP3AANJOS1NOVECARE - SREP - BR / DOS ANJOS NETO Adriano Antonioadriano.anjos@syensqo.com2019-03-11 18:11:352023-07-20 12:37:55
Dscp DP3ADENGNOVECARE - SREP - CN / DENG Weiqing (Aleen)aleen.deng@syensqo.com2019-03-08 10:38:052023-03-06 2:27:48

Dscp DP3

AFUKUSHINOVECARE - SREP - JP / FUKUSHIMA Akikoakiko.FUKUSHIMA@syensqo.com2019-02-17 6:07:402023-03-31 7:01:23
Dscp DP3AGRAETNOVECARE - SREP US / GRAET Alexandrealexandre.graet@syensqo.com2019-03-11 15:44:192023-07-18 13:58:28
Dscp DP1ACEVEDODTS - SREP / ACEVEDO Daviddavid.acevedo@syensqo.com2020-11-23 3:30:552023-04-26 15:06:15
Dscp DP1AGUPTA1PA - SREP / GUPTA Atulatul.gupta@syensqo.com2023-07-24 8:24:472022-08-04 9:05:56
Dscp DP1AILTASPA - SREP / ILTAS Ayferayfer.iltas@syensqo.com2021-09-21 11:59:402023-07-24 7:30:01

Dscp DP1

AMARTIN3PA - DP / MARTIN Antoineantoine.martin3@syensqo.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 DiP1

AMARTIN3AP-Antoine MARTIN - S&OP Planner
2023-07-18 15:03:462023-02-08 9:21:27
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 DP2ABBOTTSAERO - Sales Coordinator - Steven Abbottsteven.abbott@syensqo.com2023-07-25 18:13:152023-02-03 16:00:39
Dscp DP2ALIUAERO - Sales Team - CN / LIU Aloisalois.liu@syensqo.com2019-01-20 6:10:28

Dscp DP2

BAAN3703AERO - Sales Team - US / BAAN Tanyatanya.baan@syensqo.com2019-01-13 6:16:362023-07-18 18:59:08
Dscp DP2BachinskiTAERO - Sales Team - US / BACHINSKI Jamiejamie.bachinski@syensqo.com2019-01-20 6:10:282023-06-27 14:21:27

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@syensqo.com2020-11-23 3:30:552023-06-15 3:47:296/15/2023KEEP

2023-07-26 1:08:13

DSCP WEBCONNECTTORRESHTS - SREP / TORRES Hectorhector.torres@syensqo.com2020-11-23 3:30:552023-07-25 15:48:237/25/2023KEEP
2023-07-26 0:40:39DSCP WEBCONNECTJENSENJTS - SREP / JENSEN Justinjustin.jensen@syensqo.com2019-06-05 3:51:572023-07-24 20:32:117/24/2023KEEP

Sample data in DP2

DateConnection_TypeActionUserDescriptionEmailLast connectionLast web connectionRecent connectionNot connect since Apr 1st,2023
To Deactivate ?（3 months）

2023-07-26 4:09:36

DSCP WEBCONNECTJSKUAERO - Sales Team - KR / KU Ji-suji-su.ku@syensqo.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@syensqo.com2019-01-23 11:25:092023-07-21 15:40:427/21/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@syensqo.com2023-07-25 17:07:132023-07-18 7:28:557/25/2023KEEP

2023-07-26 5:16:05

DSCPCONNECTCYU2NOVECARE - SOP Manager - CN / YU Ceciliacecilia.yu@syensqo.com2023-07-25 18:05:57
7/25/2023KEEP
2023-07-26 4:55:16DSCP WEBCONNECTRLINOVECARE - SREP - SG / LI Jingqiurachel.li2@syensqo.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@syensqo.com2019-02-08 22:39:132023-07-14 0:19:147/14/2023KEEP



  • No labels