...
Cleanup: If tools are created or converted to manage non-personal mail accounts, then we should consider establishing some proper rules and converting existing entries to match these rules. In particular, the practice of creating an Email Alias and a Dependent Netid and assigning ownership of the Alias to the person who owns the dependent Netid causes serious problems. People leave the university without transferring both the alias and the Dependent Netid to someone else. Then when their personal mail gets deprovisioned, the Secondary Alias for the group account remains attached to the inactive AD User object. The correct thing to do is the assign ownership of the Alias to the Dependent Netid that represents the shared mail account. The account can then stand alone, and if the owner fails to transfer the Dependent Netid to someone else, well the Dependent Netid is still active even if the former owner is inactive. This fix is not technically part of the Mail Relay project, but if we are fixing all the tools for this type of account we should fix this at the same time.
People with an Eliapps Primary Alias and
...
O365
...
Secondary Alias
| Code Block |
|---|
ALIAS_NAME TYPE MAILBOX NETID ---------- ---- ------- ----- morrow.long person morrow.long@bulldogs.yale.edu long jason.ignatius person jason.ignatius@bulldogs.yale.edu jsi3 kcm.campbell person kcm.campbell@bulldogs.yale.edu cjc243 stuart.teal person stuart.teal@bulldogs.yale.edu sbt3 yanick-noelle.aigbedion person yanick-noelle.aigbedion@bulldogs.yale.edu yoa4 samira.ataei person samira.ataei@bulldogs.yale.edu fa292 jeff.mandell person jeff.mandell@bulldogs.yale.edu jm3353 sam.seiff person sam.seiff@bulldogs.yale.edu sbs79 bernardo.eilerttrevisan person bernardo.eilerttrevisan@bulldogs.yale.edu be244 elena.adasheva-klein person elena.adasheva-klein@bulldogs.yale.edu ea479 georgios.vasilopoulos person georgios.vasilopoulos@bulldogs.yale.edu vg284 |
People with Eliapps Primary Alias, No O365 Secondary Alias, but are “UserMailbox” Recipents (have a mailbox) in Exchange
| Code Block |
|---|
ALIAS_NAME TYPE MAILBOX NETID
---------- ---- ------- -----
travis.zadeh person travis.zadeh@bulldogs.yale.edu tz237
thomas.langford person thomas.langford@bulldogs.yale.edu tl397
ben.kiernan person ben.kiernan@bulldogs.yale.edu magpie
carol.hwang person carol.hwang@bulldogs.yale.edu chwang
cynthia.farrar person cynthia.farrar@bulldogs.yale.edu cfarrar
albert.laguna person albert.laguna@bulldogs.yale.edu al757
wayne.zhang person wayne.zhang@bulldogs.yale.edu wwz3
mark.gerstein person mark.gerstein@bulldogs.yale.edu mg269
richard.lalli person richard.lalli@bulldogs.yale.edu rl3
ivan.szelenyi person ivan.szelenyi@bulldogs.yale.edu is66
kusal.samarasinghe person kusal.samarasinghe@bulldogs.yale.edu kts34
victoria.misenti person victoria.misenti@bulldogs.yale.edu vlg8
william.hawkins person william.hawkins@bulldogs.yale.edu wbh24
richard.walser person richard.walser@bulldogs.yale.edu rwalser
keith.corbino person keith.corbino@bulldogs.yale.edu kac64
jesus.yanez person jesus.yanez@bulldogs.yale.edu jy384
yong.xiong person yong.xiong@bulldogs.yale.edu yx44
wasim.sayyad person wasim.sayyad@bulldogs.yale.edu was35
rohan.gurram person rohan.gurram@bulldogs.yale.edu rkg33
nirag.kadakia person nirag.kadakia@bulldogs.yale.edu nk479
aman.khanuja person aman.khanuja@bulldogs.yale.edu ak2385
nicholas.ryan person nicholas.ryan@bulldogs.yale.edu njr33
j.zhang person j.zhang@bulldogs.yale.edu jz435
claudia.villano person claudia.villano@bulldogs.yale.edu cav7
kyle.vanderwerf person kyle.vanderwerf@bulldogs.yale.edu krv8
paul.wolfram person paul.wolfram@bulldogs.yale.edu pw379
kas.tebbetts person kas.tebbetts@bulldogs.yale.edu kt522
soumya.james person soumya.james@bulldogs.yale.edu sj484
megan.eckerle person megan.eckerle@bulldogs.yale.edu mme28
ronald.tricoche person ronald.tricoche@bulldogs.yale.edu rt347
craig.luekens person craig.luekens@bulldogs.yale.edu cal65
andrea.darif person andrea.darif@bulldogs.yale.edu ad566
saul.jaime-figueroa person saul.jaime-figueroa@bulldogs.yale.edu sj396
omer.mano person omer.mano@bulldogs.yale.edu om55
xinglin.lu person xinglin.lu@bulldogs.yale.edu xl294
mahmut.demir person mahmut.demir@bulldogs.yale.edu md762
andrew.currie person andrew.currie@bulldogs.yale.edu ajc82
libby.didomizio person libby.didomizio@bulldogs.yale.edu eed37
nathan.chang person nathan.chang@bulldogs.yale.edu nac53
ting.zhou person ting.zhou@bulldogs.yale.edu tz232
debra.houle person debra.houle@bulldogs.yale.edu dh462
daifeng.wang person daifeng.wang@bulldogs.yale.edu dw396
yotam.hadar person yotam.hadar@bulldogs.yale.edu ymh4
paul.berkowitz person paul.berkowitz@bulldogs.yale.edu phb8
fatih.celikbas person fatih.celikbas@bulldogs.yale.edu fc359
luyao.jiang person luyao.jiang@bulldogs.yale.edu lj275
michelle.yuen person michelle.yuen@bulldogs.yale.edu mcy6
jonathan.warrell person jonathan.warrell@bulldogs.yale.edu jw2394
timur.galeev person timur.galeev@bulldogs.yale.edu tg397
sara.smith person sara.smith@bulldogs.yale.edu sks25
melissa.lu person melissa.lu@bulldogs.yale.edu ml2453
jaeeun.song person jaeeun.song@bulldogs.yale.edu js2894
vishal.patel person vishal.patel@bulldogs.yale.edu vp276
wenjun.hu person wenjun.hu@bulldogs.yale.edu wh288
j.zhuang person j.zhuang@bulldogs.yale.edu jz472
tianliuyun.gao person tianliuyun.gao@bulldogs.yale.edu tg344
nat.irwin person nat.irwin@bulldogs.yale.edu nsi4
declan.clarke person declan.clarke@bulldogs.yale.edu dc547
arthur.lau person arthur.lau@bulldogs.yale.edu ajl74
kevin.lopez person kevin.lopez@bulldogs.yale.edu kl533
raymond.simpson person raymond.simpson@bulldogs.yale.edu rgs45
roger.desravines person roger.desravines@bulldogs.yale.edu rd557
rachel.renne person rachel.renne@bulldogs.yale.edu rr687
claudia.valeggia person claudia.valeggia@bulldogs.yale.edu crv7
eduardo.fernandez-duque person eduardo.fernandez-duque@bulldogs.yale.edu ef344
farren.isaacs person farren.isaacs@bulldogs.yale.edu fji2
sahand.negahban person sahand.negahban@bulldogs.yale.edu snn7
karihenkelmann.keyl person karihenkelmann.keyl@bulldogs.yale.edu kk544
john.henderson person john.henderson@bulldogs.yale.edu jh925
antonio.fonseca person antonio.fonseca@bulldogs.yale.edu ahf38
xing.wu person xing.wu@bulldogs.yale.edu xw358
tianxiao.li person tianxiao.li@bulldogs.yale.edu tl444
clinton.wang person clinton.wang@bulldogs.yale.edu cjw46
hatice.erten person hatice.erten@bulldogs.yale.edu hne2
lewis.golove person lewis.golove@bulldogs.yale.edu lg432
laurel.german person laurel.german@bulldogs.yale.edu lag48
mela.toro person mela.toro@bulldogs.yale.edu at549
andres.munozrojas person andres.munozrojas@bulldogs.yale.edu arm92
alberto.urcia person alberto.urcia@bulldogs.yale.edu au45
clare.staib-kaufman person clare.staib-kaufman@bulldogs.yale.edu cs2528
damon.clark person damon.clark@bulldogs.yale.edu dac77
jennifer.wu person jennifer.wu@bulldogs.yale.edu jw2282
jennifer.raab person jennifer.raab@bulldogs.yale.edu jcr42
marcus.alexander person marcus.alexander@bulldogs.yale.edu mam96
noah.planavsky person noah.planavsky@bulldogs.yale.edu np363
dhanusha.nalawansha person dhanusha.nalawansha@bulldogs.yale.edu dan44
leonidas.salichos person leonidas.salichos@bulldogs.yale.edu ls926
isaac.nakhimovsky person isaac.nakhimovsky@bulldogs.yale.edu isn2
chitra.ramalingam person chitra.ramalingam@bulldogs.yale.edu cr537
robyn.creswell person robyn.creswell@bulldogs.yale.edu rc698
basile.njei person basile.njei@bulldogs.yale.edu bn72
jacqueline.kisa person jacqueline.kisa@bulldogs.yale.edu jkk35
benjamin.schwartz person benjamin.schwartz@bulldogs.yale.edu bs843
shaoke.lou person shaoke.lou@bulldogs.yale.edu sl2373
steven.chou person steven.chou@bulldogs.yale.edu sc2493
sarah.luckart person sarah.luckart@bulldogs.yale.edu srl54
jacob.e.miller person jacob.e.miller@bulldogs.yale.edu jem263
joseph.goode person joseph.goode@bulldogs.yale.edu jbg66
ran.gu person ran.gu@bulldogs.yale.edu rg684
marilyn.mossien person marilyn.mossien@bulldogs.yale.edu mrm95
nikhil.malvankar person nikhil.malvankar@bulldogs.yale.edu nm563
terence.renaud person terence.renaud@bulldogs.yale.edu tr369
test2.infoed.ti7 person test2.infoed.ti7@bulldogs.yale.edu ti7
david.breslow person david.breslow@bulldogs.yale.edu dkb27
yannick.jacob person yannick.jacob@bulldogs.yale.edu yj242
susan.choi person susan.choi@bulldogs.yale.edu sc385
alyssa.dechiaro person alyssa.dechiaro@bulldogs.yale.edu ad949
imad.rizvi person ir99@bulldogs.yale.edu ir99
yat.wong person yat.wong@bulldogs.yale.edu yw629
xinyi.zhang.xz476 person xinyi.zhang.xz476@bulldogs.yale.edu xz476
rachael.roettenbacher person rachael.roettenbacher@bulldogs.yale.edu rmr79
killian.mcloughlin person killian.mcloughlin@bulldogs.yale.edu km2345
jennifer.nulsen person jennifer.nulsen@bulldogs.yale.edu jn535
a.scott person a.scott@bulldogs.yale.edu aas228
chenziyi.mi person chenziyi.mi@bulldogs.yale.edu cm2523
sebastian.lordadumont person sebastian.lordadumont@bulldogs.yale.edu ssl57
haoran.cao person haoran.cao@bulldogs.yale.edu hc685
jack.berry person jack.berry@bulldogs.yale.edu jrb248
mark.lisi person mark.lisi@bulldogs.yale.edu ml2622
brian.koopman person brian.koopman@bulldogs.yale.edu bjk49
avi.cohen person avi.cohen@bulldogs.yale.edu ajc259
ishan.negi person ishan.negi@bulldogs.yale.edu in49
yinan.chen person yinan.chen@bulldogs.yale.edu yc778
pranavateja.surukuchi person pranavateja.surukuchi@bulldogs.yale.edu ps938
yue.hu person yue.hu@bulldogs.yale.edu yh567
gabe.petrov person gabe.petrov@bulldogs.yale.edu gpp8
haven.herrin person haven.herrin@bulldogs.yale.edu hmh47
yixuan.tan person yixuan.tan@bulldogs.yale.edu yt355
yakun.zhou person yakun.zhou@bulldogs.yale.edu yz883
jacques.saarbach person jacques.saarbach@bulldogs.yale.edu js3973
emma.mckinney person emma.mckinney@bulldogs.yale.edu em873
michael.rader person michael.rader@bulldogs.yale.edu mr2542
ashley.arthur person ashley.arthur@bulldogs.yale.edu ala72
andy.knauer person ajk83@bulldogs.yale.edu ajk83
xiangyu.zhang person xiangyu.zhang@bulldogs.yale.edu xz527
ben.crair person ben.crair@bulldogs.yale.edu bec32
nicolas.maffey person nicolas.maffey@bulldogs.yale.edu nam87
charalampos.papamanthou person charalampos.papamanthou@bulldogs.yale.edu cp936
xuqiang.qin person xuqiang.qin@bulldogs.yale.edu xq43
sunny.yang person sunny.yang@bulldogs.yale.edu gy88
alison.sweeney person alison.sweeney@bulldogs.yale.edu as3822
chungsuk.choi person chungsuk.choi@bulldogs.yale.edu cc2858
makenna.hamilton person makenna.hamilton@bulldogs.yale.edu mh2539
chaofan.xu person chaofan.xu@bulldogs.yale.edu cx78
david.goerger person david.goerger@bulldogs.yale.edu deg38
ruifeng.sun person ruifeng.sun@bulldogs.yale.edu rs2623
juan.gambetta person juan.gambetta@bulldogs.yale.edu jpg68
caroline.chen person caroline.chen@bulldogs.yale.edu cc2766
junqi.wang person junqi.wang@bulldogs.yale.edu jw2675
fl428 person fl428@bulldogs.yale.edu fl428
ar2483 person ar2483@bulldogs.yale.edu ar2483 |
AD Daily Updater Bug Entries
There are around 1700 users who have only Eliapps Email aliases and who are regarded by Exchange Online as only MailUsers (that is, they are not UserMailbox entries and therefore have no Exchange mail account). The Legacy AD Daily Updater may have added incorrect smtp:netid@connect.yale.edu and smtp:first.last@connect.yale.edu proxyaddresses and values for msexchversion and three other msexch* fields. These should be removed, although they create no problems for the Mail Relay retirement project and are just incorrect data that should be cleaned up when the Legacy AD Daily Updater is retried.