Jump to content
Sign in to follow this  
Joseph31

Creating a user Log

Recommended Posts

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 by Guest

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Thank you,

Joseph

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

I'm so sorry.

Account Name: admin

password: pwd

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Who Viewed the Topic

    2 members have viewed this topic:
    Veselko  nexgen 
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.