BookmarkSubscribeRSS Feed
SKG
Obsidian | Level 7 SKG
Obsidian | Level 7

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

 

 

4 REPLIES 4
neetutripathi
Fluorite | Level 6

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
Calcite | Level 5

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
Amethyst | Level 16

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
Fluorite | Level 6

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

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!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 4 replies
  • 2825 views
  • 3 likes
  • 5 in conversation