Open tickets by state
SQL query for Intercom V2
Get the count of open tickets for each ticket state.
SELECT ticket_states.name, COUNT(tickets.id) AS open_ticket_count FROM ticket_states LEFT JOIN tickets ON ticket_states.id = tickets.state_id WHERE tickets.state = ‘open’ GROUP BY ticket_states.name
Intercom V2 data model
Admins
Companies
Contacts
Conversations
Conversation Parts
Subscription Types
Tags
Teams
Ticket Types
Ticket States
Tickets
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