How to get SAS Visual Analytics Users login and logout details daily, weekly, monthly and yearly?

[SKG]

Hi Guys,

I need to make a dataset for SAS Visual Analytics Users login and logout details daily, weekly, monthly and yearly.

Like

Sno.   Username      login_time                     logout_time                     Attempted
1         Sunny           13/06/2017 16:09:10     13/06/2017 18:09:10      Successful login
2         Kumar           12/06/2017 20:09:10                                            Unsuccessful login
-------------------------------------------------------------------------------------------------------------------------------

[neetutripathi]

you can try something like this article  and put your app name in the sas app column.Save this data in different datasets as per your need and merge/manage weekly monthly and yearly.

https://communities.sas.com/t5/SAS-Communities-Library/Get-last-SAS-logins-of-users-and-clients/ta-p...

[JimChen]

Hi, SKG,

I have exactly the same question that you have. Have you figured out how to do it? 

You would like:

Sno.   Username      login_time                     logout_time                     Attempted
1         Sunny           13/06/2017 16:09:10     13/06/2017 18:09:10      Successful login
2         Kumar           12/06/2017 20:09:10                                            Unsuccessful login

Thank you very much in advance. 

Jim 

[JuanS_OCS]

Hello @SKG, @JimChen,

additionally to the great Library post provided by @neetutripathi:

did you came across this other post? https://communities.sas.com/t5/Administration-and-Deployment/View-SAS-User-s-Login-Logout-time-amp-m...

or this one https://communities.sas.com/t5/Administration-and-Deployment/Metadata-user-activities/td-p/153199

Bottom line is: what you need is to extend the information on logging of the certain events, in middle tier (SAS Logon/ SAS VA) and/or SAS metadata, then collect this information (by parsing or redirecting output of the log to a table) and then you can process it.

http://documentation.sas.com/api/docsets/logug/9.4/content/logug.pdf?locale=en

https://go.documentation.sas.com/api/docsets/bimtag/9.4/content/bimtag.pdf

In any case, I would like to recommend, very much, to enable the SAS VA Audits (Administration reports, as of SAS Documentation), then you will get a ton of additional information from your environment, such as usage of tables, and reports and their access by users.

http://support.sas.com/resources/papers/proceedings17/1076-2017.pdf

The only thing you would like to keep in mind, if you follow my recommendation, is to maintain those audit tables:

http://support.sas.com/kb/58/599.html

http://support.sas.com/kb/58/589.html

http://support.sas.com/kb/60/182.html

[toshi]

It's been years but still no promising & exact answer to this problem...

I have tried parsing the SAS Metadata logs but it could not provide me the logout timing for the user who logged in to SAS VA.

Have look at below log statements-

2022-12-14T17:33:38,935 INFO [36904070] :USER1 - New client connection (300281) accepted from server port 8561 for SAS token user USER1. Encryption level is Credentials using encryption algorithm SASPROPRIETARY. Peer IP address and port are [::ffff:172.25.85.35]:49844 for APPNAME=Visual Analytics Viewer 7.5.

2022-12-14T17:33:38,954 INFO [36904085] 300281:sas - Client connection 300281 for user USER1 closed.

How can the user be logged out in less than a second?

How to get the correct logout information from the logs.

I have tried Environment Manager Reports APM/ACM etc. but it doesn't give the desired information & output.

Thanks in Advance