2 Replies Latest reply on Dec 14, 2009 7:48 AM by TWE

    FM Server access logs

    TWE

      Title

      FM Server access logs

      Your post

      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 128.95.186.74 POST /fmi/iwp/cgi - 443 - 172.25.186.140 Mozilla/5.0+(Windows;+U;+Windows+NT+6.1;+en-US;+rv:1.9.1.5)+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?