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

Table Custom Fields

Table Custom Fields Values

Table Custom Fields Value Ranges

Table Custom Field Templates

Table Departments

Table Notes

Table Note Groups

Table Note Tags

Table Note Reacts

Table Note Resources

Table Projects

Table Project Costs

Table Project Invoice Statuses

Table Project Invoice Groups

Table Project Status

Table Project Types

Table Resources

Table Resource Costs

Table Resource Functions

Table Resource Category

Table Resource Types

Table Roles

Table Tasks

Table Task Status

Table Tickets

Table Ticket Areas

Table Ticket Categories

Table Ticket Groups

Table Ticket Priorities

Table Ticket Resources

Table Ticket Severities

Table Ticket Statuses

Table Ticket Softwares

Table Ticket Types

Table Time Sheets

Table Users

Table Work Schedules

Table Payments

Table Project Invoice Payments

Table Relations

Table Quotes

Table Countries

Table Relation Types

Table Project Groups

Table Status Quotes

Table Relation Addresses

Table Vat Percentages

Table Ledger Accounts

Table Purchase Invoices

Table Purchase Invoice Lines

Table Project Invoices

Table Project Invoice Lines

Table Currencies

Table Purchase Quotes

Table Cost Sheets

Table Plannings

Table Planning Days

Table Planning Histories

Table Project Activities

Table Project Activity Translations

Table Project Activity Types

Table Project Costs Histories

Table Project Invoice Fees

Table Project Invoice Schedule Lines

Table Project Invoice Schedules

Table Project Invoice Schedule Tasks

Table Projects Histories

Table Quote Lines

Table Quote Lines Histories

Table Quotes Histories

Table Statuses

Table Tasks Histories

Table Contract Lines

Table Task Resources

Table Task Resource Hourlyrates

Table Vw Project Invoice Lines

Table Functions

Table Leaves

Table Leave Days

Table Leave Status

Table Project Invoice Fee Amounts

Table Issue Areas

Table Rpt Projects Budget Detail

Table Sp Get Project Extension Fields

Table Relation Groups

Table Cost Types

Magical SQL for IonBiz with Peliqan.io

Explore data in a rich spreadsheet UI. Use Magical SQL to combine and transform data. SQL queries become new tables that can be shared with business users and used in any BI tool such as Microsoft Power BI, Tableau or Metabase.

Let AI do the work for you

Peliqan’s AI assistant helps you to write SQL queries to get to insights fast. Ask your question in plain English and immediately see the result in Peliqan’s rich spreadsheet viewer.

Number of users by role

SQL query for IonBiz

IonBiz data model

Magical SQL for IonBiz with Peliqan.io

Let AI do the work for you

Ready to get instant access to all your company data ?

Ready to get instant access to
all your company data ?