I sometimes need to be able to look up customer info for a domain, where the customer name isn't related to the domain name. I can of course do so using raw SQL, but the somewhat involved query is a little too complex for the other admin users who sometimes have to do lookups. In our case, browsing through the admin interface can take a long time, as we've got more than 300 customers and domains under ISPConfig.
This led me to write a simple lookup tool. If anyone here wants it, you're welcome to it - it's at http://www.iowatelecom.net/mahoneyf/customers
. I must apologize, I don't much like PHP so it's written in Python, but if you find a need for the tool you could probably translate it to PHP pretty easily. It's also a command-line tool for now. I will put together a web-based tool one of these days, but for now command-line access is required.