BookmarkSubscribeRSS Feed
mikesatriaevo
Fluorite | Level 6

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
7 REPLIES 7
LinusH
Tourmaline | Level 20

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
mikesatriaevo
Fluorite | Level 6

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.

LinusH
Tourmaline | Level 20

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

Data never sleeps
mikesatriaevo
Fluorite | Level 6

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

LinusH
Tourmaline | Level 20

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
saikrishna
Fluorite | Level 6

Hi ,

Please can you refer any document to details  1 and 2

shivas
Pyrite | Level 9

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

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 7 replies
  • 4199 views
  • 7 likes
  • 4 in conversation