Total number of registrations per asset
SQL query for GeoDynamics
Count the total number of registrations per asset in the registrations table.
SELECT asset_id, COUNT(*) AS registration_count FROM registrations GROUP BY asset_id
GeoDynamics data model
Resource Types
View 2 columns
NameString
Resource_TypeNumber
Absencetypes
Access Locations
Access Schedules
Access Schedules Exceptions
Accessgroups
Asset Inspection Types
Asset Locations
Assets
Asset Identifications
Badges
Btw Numbers
Clockings
Costcenters
Costcenter Validators
Day Programs
Fleet Fuelsensors
Maintenance
Maintenance Types
Mobile Rfid Scanners
Mobileclocking Multijoblist
Mobileclocking Optionlist
Overtimeconfigs
Persons
Persons Limosa
Poigroup
Point Of Interests
Poitype
Post Calculation Events
Project Leads
Registrations
Resourcegroups
Resources
Rfidtags
Smartphones
Timeclocks
Users
Vehicles
Vehicle Maintenance Tasks
Workplaces
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