Number of clashsets created per project
SQL query for Trimble Connect
Count the number of clashsets created for each project.
SELECT p.project_name, COUNT(*) FROM projects p JOIN clashsets c ON p.project_id = c.project_id GROUP BY p.project_name
Trimble Connect data model
Primary Folders
Models
Projects
Activities
Clashsets
Groups
Releases
Shares
Tags
Todos
Views D
Viewgroups
Views
Users
Models Selected
Model Owners
Model Layers
Model Entities Selected
Model Hierarchies
Model History
Model Property Set Definitions
Model Entities
Custom Psets
Custom Pset Defs
Ready to get instant access to all your company data ?
Connect 300+ sources, serve any BI tool, and give every AI agent one governed endpoint to read, and write back where the app supports it.
- 14-day free trial
- No credit card needed