Zoom Users

Twice a year we receive a list of Zoom accounts tied to SPH emails that will soon be deleted because the user hasn’t logged into the account in a long time.

We have a reusable script that generates a report about the account owners. The CSV file generated by the script contains the following columns:

Report Columns

ZOOM_EMAIL

Description: The email address associated with the Zoom account. Provided as input to the script.

Possible Values:

• An email address

HKEY_LOGIN

Description: The email address the person uses to login to HarvardKey.

Possible Values:

• An email address
• Empty – check the LOG column for details

ZOOM_EQ_HKEY

Description: Whether or not the ZOOM_EMAIL is the same as the HKEY_LOGIN

Possible Values:

• "TRUE"
• "FALSE"

HAS_ACTIVE_ROLE

Description: Whether or not the person has an active role at Harvard.

Possible Values:

• "TRUE"
• "FALSE"

ACTIVE_ROLE_LOCATION

Description: The location of this person's active role at Harvard, if they have one.

Possible values:

• “SPH” – this person has an active employee, student, or POI role at SPH
• “Harvard” – this person has an active employee, student, or POI role at Harvard, but not at SPH.
• "#N/A" – this person has no active student, employee, or POI role anywhere at Harvard.

IS_POI

Description: Whether or not the person has an active POI role.

Possible values:

• "TRUE"
• "FALSE"

PDS_MATCH

Description: Whether or not there was an exact match for the ZOOM_EMAIL in the HUIT Person Data Service.

Possible values:

• "TRUE"
• "FALSE"

Zoom Users to Worry About

The Zoom users we should worry about are those where ZOOM_EMAIL equals the HKEY_LOGIN and the person has an active role at SPH. This means a person who should legitimately have access to Zoom is about to lose their account. To find these people, filter the report as seen in the image below, using the below filter values:

ZOOM_EQ_HKEY = "TRUE"

HAS_ACTIVE_ROLE = "TRUE"

ACTIVE_ROLE_LOC = "SPH"