Script to get Usernames Logged in to File

[MariaAux]

From a google search, I see there is no easy way to see which various accounts are currently logged in from around the globe either on IWP or locally.

Get (User

How would I setup a startup script to Get (Accountname) and paste it into a field along with logon time and then delete that data from the field with an exit script. I have tried 'IF' but I just can't get it to work.

Thanks so much,

Maria

[bcooney]

A simple table "Log" with three fields: Account, TimeStamp, Event.

In a startup script

Go to Layout "Log"

New Record

Set Field "Account", Get (AccountName)

Set Field "TimeStamp", Get (CurrentTimestamp)

Set Field "Event" ; "Login"

In a Closing Script:

Go to Layout "Log"

New Record

Set Field "Account", Get (AccountName)

Set Field "TimeStamp", Get (CurrentTimestamp)

Set Field "Event" ; "Logout"

Don't delete anything.

Why do you need this?

[MariaAux]

Thanks a million. I have many employees working on the same databse from differnet parts of the world. I just like to know who is online and working

Thanks again

[comment]

In a Closing Script:

Go to Layout "Log"

New Record

I was wondering why wouldn't you enter the closing timestamp in the same record that opened the session?

[David Jondreau]

I use a logging script as above, but keep in mind it's not 100%. Users can quit a file without running the On Close script, usually inadvertantly as a result of a crash or a dead battery in a laptop.

FileMaker Server will list the users logged into a database. Dont know if there's a script (system, not FileMaker) out there to capture that info though that would be nice.

[MariaAux]

Ok, all done as you have stipulated... but I just have a long list of users logging in and out and I really don't know who is actually online without having to study the list. Why shouldn't I delete anything?

Couldn't I run a closing script that;

Go to Layout (Log)

Enter Find Mode

Set Field (Log:Account; Get(AccountName)

Perform Find

Delete Record

Exit application

Wouldn't that just leave me with a list oif the users currently logged in?

Thanks so much,

Maria

[bcooney]

Sounds OK. Or, as comment suggests, enter a logoff timestamp in the last record for that Get (AccountName).