Deactivate users with invalid emails

[dougwaldron]

Email sent to current users included many bounced addresses. All of those accounts should be deactivated.

Imported from JIRA: [CTS-289] Deactivate users with invalid emails (original by Douglas Waldron)

[dougwaldron]

Invalid address: bill.hawthorne@dnr.ga.us

by 557058:64b0cf35-1c06-4e6d-aac4-6d8e6a3aca41

[dougwaldron]

Unknown addresses:

john.wilson@dnr.state.ga.us
maggie.williams@dnr.state.ga.us
Mike.Kemp@dnr.state.ga.us
marcus.mincey@dnr.state.ga.us
jamie.parks@dnr.state.ga.us
john_costello@dnr.state.ga.us
ningke_yi@dnr.state.ga.us
portia.scott@dnr.state.ga.us
sandy.knight@dnr.ga.gov
jim.raymond@dnr.state.ga.us
mark_cocker@dnr.state.ga.us
roy.edwards@dnr.state.ga.us
ron.ross@dnr.state.ga.us
mike.almasi@dnr.state.ga.us
gema.communicationofficer@dnr.state.ga.us
james.westbrook@dnr.state.ga.us
john.keglor@dnr.state.ga.us
Sonja.Grey@dnr.state.ga.us
lurrene.beard@dnr.state.ga.us
mryna.finch@dnr.state.ga.us
neshanta.johnson@dnr.state.ga.us
kyle.stephens@dnr.ga.gov
john.shepherd@dnr.state.ga.us
wallace.reid@dnr.state.ga.us
john_shepherd@dnr.state.ga.us
ken.treadwell@dnr.state.ga.us
terry.johnson@dnr.state.ga.us
tamra.fischer@dnr.state.ga.us
jennifer.collier@dnr.state.ga.us
talina.laird@dnr.state.ga.us
luis.medina@dnr.state.ga.us
lee.tate@dnr.state.ga.us

by 557058:64b0cf35-1c06-4e6d-aac4-6d8e6a3aca41

[dougwaldron]

No longer employed:

joshua.reed@dnr.ga.gov
Glen.Behrend@dnr.ga.gov

by 557058:64b0cf35-1c06-4e6d-aac4-6d8e6a3aca41

[dougwaldron]

Delivery failed:

shakerah.hall@gema.ga.gov
kellen.mckinney@gema.ga.gov
desi.alexander@gema.ga.gov
phillip.lewis@gema.ga.gov
hal.waters@gema.ga.gov
sylvia.bloodworth@gema.ga.gov
april.stewart@gema.ga.gov
Michalin.Shepherd@gema.ga.gov
Linda.Williams@gema.ga.gov

by 557058:64b0cf35-1c06-4e6d-aac4-6d8e6a3aca41

[dougwaldron]

Unknown address:

Victoria.Bujeker@dnr.ga.gov
David.Yardumian@dnr.state.ga.us
Keith_St_Cyr@dnr.state.ga.us
Mike.Vergamini@dnr.state.ga.us

by 557058:64b0cf35-1c06-4e6d-aac4-6d8e6a3aca41

[dougwaldron]

Fixed invalid address and no longer employed

by 557058:64b0cf35-1c06-4e6d-aac4-6d8e6a3aca41

[dougwaldron]

Researched remaining and ran following:

SELECT
    Email,
    Active,
    EmailConfirmed
FROM AspNetUsers
WHERE Email IN
      (
  'april.stewart@gema.ga.gov',
  'David.Yardumian@dnr.state.ga.us',
  'desi.alexander@gema.ga.gov',
  'hal.waters@gema.ga.gov',
  'james.westbrook@dnr.state.ga.us',
  'jamie.parks@dnr.state.ga.us',
  'jennifer.collier@dnr.state.ga.us',
  'jim.raymond@dnr.state.ga.us',
  'john_costello@dnr.state.ga.us',
  'john_shepherd@dnr.state.ga.us',
  'john.keglor@dnr.state.ga.us',
  'john.shepherd@dnr.state.ga.us',
  'john.wilson@dnr.state.ga.us',
  'kellen.mckinney@gema.ga.gov',
  'kyle.stephens@dnr.ga.gov',
  'lee.tate@dnr.state.ga.us',
  'Linda.Williams@gema.ga.gov',
  'luis.medina@dnr.state.ga.us',
  'lurrene.beard@dnr.state.ga.us',
  'maggie.williams@dnr.state.ga.us',
  'marcus.mincey@dnr.state.ga.us',
  'mark_cocker@dnr.state.ga.us',
  'Michalin.Shepherd@gema.ga.gov',
  'mike.almasi@dnr.state.ga.us',
  'Mike.Kemp@dnr.state.ga.us',
  'Mike.Vergamini@dnr.state.ga.us',
  'mryna.finch@dnr.state.ga.us',
  'neshanta.johnson@dnr.state.ga.us',
  'ningke_yi@dnr.state.ga.us',
  'phillip.lewis@gema.ga.gov',
  'portia.scott@dnr.state.ga.us',
  'ron.ross@dnr.state.ga.us',
  'roy.edwards@dnr.state.ga.us',
  'shakerah.hall@gema.ga.gov',
  'Sonja.Grey@dnr.state.ga.us',
  'sylvia.bloodworth@gema.ga.gov',
  'talina.laird@dnr.state.ga.us',
  'tamra.fischer@dnr.state.ga.us',
  'tamra.fischer@dnr.ga.gov',
  'terry.johnson@dnr.state.ga.us'
      )
ORDER BY Email;

SELECT
    count(*),
    Active
FROM AspNetUsers
GROUP BY Active;

UPDATE
    AspNetUsers
SET Active = 0
WHERE Email IN
      (
  'april.stewart@gema.ga.gov',
  'David.Yardumian@dnr.state.ga.us',
  'desi.alexander@gema.ga.gov',
  'hal.waters@gema.ga.gov',
  'james.westbrook@dnr.state.ga.us',
  'jamie.parks@dnr.state.ga.us',
  'jennifer.collier@dnr.state.ga.us',
  'jim.raymond@dnr.state.ga.us',
  'john_costello@dnr.state.ga.us',
  'john_shepherd@dnr.state.ga.us',
  'john.keglor@dnr.state.ga.us',
  'john.shepherd@dnr.state.ga.us',
  'john.wilson@dnr.state.ga.us',
  'kellen.mckinney@gema.ga.gov',
  'kyle.stephens@dnr.ga.gov',
  'lee.tate@dnr.state.ga.us',
  'Linda.Williams@gema.ga.gov',
  'luis.medina@dnr.state.ga.us',
  'lurrene.beard@dnr.state.ga.us',
  'maggie.williams@dnr.state.ga.us',
  'marcus.mincey@dnr.state.ga.us',
  'mark_cocker@dnr.state.ga.us',
  'Michalin.Shepherd@gema.ga.gov',
  'mike.almasi@dnr.state.ga.us',
  'Mike.Kemp@dnr.state.ga.us',
  'Mike.Vergamini@dnr.state.ga.us',
  'mryna.finch@dnr.state.ga.us',
  'neshanta.johnson@dnr.state.ga.us',
  'ningke_yi@dnr.state.ga.us',
  'phillip.lewis@gema.ga.gov',
  'portia.scott@dnr.state.ga.us',
  'ron.ross@dnr.state.ga.us',
  'roy.edwards@dnr.state.ga.us',
  'shakerah.hall@gema.ga.gov',
  'Sonja.Grey@dnr.state.ga.us',
  'sylvia.bloodworth@gema.ga.gov',
  'talina.laird@dnr.state.ga.us',
  'tamra.fischer@dnr.state.ga.us',
  'tamra.fischer@dnr.ga.gov',
  'terry.johnson@dnr.state.ga.us'
      );

by 557058:64b0cf35-1c06-4e6d-aac4-6d8e6a3aca41