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...
Best Answer
Answers
-
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 0100218d800041000 -
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.
0
Categories
- All Categories
- 117 Developer Announcements
- 52 Articles
- 145 General Questions
- 133 Services
- 56 OpenText Hackathon
- 35 Developer Tools
- 20.6K Analytics
- 4.2K AppWorks
- 9K Extended ECM
- 912 Cloud Fax and Notifications
- 81 Digital Asset Management
- 9.3K Documentum
- 29 eDOCS
- 167 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management
- 4 XM Fax