SQL Report System Setup in Solidworks PDM (Win 2019)
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
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