topic Re: Find work of a specific Metadatauser in Administration and Deployment

Find work of a specific Metadatauser

Criptic — Wed, 20 Sep 2017 09:42:55 GMT

Hey,

I want to find the work directory of a specific user. I'm on SAS 9.4M2 and AIX 7.1. I have access to the directory on AIX where all the work directories are stored and I can see names like this one:

/work/SAS_work591503DB00F0_cdb2/SAS_workC10603DB00F0_cdb2 - This is my current work for example.

Is there a way to match this folder to my metauser?

Kind regards

David

P.S. I know about %sysfunc(getoption(work)) but I'm looking for something where I can add the parameter of a userId or proc options option=work;

Re: Find work of a specific Metadatauser

nhvdwalt — Wed, 20 Sep 2017 10:03:10 GMT

Depending on how your security is set up, the AIX user that owns that folder will be the user that's running the SAS jobs.

Re: Find work of a specific Metadatauser

Criptic — Wed, 20 Sep 2017 10:04:56 GMT

Thank you for your response.

Sadly the owner of the workfolder is a technical users, as the SAS-Users don't have profiles on the AIX

Re: Find work of a specific Metadatauser

nhvdwalt — Wed, 20 Sep 2017 10:14:30 GMT

Ok, try this....Its a bit manual, but it should do the trick...

Look at the name of the workspace directory and get the PID of the SAS process. In this case you will convert 00F0 from hex to decimal and get a process ID of 240. Look up this PID in the Object Spawer log to see if you can figure out for which client it was created. You might see the requesting client is the Technical User, but should also be able to get the SAS application and IP address that made the request.

Re: Find work of a specific Metadatauser

nhvdwalt — Wed, 20 Sep 2017 10:48:07 GMT

If you have Workspace Server logging enabled (that includes the PID in the log file name) you could also look at the %LET _CLIENTUSERID = 'xxx' value that SAS Enterprise Guide writes to the log. That could also help...

Re: Find work of a specific Metadatauser

alexal — Wed, 20 Sep 2017 11:00:41 GMT

@Criptic,

When you invoke SAS, it assigns the Work libref to a subdirectory of the directory specified in the WORK system option described in WORK System Option: UNIX. This subdirectory is usually named SAS_workcode_nodename, and has the following characteristics:

workcode
is a 12-character code. The first four characters are randomly generated numbers. The next eight characters are based on the hexadecimal process identification number of the SAS session.

nodename
is the name of the UNIX computer where the SAS process is running.

Re: Find work of a specific Metadatauser

Criptic — Wed, 20 Sep 2017 11:15:09 GMT

Thank you. This is perfect for what I'm trying to do.

Re: Find work of a specific Metadatauser

alexal — Wed, 20 Sep 2017 11:16:02 GMT

@Criptic,

You are welcome!

Re: Find work of a specific Metadatauser

Criptic — Wed, 20 Sep 2017 11:16:24 GMT

Thank you again for your time. I'm accepted a different answer as my solution as it was way easier to automate but thank you again for the effort and response!

Re: Find work of a specific Metadatauser

boemskats — Fri, 22 Sep 2017 08:04:57 GMT

Hi @Criptic

Sadly the owner of the workfolder is a technical users, as the SAS-Users don't have profiles on the AIX

You may want to take a look at this thing I wrote a few months ago - there's a mechanism for identifying SASWORK users by their Metadata ID: https://github.com/Boemska/worktop. I have a commit pending that removes the dependency on bash and runs standalone in ksh, in case you don't have bash installed on your environment.

Obviously ESM also does this very nicely, and we support AIX 7.

Hope this helps.

Nik

Re: Find work of a specific Metadatauser

Criptic — Fri, 22 Sep 2017 08:09:19 GMT

Thank you for your reply.
I ran across your tool in another post on the forum. Your tool looks great but it is complete overkill for what I'm trying to achieve here.

Re: Find work of a specific Metadatauser

boemskats — Fri, 22 Sep 2017 08:17:15 GMT

Fair - I had to mention it 🙂

If you're scripting have a look at this bit of worktop specifically as it's one mechanism for metadata user identification at filesystem level:

https://github.com/Boemska/worktop#3-update-your-workspace-server-config

Nik

Re: Find work of a specific Metadatauser

ronan — Fri, 22 Sep 2017 14:15:16 GMT

Using the information provided above by @alexal and the SMC, Server plug-in monitoring feature, you can retrieve the information and join manually SAS Session PID and Work path :

https://support.sas.com/documentation/cdl/en/bisag/68240/HTML/default/viewer.htm#p0o497lmygjfrfn0z7t999n72tpg.htm

Automating this join shouldn't be unfeasible either :

https://blogs.sas.com/content/sasdummy/2016/02/15/using-proc-iomoperate/