How do I count the number of open Documentum sessions?

I'm trying to find a way to count the number of DFC sessions I have open at any given time.

Is there a way I can do this without logging into a WDK client, like DAM or DA? For example, is there a database table in MS SQL Server holds the session information so I can query it to determine the number of open sessions?

Or is there a way I can write a program to do this? I tried to get my hands on Xense but found it doesn't support D6.5 yet, and I need to check on both D6.5 and D5.3...

Find more posts tagged with

Note:

If there are Accepted Answers, those will be shown by default. You can switch to 'All Replies' by selecting the tab below.

Accepted answers

DCTM_Guru

This information is not persisted in the database tables. You can using this DQL function to lookup this runtime information:

execute show_sessions; OR

execute list_sessions;

You will have to write a DFC app to execute the DQL.

All comments

DCTM_Guru

This information is not persisted in the database tables. You can using this DQL function to lookup this runtime information:

execute show_sessions; OR

execute list_sessions;

You will have to write a DFC app to execute the DQL.

msroth

You can also run the dm_who.awk script in the /bin directory.

dmawk32 -f dm_who.awk <docbase> -U<username> -P<password>

It will give you output like this:

Current users on docbase 'Docbase'

User            Connected From Start Time            Last Activity         Session ID
~~~~            ~~~~~~~~~~~~~~ ~~~~~~~~~~            ~~~~~~~~~~~~~         ~~~~~~~~~~
dmadmin         <host>          10/14/2009 9:14:43 P 10/14/2009 9:14:43 P 0100218d80004121
dmadmin         <host>        10/14/2009 8:55:32 P 10/14/2009 9:14:36 P 0100218d80004103
dmadmin         <host>        10/14/2009 9:02:45 P 10/14/2009 9:04:27 P 0100218d80004113
dmadmin         <host>        10/14/2009 9:01:26 P 10/14/2009 9:02:31 P 0100218d80004110
dmadmin         <host>        10/14/2009 8:58:53 P 10/14/2009 8:58:59 P 0100218d8000410b
dmadmin         <host>        10/14/2009 8:56:53 P 10/14/2009 8:56:59 P 0100218d80004107
dmc_wdk_preset <host>        10/14/2009 8:54:47 P 10/14/2009 8:54:48 P 0100218d80004101
dmc_wdk_prefer <host>        10/14/2009 8:54:25 P 10/14/2009 8:54:45 P 0100218d80004100

mgrootsch

Execute with iapi32.exe

apply,c,NULL,LIST_SESSIONS
next,c,q0
dump,c,q0

silvrlifeA0

Works well.

Thanks for sharing

Apart from above I use exec show_sessions in dql( which gives same result)

If I simply want the count, I use exec count_sessions.

This is for the content server.