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

Note:

Although this command returns information about both ArcSDE service and direct connections, the sdemon –o info command cannot be executed unless there is an ArcSDE service running. For example, if some of your client applications use a direct connection but others use the ArcSDE service, you can execute this command. If all use direct connections and an ArcSDE service was never created, you cannot run the sdemon –o info command

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.