Finding out How Many Users are Accessing the Database

[Chris Kelleher]

Hi.. all...

Can anyone help me with a small program
that can find out how many users are
login on using progress ??

Maybe if available with the pid and
user name too.

Thks.

Rgds.

Osam

 

[Chris Kelleher]

Well, from the command prompt you could use promon database-name to get all kinds of interesting information, including users logged in.

If you are running Progress 8.2+, you could also enable VST (Virtual System Tables) and read the user records right from there.

HTH.

--
Chris Schreiber
ProgressTalk.com Manager
webmaster@progresstalk.com

 

[Chris Kelleher]

Osam,
I tried this from the Progress editor on an
HP Unix system and it may be good enough to
satisfy your needs. You also may need to be
logged on as superuser to see all users.

<BLOCKQUOTE><font size="1" face="Arial, Verdana">code:</font><HR><pre>
/*Start Program*/

UNIX SILENT ps -f > ./tmp.txt.
UNIX grep "dlc" ./tmp.txt.

/*End Program*/

This following is an example of the output.
UID PID PPID TTY TIME COMMAND
user1 22860 22859 2c7 0:07 /u/dlc/bin/_progres -pf startdemoq.pf
[/code]

It's not pretty, but it seems to work.
You could try replacing ps -f with the w command also.

Ain't life grand?
Mark

 

[Chris Kelleher]

Thank you Mark.
But I think I still can not use it, Even if my question is asking abount Pid,
but right now I am using win95 for development.

So would you help me with other small program?

Thks.

Rgds,

Osam