Written by

Question Nezla · Feb 29, 2024

List of workstations

Hi Guys,

How to get a list of workstations (machines) connected to the Server?

Thanks

Product version: Ensemble 2018.1

Comments

Robert Cemper · Mar 1, 2024
  • Namespace %SYS
  • class SYS.Process is your friend
  • SELECT * FROM SYS.PROCESS
  • in your case :  
    select CurrentDevice from SYS.Process groupby CurrentDevice
    CurrentDevice
     
    //./NUL
    |TCP|1972
    |TCP|1972|7868
    |TCP|1972|7104
    |TCP|1972|19332
    |TCP|1972|9316
    |TCP|1972|12932
    |TCP|1972|17224
    |TCP|1972|8096

    10 row(s) affected

  • .
  • for more details
    select Pid,CurrentDevice,ClientNodeName,ClientIPAddress  from SYS.Process 

     

USER>w $ZV
Cache for Windows (x86-64) 2018.1.7

0