SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

User Listing from Metadata

Reply
Contributor
Posts: 21

User Listing from Metadata

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


UserLists.jpg
Super User
Posts: 5,254

Re: User Listing from Metadata

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?

Data never sleeps
Contributor
Posts: 21

Re: User Listing from Metadata

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.

Super User
Posts: 5,254

Re: User Listing from Metadata

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

Data never sleeps
Contributor
Posts: 21

Re: User Listing from Metadata

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

Super User
Posts: 5,254

Re: User Listing from Metadata

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.

Data never sleeps
New Contributor
Posts: 3

Re: User Listing from Metadata

Hi ,

Please can you refer any document to details  1 and 2

Super Contributor
Posts: 349

Re: User Listing from Metadata

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

Ask a Question
Discussion stats
  • 7 replies
  • 1462 views
  • 7 likes
  • 4 in conversation