07-26-2012 03:32 AM
I have a queries pertaining getiing a full listing of user. Hereare the code i use
/* Specify the directory for the extracted metadata.*/
libname meta "C:\temp";
/* Extract identity information from the metadata.*/
/* Match the person identity to UserIDs */
from meta.Person as a,meta.Logins as b
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.
07-26-2012 04:35 AM
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?
07-26-2012 04:45 AM
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.
07-30-2012 06:54 AM
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.
07-26-2012 04:46 AM
Check this link for login and other details of metadata.Hope this helps.