Daily User Activity Reports in Solidworks PDM

I need an SQL reporting system created in Solidworks PDM. The system should generate daily reports that include user activity logs, file revision history, and project status summaries.

Ideal skills and experience for the job include:
- Proficiency in SQL
- Extensive experience with Solidworks PDM
- Familiarity with data analysis and report generation
- Ability to understand and track project status

The primary goal is to automate the report generation for comprehensive insights into our PDM system. This will facilitate regular updates for stakeholders and ensure we're in tune with user activity and file changes.

Below is how I see such reports could be done (just for reference in order to manage expectations), however, I'm open to other proposals for the report structure.
Example Report:

Designer Name: Dmytro
Period: 01.08.2024 - 31.08.2024
Created 3D Models: 14
Edited 3D Models: 10
Created Drawings: 5
Edited Drawings: 1

Tables to Include in the Report:

Created 3D Models:

Part Name | Date | Time Spent | Link to Part | Start of Editing | End of Editing
Edited 3D Models:

Part Name | Date | Time Spent | Link to Part | Start of Editing | End of Editing
Created Drawings:

Part Name | Date | Time Spent | Link to Part | Start of Editing | End of Editing
Edited Drawings:

Part Name | Date | Time Spent | Link to Part | Start of Editing | End of Editing

PS. Here is some description of the reporting system in solidworks:
https://www.youtube.com/watch?v=fzLbOAVPFuA

https://www.goengineer.com/blog/solidworks-pdm-report-generator-instructions

https://help.solidworks.com/2018/english/enterprisepdm/admin/c_epdm_reports.htm