topic Re: How to get SAS Visual Analytics Users login and logout details daily, weekly, monthly and yearly in SAS Visual Analytics

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

SKG — Tue, 13 Jun 2017 10:47:43 GMT

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
-------------------------------------------------------------------------------------------------------------------------------

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

neetutripathi — Thu, 15 Jun 2017 12:40:33 GMT

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/352727

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

JimChen — Thu, 26 Jul 2018 20:26:43 GMT

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

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

JuanS_OCS — Fri, 27 Jul 2018 06:54:19 GMT

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-memory-usage/td-p/294728

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

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

toshi — Tue, 21 Feb 2023 07:24:23 GMT

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