BookmarkSubscribeRSS Feed
srsahani
Calcite | Level 5

Hi All,

I need to find out the number of active users having their connection established in SAS EG.

Is there any way to find out using EG tool? Or is there any script/code to be written?

Version used is 5.1

/Sriram Sahani

8 REPLIES 8
CaseySmith
SAS Employee

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


Register today and join us virtually on June 16!
sasglobalforum.com | #SASGF

View now: on-demand content for SAS users

srsahani
Calcite | Level 5

Hello Casey,

Thanks a lot for you reply. Smiley Happy

I have checked with the logs of Object Spawner and came up with a few results.

I just think I am getting limited information. When checked with the logconfig.xml file for Object Spawner and Workspace server, I found that the logging level is set to "Info", it should rather be "Trace".

I will modify the file with correct level and check the logs to get full information.

/Sriram Sahani

CatCol
Fluorite | Level 6

Hello Casey,

 

I am trying to get the same information from the object spawner log but I dont find the APPNAME= text in the "New client connection ..." records. How can I get that information included in the log?

 

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.

 

Thank you,

 

CaseySmith
SAS Employee

Hi CatCol,

 

(Sorry, just noticed I never responded to this.  Following up now.)

 

Perhaps you have an older EG or server version...

 

EG started sending the APPNAME property in version 6.1.  So, you will need EG 6.1 or later (running against a 9.3 or later server) to see APPNAME= in the object spawner logs.

 

Casey


Register today and join us virtually on June 16!
sasglobalforum.com | #SASGF

View now: on-demand content for SAS users

SASKiwi
PROC Star

What version of SAS are you using? With SAS 9.4 and where SAS Environment Manager is set to log usage with default settings you can check the the number of SAS spawner connections to the appropriate workspace server in the SAS EMgr dashboard, for example SASApp.

A graph of the SAS spawner connections is shown over time and this is a good proxy of the number of EG sessions on your SAS server. Note that a user can have multiple sessions, so this doesn't tell you how many unique users there are.

It may be possible to configure the default monitoring to do this. I'll leave that up to contributors more experienced in this area.

srsahani
Calcite | Level 5

Hello,

We are using version SAS 9.3 . Do you know if the same functionality can be used in this version which you have mentioned for SAS 9.4 ?

/Sriram Sahani

SASKiwi
PROC Star

Unfortunately not. SAS Environment Manager is new in 9.4. Examining log files is probably the best way to with 9.3

jakarman
Barite | Level 11

When you want to know the running processes of some session ise the ps -ef system commands for that. Read the man pages.

Wanting the do some similar things like eventmanger in 9.4 you have the APM tool. In fact it is predecessor. The design of it is however rather poor and limited.

When having a fucntional problem try to describe that in a smart way. Do not ask for a named tool. A fool wiht a tool is still a fool.

---->-- ja karman --<-----

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 8 replies
  • 2516 views
  • 4 likes
  • 5 in conversation