Is there a way for a superuser to find the last time a database had an active user connection? (While being logged into a different database in the same instance, of course).
The context here is looking for looking for automated integration testing databases that have been leaked due to bugs/crashes in the testing framework.
Yes, I can mine the server log files, but that is really scraping the bottom of the barrel.
Thanks
Jeff
