Databases
StackOverflow2013
Postsdbo
POHow can I kick out the longest inactive user from a remote machine using powershell 1?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow can I kick out the longest inactive user from a remote machine using powershell 1?
    primarykey
    data
    text
    <p>I need to find an easy way to kick off teammates from a server if they forget to log out. Our terminal service has a limit of 2 connections. I wrote the following function to get the logged in users. As I understand in powershell 2 there are nicer ways to do this but I am stuck with version 1 for now. </p> <p>The following function will get me the logins per server. (If you know a prettier way to do this feel free to educate me. :) I am not happy with the func and hoping learn a few tricks from you.)</p> <pre><code>function get-terminal-users($serverName) { $path = "C:\ntui\source\i386" cd -path $path $result = invoke-expression -Command ".\quser.exe /SERVER:$serverName" | select -Skip 1 $a = @() foreach($row in $result) { $d = new-object Object $columns = $row.Replace(" ", " ").Split(" ") | ? {$_ -ne ""} $d | add-member -membertype noteproperty -name UserName -value $columns[0] $id = -1 $sessionName = "" $columShift = 0 #this part was not ok and needed fixing. Thanks Winfred for the answer! if([system.int32]::tryparse($columns[1].ToString(),[ref] $id)) { $columShift -- } else { $sessionName = $columns[1] $id = [system.int32]::parse($columns[2].ToString()) } $time = [DateTime]::Parse($columns[5 + $columShift] + " " + $columns[6 + $columShift]) $d | add-member -membertype noteproperty -name SessionName -value $sessionName $d | add-member -membertype noteproperty -name ID -value $id $d | add-member -membertype noteproperty -name State -value $columns[3 + $columShift] $d | add-member -membertype noteproperty -name Idle -value $columns[4 + $columShift] $d | add-member -membertype noteproperty -name Time -value $time $a += $d } return $a } </code></pre> <p>So I need the list if users and then I have to kick one guy out if the connection count is higher than the allowed maximum. If you know a way to get this info from the server I would really appreciate your help. </p> <pre><code>$name = "myserver" $maxConnections = 2 $users = get-terminal-users($name) if($users.Count -eq $maxConnections) { $idList = $users | ? { $_.State -eq "Disc" } | select -First 1 | foreach { $_.ID } foreach($id in $idList) { invoke-expression -Command ".\logoff.exe /SERVER:$name $id -V" } } </code></pre> <p>The issue is that I can only interact with Active connections. Abandoned connections are still use up the available connections and I don't seem to be able to do much about them. A user with a Disc status seems to use up a terminal connection and when I call logoff on its id for some reason a local process is terminated. Is there a way to get rid of Disc connections? </p> <p>rwinsta.exe also seems to only work with active connections. </p> <p>I am running the script on XP and targeting a Win 2003 server.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USthe Tin Man
    1. USJeno Laszlo
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POHow can I kick out the longest inactive user from a remote machine using powershell 1?
      1. USJeno Laszlo
      1. VTBountyStart
    2. VO
      singulars
      1. POHow can I kick out the longest inactive user from a remote machine using powershell 1?
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POHow can I kick out the longest inactive user from a remote machine using powershell 1?
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload