We needed to quickly know how often various databases were being opened on a client’s server.
If you have Access logging enabled and are using a Mac OS based system, this shell snippet will give you a nice summary of how often each database has been opened:
awk -F" '{ if($3 == " opening database ") print $4;}' '/Library/FileMaker Server/Logs/Access.log' | sort | uniq -c
Unfortunately, it won’t show you a count for databases that were never opened within the scope of the current access log.
Simon.