Remove inactive computers

We would also very much like the feature to bulk remove retired computers. We recently reinstalled 4000 units with Windows 10, thus reinstalling teamviewer. Now, they alle are doubled in the console.

@KyleHoneycutt Brilliant!  Is this just a powershell cmdlet or do we run this from somewhere else?

@KyleHoneycutt Thanks, I'm getting the following errors when it's running through the script.  It appears to find all of the stale comptures out there, but is this error pops up for each machines:

Invoke-WebRequest : {"error":"invalid_token","error_description":"Access token does not have the required permissions
for this function.","error_code":2}
At C:\Downloads\TV_Cleanup.ps1:30 char:21
+ ...             Invoke-WebRequest -Uri "Https://webapi.teamviewer.com/api ...
+                 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidOperation: (System.Net.HttpWebRequest:HttpWebRequest) [Invoke-WebRequest], WebExc
   eption
    + FullyQualifiedErrorId : WebCmdletWebResponseException,Microsoft.PowerShell.Commands.InvokeWebRequestCommand
Deleted device: COMPUTERNAME

Unsure why the access token wouldn't have the required permissions?  We only have the one token that I set up.  Maybe I'm not using the correct API token, but I just copied it from the Design & Deploy area in the web admin.  It's the one under custom TV Host package I created.  Is that the correct token?

@KyleHoneycutt That worked!  You're a life saver and I really appreciate it.

@KyleHoneycutt I ended up posting your great solution over at the Spiceworks forums as well and linked back to here.  Hope that is OK?  If there's a way I can buy you a beer or two, please let me know. 

Here's the discussion link:  [The URL link has been removed by a moderator.]

Hi there!

Thanks a lot for providing a solution here.. :-)

I am having another issue though, regarding the comparison of the dates. I'm trying to clean out devices not seen in a year, so i modified the script to use '360' instead of '30', but i don't think that is the issue - the problem is the time/date formats. I get a lot of this error (in danish):

Could not compare "03/21/2018 00:00:00" to "søndag den 11. marts 2018". Error: "Cannot convert value "søndag den 11. marts 2018" to type "System.DateTime". Error: "Strengen blev ikke genkendt som en gyldig DateTime. Der er et ukendt ord, der starter ved indekset 0.""
At C:\Users\adm_ianfje\Documents\TeamViewer_Cleanup_Inactive_Computers_Script.ps1:31 char:25
+ if ($DateLastSeen -le $360Days)
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidOperation: (:) [], RuntimeException
+ FullyQualifiedErrorId : ComparisonFailure

I am totally new at powershell scripting, so i got no clue how to fix this. Please help. :-)

@IanFriis Hey Ian,

I'm not sure if PowerShell can convert the Danish language into a System.DateTime Object which is why you're getting that error.

The way the script works is that it gets the date string from TeamViewer and then converts that string into a DateTime object so that it can be used as a comparison operator. Without converting it, it can't compare correctly.

I think the easiest thing for you to do would be to change your local system language to English or run the Script on a server that has English as the OS language.

If that workaround isn't feasible for you just let me know and we can try to come up with another solution for you.

Hi Kyle, we are getting the same error as Ian. Our system runs in german language and we would like to keep it that way. The error we receive is:

Could not compare "03/13/2019 00:00:00" to "19.9.2018". Error: "Cannot convert value "19.9.2018" to type "System.DateTime".

i tried a little bit with converting the format but i didn´t manage to get this script running.

Thanks in advance,

Thomas

Hi,

Not sure if it still relevant but i had the same issue with the German format on my Win10 device, and after changing to the English (United states) formats the script was working correctly.

Thanks for the script I modified it so it works and all languages (I think)
Example of running the script Delete-staledevices.ps1 -token "Apikey" -staledays 150

[CmdletBinding()]
param(
    [Parameter(Mandatory=$True)] [int32]$StaleDays,
    [Parameter(Mandatory=$True)] [String] $Token = ""
)



$bearer = "Bearer",$token
$counter = 0

$header = New-Object "System.Collections.Generic.Dictionary[[String],[String]]"
$header.Add("authorization", $bearer)

$devices = (Invoke-RestMethod -Uri "Https://webapi.teamviewer.com/api/v1/devices" -Method Get -Headers $header).devices


$Days = ((Get-Date).AddDays(-$staleDays))
$Days = Get-Date $Days -Format s


ForEach($device in $devices)
{

    if ($device.online_state -eq "Offline")
    {

    $ID = $device.device_id

    $Lastseen = $device.last_seen

            if ($Lastseen -ne $null)
            {

            $LastSeen = ($device.last_seen).Split("T")[0]
           [datetime]$DateLastSeen = $LastSeen

                    if ($DateLastSeen -le $Days)
                    {

                    $counter ++

                    Invoke-WebRequest -Uri "Https://webapi.teamviewer.com/api/v1/devices/$ID" -Method Delete -Headers $header -UseBasicParsing
                    Write-Host "Deleted device:"$device.alias $counter -ForegroundColor Yellow


                    }$Lastseen = $null
            }
        }
}

Thanks for the script. How can I apply this on our teamviewer environment? 

Many thanks!

Perfect, this is working! Can I schedule this script on my teamviewer environment?

Brilliant, worked like a charm!

Sorted my own issue. If a device is currently online, the last_seen attribute is not returned

Seems that if you export an array of objects to a csv, it determines the field headers from the first array object.

Our machines do no appear in the "Groups" section on the site. They are under "Device Groups" instead. The means it uses https://webapi.teamviewer.com/api/v1/managed/devices

I've been bouncing around chatgpt and gemini to create a script that removes devices not seen in the last 90 days so excuse the syntax if it's a little long winded but it does the trick. I'm going to leave this on a sever running via task scheduler so I wanted it to log which machines are being deleted.

$token = "TOKENID" # Replace with your actual token

$bearer = "Bearer " + $token

$inactiveThreshold = (New-TimeSpan -Seconds (86400 * 90)).TotalMilliseconds # 90 days in milliseconds

$currentTime = Get-Date

$deletedDevices = @() # Array to store deleted device information

$csvPath = "C:\logs\tvdeleteddevices.csv"




$header = New-Object "System.Collections.Generic.Dictionary[[String],[String]]"

$header.Add("authorization", $bearer)




# Function to delete a device

function Remove-TeamViewerDevice {

 param (

  [Parameter(Mandatory=$true)]

  [string] $deviceId,

  [string] $deviceName,

  [string] $lastSeen

 )




  $managedDevicesUri = "https://webapi.teamviewer.com/api/v1/managed/devices/$deviceId"




 try {

  Invoke-RestMethod -Uri $managedDevicesUri -Method Delete -Headers $header

  Write-Host "Device $deviceId deleted successfully."

  $deviceObject = New-Object PSObject -Property @{

   "Device ID" = $deviceId

   "Device Name" = $deviceName

   "Last Seen" = $lastSeen

  }

  return $deviceObject

 } catch {

  Write-Host "Error deleting device ${deviceId}: " -NoNewline

  Write-Host $_.Exception.Message

  return $null

 }

}




# Initial call for devices

try {

  $managedDevicesUri = "https://webapi.teamviewer.com/api/v1/managed/devices"

 $response = Invoke-RestMethod -Uri $managedDevicesUri -Method Get -Headers $header

 if ($response.resources -ne $null) {

  foreach ($device in $response.resources) {

   $deviceName = $device.name

   $lastSeen = if ($device.last_seen -ne $null) {[DateTime]::Parse($device.last_seen).ToString("yyyy-MM-dd HH:mm:ss")} else {"Never"}

    

   # Skip online devices and devices with missing Last Seen

   if ($device.isOnline -eq $true -or $device.last_seen -eq $null) {

     continue

   }

    

   # Check if the device is inactive

   if (($currentTime - [DateTime]::Parse($device.last_seen)).TotalMilliseconds -gt $inactiveThreshold) {

    $deletedDevice = Remove-TeamViewerDevice -deviceId $device.id -deviceName $deviceName -lastSeen $lastSeen

    if ($deletedDevice -ne $null) {

     $deletedDevices += $deletedDevice

    }

   }

  }

   

  # Handle pagination if a nextPaginationToken is provided (optional)

  # ... (similar logic as before)

 } else {

  Write-Host "No devices found or empty response."

 }

} catch {

 Write-Host "Error retrieving devices: $($_.Exception.Message)"

}




# Export deletedDevices array to CSV (if any)

if ($deletedDevices.Count -gt 0) {

 $deletedDevices | Select-Object 'Device ID', 'Device Name', 'Last Seen' | Export-Csv -Path $csvPath -NoTypeInformation -Append

 Write-Host "Deleted devices list exported to $csvPath"

} else {

 Write-Host "No devices were deleted based on the current settings."

}