Displaying connected sessions

To discover what users are currently connected to the geodatabase, you can use the sdemon command with the info operation and the users or users_long option.

The syntax for this is as follows:

sdemon –o info –I {users | users_long} [-q]
{[–i <service> | <port#>] [–s <server_name>] | [–H <sde_directory>]}

When you specify the users option, the sdemon –o info command returns the following information, with each returned row representing one connection:

• S-ID—The SDE-ID of the server
• S-PID—The operating system-level process ID of the server
• User—The name of the user under which the connection was made
• Conn—The type of connection; AS = ArcSDE service or DC = direct connection
• Client:OS—The name of the connecting client machine, the operating system it is running, and whether or not an external data representation (XDR) connection is used
• Started—The date and time the connection was initiated

When you specify the users_long option, the information is returned in a list per each connection. The following information is returned:

• Server task ID—The SDE-ID of the server
• Server task PID—The operating system-level process ID of the server
• Connection type—The type of connection: AppSrvr = ArcSDE service or Direct = direct connection
• User name—The name of the user under which the connection was made
• Client machine—The name of the connecting client machine
• Client OS—The operating system of the connecting client machine
• XDR—Indicates whether the client and server machines are of the same byte order (If they are the same, XDR = no; if they differ, XDR = yes.)
• Start time—The date and time the connection was initiated

Steps:

1. Open an MS-DOS (Windows) or shell (UNIX or Linux) command prompt on a computer on which you have access to the ArcSDE administration commands.
2. Issue the sdemon command with the info operation and users or users_long option.

   sdemon –o info –I users –i 6000 –s myserver
   
   S-ID   S-PID   User      Conn  Client:OS          Started
   546    68821   RJP       AS    hundehutte:Win32   Mon Oct 27 07:32:56 2008
   547    44790   PERRITA   DC    halter:Win32:XDR   Mon Oct 27 08:11:05 2008

   sdemon –o info –I users_long –i 6000 –s myserver 
   
   Server task ID: 546
   Server task PID: 68821
   Connection type: AppSrvr
   User name: RJP
   Client machine: hundehutte
   Client OS: Win32
   XDR: no
   Start time: Mon Oct 27 07:32:56 2008
   
   Server task ID: 547
   Server task PID: 44790
   Connection type: Direct
   User name: Perrita
   Client machine: halter
   Client OS: Win32
   XDR: yes
   Start time: Mon Oct 27 08:11:05 2008

   Tip:

   To see which users are connected to a geodatabase in a user's schema, you must specify the schema name with the -i option. For example, for a geodatabase in the schema maxp in the previous example, specify -i 6000:maxp.