Top Accounts by Ticket Volume
SQL query for Freshdesk
Get the top accounts by the number of tickets raised.
SELECT account_id, COUNT(*) FROM tickets GROUP BY account_id ORDER BY COUNT(*) DESC LIMIT 10
Freshdesk data model
Accounts
Agents
Contacts
Companies
Email Configs
Email Mailboxes
Groups
Products
Roles
Surveys
Tickets
Tickets Conversations
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