BookmarkSubscribeRSS Feed
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.


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



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.

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. 


Amethyst | Level 16

Hello @SKG@JimChen,


additionally to the great Library post provided by @neetutripathi:


did you came across this other post?

or this one


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.


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.


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

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



Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

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
  • 5 in conversation