Number of users by role
SQL query for IonBiz
Count the number of users grouped by role.
SELECT Roles.name, COUNT(*) FROM Users INNER JOIN Roles ON Users.role_id = Roles.id GROUP BY Roles.name
IonBiz data model
Attachments
Custom Fields
Custom Fields Values
Custom Fields Value Ranges
Custom Field Templates
Contracts
Day Schedules
Departments
Items
Item Tags
Notes
Note Groups
Note Tags
Note Reacts
Note Resources
Projects
Project Costs
Project Invoice Statuses
Project Invoice Groups
Project Status
Project Types
Resources
Resource Costs
Resource Functions
Resource Category
Resource Types
Resource Work Schedules
Roles
Tasks
Task Status
Tickets
Ticket Areas
Ticket Categories
Ticket Groups
Ticket Priorities
Ticket Resources
Ticket Severities
Ticket Statuses
Ticket Softwares
Ticket Types
Time Sheets
Users
Work Schedules
Work Schedule Days
Payments
Project Invoice Payments
Relations
Quotes
Countries
Relation Types
Project Groups
Status Quotes
Relation Addresses
Vat Percentages
Ledger Accounts
Purchase Invoices
Purchase Invoice Lines
Project Invoices
Project Invoice Lines
Currencies
Purchase Quotes
Cost Sheets
Plannings
Planning Days
Planning Histories
Project Activities
Project Activity Translations
Project Activity Types
Project Costs Histories
Project Invoice Fees
Project Invoice Schedule Lines
Project Invoice Schedules
Project Invoice Schedule Tasks
Projects Histories
Quote Lines
Quote Lines Histories
Quotes Histories
Statuses
Tasks Histories
Contract Lines
Task Resources
Task Resource Hourlyrates
Vw Project Invoice Lines
Functions
Leaves
Leave Days
Leave Status
Project Invoice Fee Amounts
Issue Areas
Rpt Projects Budget Detail
Sp Get Project Extension Fields
Relation Groups
Relation Leads
Cost Types
Contacts
Relation Contacts
Project Invoices Histories
Email Messages
Email Message Tags
Email Message Receivers
Issue Iterations
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