Is there a way the determine how many users are defined

for an OI app & who they are ?

Is there an OI program to give a list of all users defined and

which app(s) they belong ?

How do I find out which users & stations are on an app at one time ?

Is there an OI program to give a list of stations defined ?

Can I determine if run-time OI is in effect so that I do not even

attempt to run the development-only commands (i.e. create-table

delete-table, etc.)

I am sure there is a atom bomb approach. But I am sure there is a

better way. Thankx for any help…….Brian

Brian,

Is there a way the determine how many users are defined for an OI app & who they are ?

Check the Get_DB_Users function ( see on-line help )

Is there an OI program to give a list of all users defined and which app(s) they belong ?

No, but you could write one using the function above and getting the app data from the SYSAPPS table

How do I find out which users & stations are on an app at one time ?

Look at what's in the SYSLOGINS table - contains who logged on and when

Is there an OI program to give a list of stations defined ?

not AFAIK - I would think this depend on the network OS you're on - what do you mean by stations defined?

Can I determine if run-time OI is in effect so that I do not even attempt to run the development-only commands (i.e. create-table delete-table, etc.)

This is a function to do this but the specifics escape me at the moment. For a quick and crude way you could check the serial number however - Runtimes usually start with an "X" while dev copies usually start with a "W". ( Check out the serial() function )

Carl Pates

Sprezzatura Ltd

Carl,

Thankx for the help.

The station reference is a physical terminal or network station idenetifier…like @STATION In OI. What I am after is the equiv of polling each user for their @STATION identifier.

…Brian

Brian,

There is @station info in SYSLOGINS … is that what you are after?

Cameron Purdy

Revelation Software

View this thread on the forum...