Exporting a list of my Computers

When I used this method a few days ago, the header line in the dump was

"remotecontrol_id","device_id","alias","groupid","online_state","policy_id","assigned_to","last_seen","teamviewer_id"

Today the header line is

 "remotecontrol_id","device_id","alias","groupid","online_state","policy_id","assigned_to","supported_features","teamviewer_id"

What happened to the last_seen column?

Thanks, I just used the code provided above by JeanK.

I exported to both CSV and JSON, and I can see last_seen values in the JSON file. I think the difference is that there's no value for it in the first "row". I suspect the Export-Csv cmdlet ignores fields with names that aren't in the first row.

@JeanK I don't know how old your solution is but tried it just now and I was able to dump the data I needed for our organization. Thanks!

Hello @JeanK

I've been struggling for a while trying to use an API to get GROUPS information. I have managed to get the overall users script working fine and I am able to get a list of all users, however when I try to GET groups and their associated users I got some errors I couldn't find the reason.

The USERS scripts works fine and it is like that

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

$headers.Add("Authorization", "Bearer USER TOKEN Created")

$response = Invoke-RestMethod 'https://webapi.teamviewer.com/api/v1/users?full_list=true' -Method 'GET' -Headers $headers

$response.users | Select-Object -Property "name","email","last_access_date","active" | Export-Csv "C:\Users\MyUser\TV-USERSList.csv"

$response | ConvertTo-Json

However when I try to run similar script for GROUPS users

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

$headers.Add("Authorization", "Bearer OTHER Token created for GROUPS")

$response = Invoke-RestMethod 'https://webapi.teamviewer.com/api/v1/groups?name=TST' -Method 'GET' -Headers $headers

$response.groups | Select-Object -Property "id", "name", "shared_with" | Export-Csv "C:\Users\MyUser\TV-groups.csv"

$response | ConvertTo-Json

I got a BLANK .csv file however on the PowerShell screen I got the whole USERS listing even using a token created for GROUP management. Also, when running I got this error message

Invoke-RestMethod : {"error":"invalid_token","error_description":"Access token is of wrong type. You need a UserToken to call this function.","error_code":2}

At line:3 char:13

+ $response = Invoke-RestMethod 'https://webapi.teamviewer.com/api/v1/g ...

+       ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

  + CategoryInfo     : InvalidOperation: (System.Net.HttpWebRequest:HttpWebRequest) [Invoke-RestMethod], WebException

  + FullyQualifiedErrorId : WebCmdletWebResponseException,Microsoft.PowerShell.Commands.InvokeRestMethodCommand

I have also tried to run using other tokens generated without success. I also tried running from the web interface from TeamViewer at https://webapi.teamviewer.com/api/v1/docs/index#!/Group32management/Groups_Get_0 without success.

I am quite sure I am missing something very basic on the groups query but I just can't see what it is.

Hello @JeanK

I am now totally puzzled. This script, using a token created for GROUP MANAGEMENT got me output

PS H:\> $headers = New-Object "System.Collections.Generic.Dictionary[[String],[String]]"

$headers.Add("Authorization", "Bearer XXXXXXXXXXXXXXXXX")

$response = Invoke-RestMethod 'https://webapi.teamviewer.com/api/v1/groups?' -Method 'GET' -Headers $headers

$response.groups | Select-Object -Property "id", "name", "shared_with" | Export-Csv "C:\Users\local folder\TV-groups.csv"

$response | ConvertTo-Json

Invoke-RestMethod : {"error":"invalid_token","error_description":"Access token is of wrong type. You need a UserToken to call this function.","error_code":2}

At line:3 char:13

+ $response = Invoke-RestMethod 'https://webapi.teamviewer.com/api/v1/g ...

+       ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

  + CategoryInfo     : InvalidOperation: (System.Net.HttpWebRequest:HttpWebRequest) [Invoke-RestMethod], WebException

  + FullyQualifiedErrorId : WebCmdletWebResponseException,Microsoft.PowerShell.Commands.InvokeRestMethodCommand

{

  "users": [

         {

           "id": "yyyyyyyyyy",

           "name": "Kkkkk Jjjjjjj",

           "permissions": "ShareOwnGroups,ManageUsers,EditFullProfile,ViewAllConnections,ViewOwnConnections,EditConnections,DeleteConnections,ManagePolicies,AssignPolicies,AcknowledgeAllAlerts,AcknowledgeOwnAlerts,ViewAllAssets,ViewOwnAssets,Edit

AllCustomModuleConfigs,EditOwnCustomModuleConfigs,ManageSettingPolicies,AssignSettingPolicies,ManageAntiMalwarePolicies,AssignAntiMalwarePolicies,AcknowledgeAllAntiMalwareThreats,AcknowledgeOwnAntiMalwareThreats,TrustedDeviceManagement,ManageBackupPolicies,A

ssignBackupPolicies,BackupViewAndAckOwnAlerts,AllowPasswordChange",

           "active": true,

           "log_sessions": true,

           "show_comment_window": true,

           "email": "abcde.fghijk@company.com",

           "last_access_date": "2022-06-24T16:50:27Z",

           "activated_license_id": "license#",

           "activated_license_name": "Tensor Basic"

I got surprised as the GET function is for GROUP and I got the entire listing of users and the output file was blank (that makes sense as I am trying to get the Group listing).

Not sure if this does not also indicates some kind of security breach. I was not supposed to get a user list with such token right?

Thank you

Marcelo

Is there a way to do this on a Mac?

2023 and still no way to export a device list, I find this sad and pathetic. *bleep* has no issues exporting a device list.

How to find device Management, through script

Much easier, just do a "Get-TeamViewerManagedDevice" or "Get-TeamViewerDevice".

Add-TeamViewerAssignment

Add-TeamViewerCustomization

Add-TeamViewerManagedDevice

Add-TeamViewerManager

Add-TeamViewerSsoExclusion

Add-TeamViewerUserGroupMember

Add-TeamViewerUserGroupToRole

Add-TeamViewerUserToRole

Connect-TeamViewerApi

Disconnect-TeamViewerApi

Export-TeamViewerSystemInformation

Get-TeamViewerAccount

Get-TeamViewerConnectionReport

Get-TeamViewerContact

Get-TeamViewerCustomModuleId

Get-TeamViewerDevice

Get-TeamViewerEventLog

Get-TeamViewerGroup

Get-TeamViewerId

Get-TeamViewerInstallationDirectory

Get-TeamViewerLogFilePath

Get-TeamViewerManagedDevice

Get-TeamViewerManagedGroup

Get-TeamViewerManagementId

Get-TeamViewerManager

Get-TeamViewerPolicy

Get-TeamViewerPredefinedRole

Get-TeamViewerRole

Get-TeamViewerService

Get-TeamViewerSsoDomain

Get-TeamViewerSsoExclusion

Get-TeamViewerUser

Get-TeamViewerUserByRole

Get-TeamViewerUserGroup

Get-TeamViewerUserGroupByRole

Get-TeamViewerUserGroupMember

Get-TeamViewerVersion

Invoke-TeamViewerPackageDownload

Invoke-TeamViewerPing

New-TeamViewerContact

New-TeamViewerDevice

New-TeamViewerGroup

New-TeamViewerManagedGroup

New-TeamViewerPolicy

New-TeamViewerRole

New-TeamViewerUser

New-TeamViewerUserGroup

Publish-TeamViewerGroup

Remove-TeamViewerAssignment

Remove-TeamViewerContact

Remove-TeamViewerCustomization

Remove-TeamViewerDevice

Remove-TeamViewerGroup

Remove-TeamViewerManagedDevice

Remove-TeamViewerManagedDeviceManagement

Remove-TeamViewerManagedGroup

Remove-TeamViewerManager

Remove-TeamViewerPolicy

Remove-TeamviewerPolicyFromManagedDevice

Remove-TeamviewerPolicyFromManagedGroup

Remove-TeamViewerPredefinedRole

Remove-TeamViewerPSProxy

Remove-TeamViewerRole

Remove-TeamViewerSsoExclusion

Remove-TeamViewerUser

Remove-TeamViewerUserFromRole

Remove-TeamViewerUserGroup

Remove-TeamViewerUserGroupFromRole

Remove-TeamViewerUserGroupMember

Restart-TeamViewerService

Set-TeamViewerAccount

Set-TeamViewerAPIUri

Set-TeamViewerDevice

Set-TeamViewerGroup

Set-TeamViewerManagedDevice

Set-TeamViewerManagedGroup

Set-TeamViewerManager

Set-TeamViewerPolicy

Set-TeamViewerPredefinedRole

Set-TeamViewerPSProxy

Set-TeamViewerRole

Set-TeamViewerUser

Set-TeamViewerUserGroup

Start-TeamViewerService

Stop-TeamViewerService

Test-TeamViewerConnectivity

Test-TeamViewerInstallation

Unpublish-TeamViewerGroup

I used the following script and it worked like a charm :)

$jsonFile = "C:\Temp\Computers_export.json"
$csvFile = "C:\Temp\Computers_export.csv"
$tvAccessToken = Read-Host "Please type your token"

$devices = @()
$nextPaginationToken = $null

do {
$uri = "https://webapi.teamviewer.com/api/v1/devices?full_list=true"
if ($nextPaginationToken) {
$uri += "&nextPaginationToken=$nextPaginationToken"
}
$response = Invoke-RestMethod -Uri $uri -Method Get -Headers @{authorization = "Bearer $tvAccessToken"}
$devices += $response.devices
$nextPaginationToken = $response.nextPaginationToken
} while ($nextPaginationToken)

$devices | Select-Object remotecontrol_id, device_id, alias, groupid, online_state, assigned_to, policy_id, last_seen, teamviewer_id | Export-Csv -Path $csvFile -Delimiter ',' -NoTypeInformation
$devices | ConvertTo-Json | Out-File $jsonFile

The above screenshot is from excel.