Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

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

Reply
Contributor SKG
Contributor
Posts: 55

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

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

 

 

New Contributor
Posts: 3

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

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

Regular Learner
Posts: 1

Re: How to get SAS Visual Analytics Users login and logout details daily, 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 

Trusted Advisor
Posts: 1,852

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

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

Ask a Question
Discussion stats
  • 3 replies
  • 438 views
  • 3 likes
  • 4 in conversation