topic Re: User Listing from Metadata in SAS Data Management

User Listing from Metadata

mikesatriaevo — Thu, 26 Jul 2012 07:32:46 GMT

Hi,

I have a queries pertaining getiing a full listing of user. Hereare the code i use

=======================================

options

metaserver="mysVA5101"

metaport=8561

metauser="admin"

metapass="Admin12345"

metarepository=Foundation

metaprotocol=BRIDGE;

/* Specify the directory for the extracted metadata.*/

libname meta "C:\temp";

/* Extract identity information from the metadata.*/

%mduextr(libref=meta);

/* Match the person identity to UserIDs */

proc sql;

select a.Name,a.DisplayName,b.UserId

from meta.Person as a,meta.Logins as b

where a.keyid=b.keyid;

quit;

=============================

The result may refer to following attach image.

My queries is, beside extracting the user is, can we also extract the following information:

1) Last login date
2) user id creation date
3) user id status (active,barred,etc)

Your help and advise is appreciated.

Regards,

Mike

Re: User Listing from Metadata

LinusH — Thu, 26 Jul 2012 08:35:47 GMT

Those attributes are not exported to the canonical tables. But at least 1) and 2) should be available within metadata, and accessible by data step functions. Not sure about 3), I wasn't aware of that you can set status for a user, or do you mean status of a user id from the external authentication provider?

Re: User Listing from Metadata

mikesatriaevo — Thu, 26 Jul 2012 08:45:15 GMT

I try to browse the table which generated using %mduextr(libref=meta), the tables shows inside there does not show item 1 and 2. Is there any specific command or code i can use.

Re: User Listing from Metadata

shivas — Thu, 26 Jul 2012 08:46:03 GMT

Hi ,

Check this link for login and other details of metadata.Hope this helps.

http://support.sas.com/documentation/cdl/en/omamodref/61849/HTML/default/viewer.htm#login.htm

Thanks,

Shiva

Re: User Listing from Metadata

LinusH — Thu, 26 Jul 2012 08:50:21 GMT

No, item 1 & 2 are available via data step functions, NOT in the canonical tables (created by %mduextr).

Re: User Listing from Metadata

mikesatriaevo — Thu, 26 Jul 2012 09:28:08 GMT

may i know which tables in the metatdata i should refer to?

Re: User Listing from Metadata

LinusH — Mon, 30 Jul 2012 10:54:51 GMT

There are no logical (that is, what we as SAS users can see) tables in the metadata server. We can query the metadata using different API:s, and one is using data step functions.

The data is stored logically following an object model approach. For a reference abut that, follow Shivas link.

For syntax on data step metadata functions, see online doc. there are also quite a lot of papers and samples available on the SAS support site as well.

Re: User Listing from Metadata

saikrishna — Wed, 31 Aug 2016 09:47:01 GMT

Hi ,

Please can you refer any document to details 1 and 2