topic Reporting on User Logins within SAS VA in SAS Visual Analytics

Reporting on User Logins within SAS VA

egwilliamson — Thu, 16 Nov 2017 18:19:14 GMT

If I am interested in detailing out User Logins, either their last login, all their logins, etc. Where would I go to obtain this information and produce some type of report or view the details?

Re: Reporting on User Logins within SAS VA

Matthijs_Hofman — Fri, 17 Nov 2017 08:03:17 GMT

I think it's best if you ask SAS for the Administrator Overview report. I believe that this report answers most, if not all of your questions. Unfortunately it does not work for my company because we have 1000+ users and the Administrator Overview is way too detailed to cope with traffic like that. If someone at SAS has a solution for that, that would be helpful!

Re: Reporting on User Logins within SAS VA

JuanS_OCS — Fri, 17 Nov 2017 10:29:25 GMT

Hello @egwilliamson, @Matthijs_Hofman,

interesting. Indeed, by default on VA the first and best approach is the Administration Reports. However, some additional information:

- SAS Environment Manager and the Architecture framework enables additional reports in the Report Center, see screenshot

https://support.sas.com/rnd/emi/SASEnvMgr/EVSAF/index.html

https://support.sas.com/rnd/emi/SASEnvMgr/EVSAF/Report_Center_Report_Listings.pdf

- Also, that report is just a report. If the information it is too detailed, just copy the report and customise it to your needs. Just don't modify the default one, keep it.

- Or you can just enable the auditing on what you need:

http://documentation.sas.com/?docsetId=bimtag&docsetTarget=n06skrc2rtwecsn14vi4qtfl54kx.htm&docsetVersion=9.4&locale=en

- Finally, consider all of those reports just take the data from somewhere, right? That somewhere is the EVMDM library, which is on your EVMDM autoload location.... and this Datamart is filled in from the internal SAS database, SharedServices

http://support.sas.com/resources/papers/proceedings17/1076-2017.pdf thanks @ElenaMuriel from Amadeus

https://blogs.sas.com/content/sgf/2015/12/29/what-is-going-on-with-my-visual-analytics-audit-data-collection/

https://blogs.sas.com/content/sgf/2015/11/09/controlling-the-size-of-the-web-infrastructure-platform-database-audit-tables/

PS. Keep an eye on the size of the audit tables. If you get performance issues, please read:

http://support.sas.com/kb/58/589.html

http://support.sas.com/kb/58/599.html

Re: Reporting on User Logins within SAS VA

egwilliamson — Fri, 17 Nov 2017 13:14:09 GMT

Do these Administrator Reports have to be enabled in any fashion, or are they collecting data since the instance was operational?

Re: Reporting on User Logins within SAS VA

Matthijs_Hofman — Fri, 17 Nov 2017 13:26:55 GMT

Not sure. I think that they are accessible already by an administrator. See SAS folders under Products --> SAS Visual Analytics Administrator --> Reports --> Usage.

Re: Reporting on User Logins within SAS VA

JuanS_OCS — Fri, 17 Nov 2017 14:45:34 GMT

Hello @egwilliamson,

the reports will be found at the location @Matthijs_Hofman mentioned. However, the data collection must be enabled.

Please follow:

https://support.sas.com/documentation/cdl/en/vaag/69958/HTML/default/viewer.htm#n0ztu074vadeuvn17a1hpspp4bd7.htm

and please do not forget the steps included in the links within the last paragraph Agent-Collected Metrics

Agent-Collected Metrics

Note: Agent-collected metrics do not provide information about distributed SAS LASR Analytic Servers.

To feed agent-collected metrics (ACM) to the drop zone:

Enable data collection. See Initializing and Enabling the Service Management Architecture in the SAS Environment Manager: User’s Guide.

Enable data transfer to the EVDMLA drop zone. See Feeding Data From the Data Mart into SAS Visual Analytics in the SAS Environment Manager: User’s Guide.

Tip
A supporting format catalog must be available. When you enable this data feed, the required format catalog is added to the /AppData/SASVisualAnalytics/VisualAnalyticsAdministrator/AutoLoad/EVDMLA/Formats directory. For some applications, the format catalog must also be added to the path of the appropriate SAS Application Server. See Supporting User-Defined Formats.

After a sufficient interval has elapsed, verify that the expected ACM tables are loaded. For information about the source data, see ACM Tables in the SAS Environment Manager: User’s Guide. (The list of tables is subject to change in future releases of SAS Environment Manager.)