FM Server access logs
I'm starting to use the logs to determine access of the databases on our
server. We are using FileMaker Server 10 Advanced running on Windows 2003 with
Instant Web Publishing enabled. The web client generally is FireFox 3.5.5, mine
is running on Windows 7. Most of the others run Windows XP Professional.
I can see the logs in the FM Server admin console (I view all of them), and in
the \Program Files\FileMaker\FileMaker Server\Logs directory. As far as access
is concerned, what I can determine is who logs in/out, navigation (next, prev,
gotorec), and cancel edit.
If I look at the windows web logs (\WINDOWS\system32\LogFiles\W3SVC1\), I see
very similar detail, and when a user makes a change, I see a POST message. What
I don't see in the windows web logs is the user name, only the IP address.
2009-12-10 12:46:52 W3SVC1 22.214.171.124 POST /fmi/iwp/cgi - 443 - 172.25.186.140 Mozilla/5.0+(Windows;+U;+Windows+NT+6.1;+en-US;+rv:126.96.36.199)+Gecko/20091102+Firefox/3.5.5 200 0 0
What I would like to see in the wpc_access_log.txt file when someone does an
edit (and submit) is to see the user name, the time, and the number of the
record they changed. All I see is this:
2009-12-10 12:46:52 Web Publishing Core Information 172.25.186.140:0 - ekberg "/fmi/iwp/cgi" 200 103428
This is not very useful. It doesn't say this is an edit (no POST) and the
record number is not shown.
Additional levels of access would be nice: when a record is edited, the old/new
values. Same sort of thing for create and delete. For HIPAA, knowing which
records are visible on the page would be useful.
Did I miss a logging feature? If not, any idea on when these kinds of access
logs will be available in FileMaker Server Advanced?