topic Generate SAS USERS access report. in Administration and Deployment

Generate SAS USERS access report.

Saud — Tue, 05 Apr 2016 14:44:09 GMT

Hello,

I’m using SAS 9.3 installed in MS server, the current platform hosting multiple SAS application (CS AML EGRC WRS ets..).

I need to generate a report contains all user access (login/log out). Is there a way to extract such information from metadata ?

And how to generate this reports

thanks in advance

Re: Generate SAS USERS access report.

JuanS_OCS — Tue, 05 Apr 2016 14:49:34 GMT

Hi,

you can get the information on different ways:

- By parsing the log files (Metadata server log, Workspace server log, SAS Web Application logs)

- On the SAS Management Console, if you go to the lowest level of your SAS metadata server, you can Right-click and "Connect". Then on the right side you can see your logins of the day.

- APM/ACM reports can provide, I believe, such reports.

Re: Generate SAS USERS access report.

SASKiwi — Tue, 05 Apr 2016 19:33:47 GMT

Do you simply want a report of all SAS users defined in your metadata (potential users) or do you want a report of SAS users actually using your system?

Re: Generate SAS USERS access report.

Saud — Wed, 06 Apr 2016 06:01:09 GMT

Thank you both JuanS_OCS & SASKiwi

Actually I’m using the metadata server log. But the issue it contains all user connection thru application MidTier activity; while I’m looking for a simple report (user id, login IP, login/logoff time).

Regards

Re: Generate SAS USERS access report.

JuanS_OCS — Wed, 06 Apr 2016 06:07:23 GMT

Hi @Saud,

so, do you want to audit only the web applications?

In case that this is what you need, you may want to give a look into those:

http://support.sas.com/documentation/cdl/en/bimtag/68217/HTML/default/viewer.htm#n06skrc2rtwecsn14vi4qtfl54kx.htm

http://support.sas.com/documentation/cdl/en/biwaag/63149/HTML/default/viewer.htm#a003310614.htm