topic Re: User Listing fromMetadata 1.Last login date 2. user id creation date 3.user id status-active,dor in SAS Enterprise Guide

User Listing fromMetadata 1.Last login date 2. user id creation date 3.user id status-active,dormant

saikrishna — Wed, 31 Aug 2016 10:06:28 GMT

Dear All,

As part of ID managment report, need to get belwo details.

1.Last login date 2. user id creation date 3.user id status-active,dormant

Re: User Listing fromMetadata 1.Last login date 2. user id creation date 3.user id status-active,dor

JuanS_OCS — Wed, 31 Aug 2016 10:14:01 GMT

first you can get for sure by parsing the metadata server log files. and I believe you can get the second one too, but not fully sure at this moment.

The third I would create it on function of the first value. something like if Last loging date is longer than 2 months iwill be dormant user, otherwise an active user. This logic will depend on your company's security policies and models.

Re: User Listing fromMetadata 1.Last login date 2. user id creation date 3.user id status-active,dor

Kurt_Bremser — Wed, 31 Aug 2016 10:38:51 GMT

Which operating system does your SAS server use? This is of importance for #2, and also for #3, as recently created users should not be counted as inactive if they have not yet used the SAS system.

Re: User Listing fromMetadata 1.Last login date 2. user id creation date 3.user id status-active,dor

saikrishna — Thu, 01 Sep 2016 07:50:41 GMT

HI KurtBremser,

Thanks for response.It Windows os

Re: User Listing fromMetadata 1.Last login date 2. user id creation date 3.user id status-active,dor

LinusH — Sun, 04 Sep 2016 05:55:35 GMT

If you are on 9.4 I would start to look what Environment Manager can offer:
https://support.sas.com/documentation/cdl/en/evug/69029/HTML/default/viewer.htm#n12v4rjg74mgrhn19m2gg64rerxq.htm

Re: User Listing fromMetadata 1.Last login date 2. user id creation date 3.user id status-active,dor

Kurt_Bremser — Mon, 12 Sep 2016 05:45:56 GMT

@saikrishna wrote:

HI KurtBremser,

Thanks for response.It Windows os

Then you need somebody else's help on how to extract that from the system. I'm a UNIX guy.