Creating a user Log

[Joseph31]

Is there a way to create a log file that will show me when a user logs into FM Database and when Log Out?

I am using FM Server 8 and FM 8 - 8.5 on workstations

Thank you,

Joseph

Edited May 30, 2008 by Guest

[bcooney]

In an open script, create a record in a Log table for that user's login; AccountName, LoginTimeStamp. Your Close script could create a record for recording the users's logout.

[Steven H. Blackwell]

FileMaker Server already creates this log for you.

Steven

[Joseph31]

Where would this be?

Thank you

[Steven H. Blackwell]

It's in the Logs folder of the root level FileMaker Server executable. On Windows that's in the programs directory on C. On Macintosh it's in the root level Library. Drill down thru the FileMaker Server directory until you find it.

HTH

Steven

[Joseph31]

Ok I will take a look --- is there anyway to get this report emailed to me everyday?

[Joseph31]

Can you show me an example of this if you have already done one? It would sure help me.

Thank you,

Joseph

[bcooney]

You'll need a Users table that has a field with their Account Name in it.

Then, in your Open Script (the script that runs when the file opens), you:

1. Go to a layout based on a Users TO.

2. Enter Find Mode.

3. Set Users::AccountName to Get (AccountName)

4. Perform Find.

Now you are on the User's record that just logged in. Create a new record in your Log table:

5. Set $$UserID to Users::primaryKeyID

6. Go to Login Table

7. Create New Record

8. Set Login::UserID to $$UserID

9. Set LoggedIn to Get (HostTimeStamp)

Close does the same thing, but sets LoggedOut.

[Joseph31]

I have to say I am a little lost -- I have tried what you said but does not show me anything --- Is there way to show me an example.

Also, I need this to run without notice to the user.

Thank you,

Joseph

[bcooney]

I think I've over-engineered my initial response. Here's an example of what I'm talking about. Under File Options, you set the Open/Close scripts to run, respectively.

UserLog.zip

[Joseph31]

thank you -- but what would the Login and password be -- I have tried everything?

[Joseph31]

I can not seem to login to your sample -- what is the password and user name that you used? Or am I doing something wrong?

Thank you for your time

Joseph

[bcooney]

I'm so sorry.

Account Name: admin

password: pwd

[Joseph31]

Great work on this -- work perfectly ---

Is there a way to email the results to my email -- but not use the workstation email (Do not want them to see this).

Thank you,

Joseph