View users logged in filemaker 7

[M.A]

Hi All,

Is there any way in Filemaker 7 to see all those users currently logged in and using the database without having to go to the server and use FMServer Admin app.

Thanks in Advance for the help.

[stanley]

MA:

You can install the FM ServerAdmin app on your machine, and administer the server remotely.

-Stanley

[M.A]

Even with the FM Server admin app, it does not tell who is logged in. It just tells what machines the users are logged in, but not the username of the logged in user.

[JamesL]

Since in two weeks time nobody came up with a solution, I suppose that,

apart from the FM Server admin app telling on what machines the users are logged in,

the most you can have now is the NUMBER of users that are logged in, (not their accountnames)

Get(Usercount)

It works for IWP as well. You may have to set the calculation to "unstored".

[mcbrady]

I suppose you could use your open/login script and a close/log out script in combination with a "user profile" table to track when they come in and out.

Under file options, you can specify which script to use when the file is opened, and which to use when it closes.

As part of each user's log in script, use Set Field to insert their username into a field on their user profile. When they log out, have it set the field to blank/nothing.

Create a find script using * to find any of the userprofiles that have something in that field you created above.

The result will be a found set of the user profiles who are currently logged in.

This assumes that you use a log in/ log out. I'm sure there are plenty of ways to do it, this is just one...not nessessarily the most efficient.

Enjoy

[Oldsneekers]

I use a table with empolyee names, and all relevent data. When they log in, the appropriate fields for each employee record are populated for date, time and location. When loging off, this info is cleared from the fields. to be repopulated at a later log on. ( If you wanted to track past and present use, you could have an archive table with a new record for every lon on.) To list who is logged on and where, I have a script that enters * for terminal name and perform find to show only those employee records where someone is logged on.