topic Re: SAS EG active users in SAS Enterprise Guide

SAS EG active users

srsahani — Fri, 26 Jun 2015 06:40:28 GMT

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

Re: SAS EG active users

CaseySmith — Fri, 26 Jun 2015 18:04:57 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: SAS EG active users

SASKiwi — Fri, 26 Jun 2015 23:44:21 GMT

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.

Re: SAS EG active users

srsahani — Mon, 29 Jun 2015 12:21:17 GMT

Hello Casey,

Thanks a lot for you reply.

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

Re: SAS EG active users

srsahani — Mon, 29 Jun 2015 12:24:02 GMT

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

Re: SAS EG active users

SASKiwi — Mon, 29 Jun 2015 19:44:36 GMT

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

Re: SAS EG active users

CatCol — Tue, 22 Sep 2015 15:42:25 GMT

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?

Thank you,

Re: SAS EG active users

jakarman — Thu, 24 Sep 2015 21:38:24 GMT

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.

Re: SAS EG active users

CaseySmith — Thu, 12 May 2016 14:04:09 GMT

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