Hello, is here any way in ispconfig (on in Debian latest version) list created databases and users which are not in use? Without acces? I have ispconfig with a lot of websites and databases and users (about 100), but i dont know how can i list databases and users which are not in use long time. and can i remove them. Any idea please? Thank you.
There is no built-in statistics for that in ISPConfig. But if you use MariaDB, then you can try something like this: Code: SELECT USER, TOTAL_CONNECTIONS, LAST_SEEN FROM information_schema.USER_STATISTICS ORDER BY LAST_SEEN DESC; To get login statistics.
