Users last logon time

[Jlochoa]

Hi Greg,
Is there a way to use (with SASSTUDIO) your code on a Metadata Server running on a separate machine?

[AhmedAl_Attar]

Hi @Jlochoa 

For any SAS Client connecting to SAS Metadata Server, the following code sholuld allow you to access what needed

/* Assign Metadata Server Options */
OPTIONS METASERVER=<metaDataServerHost>
	METAPORT=<metaDataServerPort>
	METAUSER="<metaUserId>"
        METAPASS="<metaUserPw>"
        METAPROTOCOL=bridge;

PS. Replace the values inside the <> with your site settings

You'll be connected to the metadata server, and running the %mdxxxx macros will extract the data correctly.

Hope this helps,

Ahmed

[gwootton]

A SAS Studio session runs on a Workspace Server which should already have a connection to the metadata server, however this particular program does not pull information from the Metadata Server, it reads supplied log files line by line and puts the information gathered into a series of SAS data sets.

[gwootton]

The code reads Metadata log files, so those files would need to be accessible to the SAS session. You would copy them from the Metadata Server host to the Compute tier host before running the program.