Question
· Feb 29

List of workstations

Hi Guys,

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

 

Thanks

Product version: Ensemble 2018.1
Discussion (2)2
Log in or sign up to continue
  • Namespace %SYS
  • class SYS.Process is your friend
  • SELECT * FROM SYS.PROCESS
  • in your case :  
    select CurrentDevice from SYS.Process group by 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