Architecting, installing and maintaining your SAS environment

How do I measure the use of the SAS Add In?

Accepted Solution Solved
Reply
Contributor
Posts: 22
Accepted Solution

How do I measure the use of the SAS Add In?

Morning all,

 

we had a manager say that the SAS Add-in was used a lot and I have been trying to quantify that. When someone uses the SAS Add-in (from Excel or Word) it spawns a SAS Workspace Server session, so it is possible to go and find the log for that and see what they did. In the same way Enterprise Guide spawns a Workspace Server session too.

 

I am trying to identify what started the session from the log. Comparing two logs side by side I couldn’t see anything that I could use to do that. Has anyone done this? Or know of a way to do it?

 

I suppose I could change the way they are spawned and add a macro variable to pass in to use, but that involves messing around with configurations. Any advice would be appreciated.

 

thanks

Phil


Accepted Solutions
Solution
‎07-05-2016 06:30 AM
SAS Super FREQ
Posts: 684

Re: How do I measure the use of the SAS Add In?

Hi

 

The Object Spwaner log can tell you this information, see example below

 

 

2016-07-05T13:34:41,262 INFO [00000047] :abc@cdf - New client connection (12) accepted from server port 8591 for user abc@cdf. Encryption level is Credentials using encryption algorithm SASProprietary. Peer IP address and port are [::ffff:127.0.0.1]:49653 for APPNAME=SAS Add-In for Microsoft Office.
2016-07-05T13:37:38,026 INFO [00000075] :abc@cdf - New client connection (14) accepted from server port 8591 for user abc@cdf. Encryption level is Credentials using encryption algorithm SASProprietary. Peer IP address and port are [::ffff:127.0.0.1]:49921 for APPNAME=SAS Enterprise Guide.

 

Bruno

View solution in original post


All Replies
Solution
‎07-05-2016 06:30 AM
SAS Super FREQ
Posts: 684

Re: How do I measure the use of the SAS Add In?

Hi

 

The Object Spwaner log can tell you this information, see example below

 

 

2016-07-05T13:34:41,262 INFO [00000047] :abc@cdf - New client connection (12) accepted from server port 8591 for user abc@cdf. Encryption level is Credentials using encryption algorithm SASProprietary. Peer IP address and port are [::ffff:127.0.0.1]:49653 for APPNAME=SAS Add-In for Microsoft Office.
2016-07-05T13:37:38,026 INFO [00000075] :abc@cdf - New client connection (14) accepted from server port 8591 for user abc@cdf. Encryption level is Credentials using encryption algorithm SASProprietary. Peer IP address and port are [::ffff:127.0.0.1]:49921 for APPNAME=SAS Enterprise Guide.

 

Bruno

Occasional Contributor
Posts: 12

Re: How do I measure the use of the SAS Add In?

Bruno,

Are those codes specific to client applications? Just curious. Assuming so.
SAS Super FREQ
Posts: 684

Re: How do I measure the use of the SAS Add In?

Yes they are specific to the application like

 

APPNAME=SAS Enterprise Guide.

 

I do not know of a list of app names

 

Bruno

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 351 views
  • 2 likes
  • 3 in conversation