Joseph31 Posted May 30, 2008 Share Posted May 30, 2008 (edited) 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 Link to comment Share on other sites More sharing options...
bcooney Posted May 31, 2008 Share Posted May 31, 2008 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. Link to comment Share on other sites More sharing options...
Steven H. Blackwell Posted May 31, 2008 Share Posted May 31, 2008 FileMaker Server already creates this log for you. Steven Link to comment Share on other sites More sharing options...
Joseph31 Posted June 2, 2008 Author Share Posted June 2, 2008 Where would this be? Thank you Link to comment Share on other sites More sharing options...
Steven H. Blackwell Posted June 2, 2008 Share Posted June 2, 2008 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 Link to comment Share on other sites More sharing options...
Joseph31 Posted June 2, 2008 Author Share Posted June 2, 2008 Ok I will take a look --- is there anyway to get this report emailed to me everyday? Link to comment Share on other sites More sharing options...
Joseph31 Posted June 2, 2008 Author Share Posted June 2, 2008 Can you show me an example of this if you have already done one? It would sure help me. Thank you, Joseph Link to comment Share on other sites More sharing options...
bcooney Posted June 2, 2008 Share Posted June 2, 2008 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. Link to comment Share on other sites More sharing options...
Joseph31 Posted June 3, 2008 Author Share Posted June 3, 2008 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 Link to comment Share on other sites More sharing options...
bcooney Posted June 4, 2008 Share Posted June 4, 2008 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 Link to comment Share on other sites More sharing options...
Joseph31 Posted June 4, 2008 Author Share Posted June 4, 2008 thank you -- but what would the Login and password be -- I have tried everything? Link to comment Share on other sites More sharing options...
Joseph31 Posted June 6, 2008 Author Share Posted June 6, 2008 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 Link to comment Share on other sites More sharing options...
bcooney Posted June 6, 2008 Share Posted June 6, 2008 I'm so sorry. Account Name: admin password: pwd Link to comment Share on other sites More sharing options...
Joseph31 Posted June 9, 2008 Author Share Posted June 9, 2008 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 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5799 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now