topic Re: How to extract SAS Management console information (SASApp - Workspace Server) in a dataset/file? in Administration and Deployment

How to extract SAS Management console information (SASApp - Workspace Server) in a dataset/file?

saxenp08 — Wed, 30 Nov 2022 07:07:36 GMT

Hello,

Could someone help me extract SASApp - Workspace Server information in an output dataset/file?

I have already tried PROC IOMOPERATE with sasadm@saspw connection profile. Blog: PROC IOMOPERATE

It gives information for all the active PIDs and users in a dataset (Information is available in SAS MC).

What I need further is - when clicking on an active PID, the "Properties" information of the specific user, which is available under the Clients tab (need "Hostname" to be specific). The HostName, available from PROC IOMOPERATE, differs from the Host Name present under the Properties (The Properties Host Name tells about the remote desktop information). I need this information to create a stored process which will capture information for all the active PIDs, and active users and then from which machine the user is connected to.

Thank you in advance!

Best Regards

Re: How to extract SAS Management console information (SASApp - Workspace Server) in a dataset/file?

Sajid01 — Mon, 05 Dec 2022 13:20:28 GMT

What information are you looking. Perhaps these two will help
https://blogs.sas.com/content/sasdummy/2016/02/20/proc-iomoperate-custom-task/
https://blogs.sas.com/content/sasdummy/2016/02/15/using-proc-iomoperate/

Re: How to extract SAS Management console information (SASApp - Workspace Server) in a dataset/file?

saxenp08 — Tue, 10 Jan 2023 13:43:55 GMT

Hello, and thank you for your reply.

The solutions you have suggested I have already tried (also suggested in my query). The problem is I need to capture the VDI info, which I have shared via screenshot. All the other information is available using the proc iomoperate, but only information is missing which I must extract.

Re: How to extract SAS Management console information (SASApp - Workspace Server) in a dataset/file?

andreas_lds — Tue, 10 Jan 2023 14:17:29 GMT

I don't know any way to extract the information using code. While using the old "metabrowse" in the display manager (classic sas programming tool) i wasn't able to find anything useful.

Maybe @PaulHomes or @MichelleHomes have an idea.

Re: How to extract SAS Management console information (SASApp - Workspace Server) in a dataset/file?

PaulHomes — Wed, 11 Jan 2023 05:00:49 GMT

You wouldn't normally be able to find this type of dynamic run-time information in metadata but it is available from PROC IOMOPERATE using the list clients features - see https://support.sas.com/documentation/cdl/en/biasag/62612/HTML/default/viewer.htm#n20033intelplatform00srvradm.htm

I took the sample code by @ChrisHemedinger in his blog post linked above and tweaked it to add an allclients table that contains the 3x columns provided by list clients: client (userid), peer (workstation IP address and port) and entertime.

I posted the sample code in a gist at https://gist.github.com/paulhomes/029f77032e809e2a1d8ee7a13fc52c14

Re: How to extract SAS Management console information (SASApp - Workspace Server) in a dataset/file?

PaulHomes — Wed, 11 Jan 2023 05:06:13 GMT

In my case I got back client IP addresses so if you want DNS names then maybe loop over them and do a dig or nslookup command on the IP address to get a hostname if available. I can't tell from your screenshot whether you were seeing IP addresses or hostnames in SAS Management Console - I see IP addresses in mine - exactly what I see in the ALLCLIENTS table. I would use a command like "dig +short -x 10.1.2.3" to get a hostname for the 10.1.2.3 IP address.

Re: How to extract SAS Management console information (SASApp - Workspace Server) in a dataset/file?

saxenp08 — Wed, 11 Jan 2023 10:18:40 GMT

Thank you very much for this. I will give it a try.

By the way, for me, it is not the IP address under "Hostname", though. It has the information of the remote desktop (VDI) linked to that specific process id. I will try the solution you've suggested and provide an update.

Re: How to extract SAS Management console information (SASApp - Workspace Server) in a dataset/file?

saxenp08 — Mon, 23 Jan 2023 11:03:25 GMT

Hello,

Sorry for the late update.

The solution with the list allclient works as it gives me the relevant IP address. But there is a minor issue.

It captures information for all clients but misses one client every time. The message I received in the log file is as follows:

NOTE: The LIST ATTRIBUTES command completed.
NOTE: Compression was disabled for data set WORK.CLIENTSxxx because compression overhead would increase the size of the data set.
NOTE: The data set WORK.CLIENTSxxx has 0 observations and 3 variables.

NOTE: The LIST CLIENTS command completed.

So because of this null dataset, if the active sessions from the "list attrs" is n then I am getting n-1 results from list clients.

I am working to find out why this is happening, but if you have any idea, can you please help?

Thank you!

Re: How to extract SAS Management console information (SASApp - Workspace Server) in a dataset/file?

PaulHomes — Wed, 25 Jan 2023 06:08:05 GMT

An empty clients table means that server has no clients at that time. Typically this would be a server that might live for a while after the last client disconnects. You will get this for things like the SAS Stored Process Server and SAS Pooled Workspace Server. I just replicated your scenario by having a single active workspace server session and validating the SAS Stored Process server in SAS Management Console (to ensure a server process was started). My PIDs table had 2 rows for the 2 servers (workspace and stored process) and the clients table had only 1 row for the currently connected workspace server client - the stored process server had no clients.

I suspect you are seeing something similar.

Re: How to extract SAS Management console information (SASApp - Workspace Server) in a dataset/file?

saxenp08 — Wed, 08 Feb 2023 14:59:26 GMT

Hello again,

finally, I was able to test the completed solution.

The generated report uses "allclients" and tells the information up to the "clients" level.

For Host DNS under the "client properties" level, using "dig +short -x IP" works to get a hostname for the active IP address.

Thank you very much for all the help also addressing my other doubt regarding missing entries.

Re: How to extract SAS Management console information (SASApp - Workspace Server) in a dataset/file?

PaulHomes — Thu, 09 Feb 2023 00:22:29 GMT

It's great to hear you have it all working now. Thanks for reporting back and marking it as solved.