Summarizing FileMaker Server Access.log data

Various times I’ve needed to do some quick summaries of how a given server and its databases were being used. When using Mac OS X, I may use shell commands to get a quick summary of what’s happening on a particular server.

Here’s one that came up just recently. Client wanted to know what accounts had been used to access databases, but they were largely using generic account names.

 

 

What versions of FileMaker are users using? This will give us the versions used and how often they connected:

 

A more typical situation here where we want to summarize which accounts are accessing the databases:

Finally, a nice summary of the total times each file has been accessed (does not included files never accessed):

If you want tab delimited data, just drop the expand command that’s at end. The date range used depends on what’s in your Access.log file. You might want to add a head, tail or yet another grep command to get a particular range.

Simon

Leave a Reply