SQL Report System Setup in Solidworks PDM (Win 2019)

Job ID: 38675860

Budget: $250 – $750 USD

I'm seeking a professional with extensive experience in Solidworks PDM and SQL Reporting, to set up a reporting system on my Windows Server 2019.

Key Requirements:
- Configuring the SQL Report System to generate usage reports within Solidworks PDM.
- Structuring these reports to include specific data fields: File access history, User login times, and File modification dates.

Ideal Skills and Experience:
- Proficiency in SQL and Solidworks PDM.
- Previous experience with setting up report systems.
- Understanding of Windows Server 2019 configurations.

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