How to delete users not associated with tickets

rocklee44

Hi all,
I'm using osTicket Version v1.17.2, is there sql query to search and delete all users not associated with tickets ?
Like highlight red in picture

KevinTheJedi

rocklee44

No but you can write one, it’d be real simple. You can look at our ERDs to see how the tables relate:

https://docs.osticket.com/en/latest/Developer%20Documentation/Database%20ERDs.html

Cheers.