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
-------------------------------------------------------------------------------------------------------------------------------
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.
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
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
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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.