topic Active SAS EG connections in SAS Enterprise Guide

Active SAS EG connections

RahulN — Fri, 26 Jun 2015 08:36:50 GMT

Hello,

I need to know how to check number of active SAS EG connections established at a particular time.

Version used is 5.1

/Rahul Nimje

Re: Active SAS EG connections

CaseySmith — Fri, 26 Jun 2015 18:04:25 GMT

Hi,

I think your best bet is to parse the object spawner logs, which will show you the connections to SAS workspace servers from EG (APPNAME=SAS Enterprise Guide), the user, and the process ID of the sas.exe process. For example:

2015-06-26T13:49:22,799 INFO [00006715] :cassmi@CARYNT - New client connection (204) accepted from server port 8591 for user cassmi@CARYNT. Encryption level is Credentials using encryption algorithm SASProprietary. Peer IP address and port are [::ffff:10.40.13.23]:11997 for APPNAME=SAS Enterprise Guide.

2015-06-26T13:49:23,142 INFO [00006715] :cassmi@CARYNT - Created process 19952 using credentials cassmi@CARYNT (child id 93).

2015-06-26T13:49:23,158 INFO [00006961] :SYSTEM@UITSRV04 - New out call client connection (205) for launched server (child 93). Peer IP address and port are [::ffff:10.121.18.73]:57832.

2015-06-26T13:49:23,158 INFO [00006966] :SYSTEM@UITSRV04 - Launched process 19952 (child id 93) is now running as process 17908.

2015-06-26T13:49:23,158 INFO [00006961] :SYSTEM@UITSRV04 - Client connection 204 for user cassmi@CARYNT closed.

2015-06-26T14:01:34,302 INFO [00006975] :SYSTEM@UITSRV04 - Client connection 205 for user cassmi@CARYNT closed.

2015-06-26T14:01:34,333 INFO [00006722] :SYSTEM@UITSRV04 - Process 17908 (originally 19952) for user cassmi@CARYNT (child id 93) has ended.

Casey

Re: Active SAS EG connections

RahulN — Sat, 27 Jun 2015 07:21:05 GMT

Hello Casey,

Thanks for your answer. I tried but there are some difficulties for finding the users logged in SAS EG.

I tried for multiple logs but can find only one message for SAS EG,so I am still unable to find the users.

I have following settings in the config file : logconfig.xml

</logger>

Should I change anything to trace the users ?

I found following on the internet :

To increase the logging level for multiple spawner sessions :

Open the spawner's logconfig.xml file, and locate the following lines:
<logger name="App"> <level value="Info"> </logger>
Change <level value="Info"> to <level value="Trace">
Restart the spawner.

Any recommendation from you?

Re: Active SAS EG connections

jakarman — Sat, 27 Jun 2015 08:27:45 GMT

Analyzing the logs will show what has happened in the past.

Doing analyses on running processes using the os commands like PS will show you what is happening now.

Re: Active SAS EG connections

Kurt_Bremser — Sat, 27 Jun 2015 09:26:49 GMT

For the past, analyze the spawner log(s). For current state, ps -ef (on UNIX systems) will give you a list of all running processes; since workspace server sessions have a very distinct commandline, a proper grep will sort out the WS processes.