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"