Script for campus/group reporting

[mariagould]

EZID campus admins are interested in understanding and having more information about usage - who has an EZID account, what identifiers are they registering, etc. In the future, this information should be made available to campus admins via some sort of dashboard they can access in EZID. In the shorter term, we can develop a script that pulls this information for admins on a regular basis.

To do:

• [ ] Develop a script that can generate the information below
• [ ] Develop a script to pull this information on a regular and recurring basis (monthly)
• [ ] Set up reports to be emailed to EZID service manager (one email per campus)

Reporting details: This information will be collected for the following EZID groups only (not all EZID groups at this time): cdl, sb-library, ucblibrary, ucd-library, ucla-library, ucsdlib, ucsc-lib, ucsf, uci, ucrlibrary, ucmlibrary

Information to be collected:

1. Campus overview report

• List of all shoulders per group
• List of all users per group

2. User report by campus

• User name
• User display name
• Account email
• Primary contact name
• Primary contact email
• Primary contact phone
• Secondary contact name
• Secondary contact email
• Secondary contact phone
• List of all shoulders associated with the user (shoulder plus shoulder name)
• Number of identifiers associated with the user
• User account creation date

3. Shoulder report by campus

• List of shoulders
• Registration agency for each shoulder (Crossref, DataCite, None)
• Creation date for each shoulder
• Users linked to the shoulder
• Number of identifiers associated with each shoulder

[jsjiang]

@mariagould Draft reports are saved here https://drive.google.com/drive/folders/1xPNJuC7vYo_197G-4scECcTbGaXz6n1-?usp=sharing Reports include: users_per_group shoulders_per_group user_report_cdl user_report_ucblibrary shoulder_preport_cdl Shoulder_reprt_ucblibrary

Each report has two file formats: .tsv and Google Sheet.

Please take a look and let me know if you have problem accessing the reports. Also these are draft reports and may need adjustments.

Thank you

Jing