Channel usage statistics

Hello,

We have a corporate account with 7 add-on channels. Is there some way to see detailed statistics on channel usage? We are considering a few more add-on channels, for extended usage and would like to make our own calculations prior to purchase.

Find more posts tagged with

Comments

AlainRoyUL

https://community.teamviewer.com/English/discussion/comment/67277#Comment_67277

Very interesting PowerShell script to estimate channels usattge, better then nothing but it missing some concept.

Indeed, a user could establish multiple connections sessions from the same computer, using only 1 channel (users are allowed 15 concurrent sessions). The Teamviewer connection report does not export source computer TeamViewer ID, but only target TeamViewer ID, so it is almost impossible to determine if the sessions are from the same computer (it could be assume that if it is the same users, it could be on the same source computer, but that could not always be true, mainly if shared accounts are used).

Also, the Teamviewer connection report is not precise enough because date and duration are rounded to minutes, not seconds. Sometimes, duration are 2 minutes while date and time sows only a minute difference. So, if an organization only have a few concurrent channels (3 by example), the powershell report compilation will sometimes indicate 2 or 3 concurrent connections while that was not really true.

Our organization has 15 concurrent channels and here is the summary for 2022:

They were a few times that connections went over 15 (to 18) but we never boosted the allowed channels.

Looking at the details of some of theses dates, we identified a single user doing simultaneously 10 concurrent sessions to 10 distinct computers on one of these dates. Also, on another date, the were a single account that established 5 concurrent sessions for more than 48 hours.

So, it is still very difficult to determine the number of Team Viewer channels really needed.

Now in 2022, more than 5 years from beginning of this thread, still needed a native history report Channel usage from TeamViewer!

chrismz

https://community.teamviewer.com/English/discussion/comment/67277#Comment_67277

Hello DBubbs,

your PowerShell script gets me the right output, but how do I get such a nice graph with red peaks and no connection as zero?

With Excel and XY line diagrams I get this

kinji5

I am sorry, can you explain in more detail how this script works?

I copied the script and put it in Powershell ISE with the connectionreport.csv file.. when i right clicked on the ps script it created the output file but nothing is in it.

Synx_Mobile

Worked Great for me, thanks for this!

DBubbs

Hey guys

None of the solusions above gave us data that we could work with so we have created a PowerShell script.

#!/usr/bin/env pwsh
$times = @{}
Import-Csv "connectionreport.csv" -Delimiter ";" | ForEach-Object {
  $connection = $_
@(0..$connection.Duration) | ForEach-Object {
    $cTime = ([DateTime]$connection.Start).addMinutes($_)
    if ($times[$cTime]) {
      $times[$cTime].count += 1
    } else {
      $times[$cTime] = [PSCustomObject]@{ count = 1; time = $cTime }
    }
  }
}
$alltimes = $times.keys | ForEach-Object { $times[$_] } | Sort-Object -Property time | Export-Csv output.csv -NoTypeInformation

Simply place the connectionreport.csv into the same folder as the script, run the script and it will then spit out output.CSV

A file which shows how many connections are active at each minute.
(If there are no connections, there will be no line for that minute.)

From here you will be able to turn it into a nice graph!

alexschittko

Don't mean to necro here, but the feature is still missing a year later.

Today I was presented with my renewal options. As an IT Manager, I'd like to see how many concurrent sessions I have at any point in time, so I can make an educated decision about how many channels to purchase for the next three years. I have 15 channels, never do I get a report from my users that they're out of channels. Are we at the sweet spot? Are we overpaying? The world may never know until I use @LUR 's python script to piece this together.

I think not integrating the feature is a purposeful move on TeamViewer's part to continue having customers take the easy route and overpay.

This data would be very helpful if provided easily in the management console and allow the sales process to move faster for those who want the data, like myself.

LUR

having to rerun this two months later, I find that I needed to first:

import datetime form datetime
import timedelta from datetime
import csv

I also had to make sure the input file, connectionreport.csv, actually used commas instead of semicolons as field separator -- maybe this is a setting in the teamviewer connection report setting somewhere, but whatever the case, I found my csv was using german style ; instead of english style ,

LUR

I had similar need, following python script reads in the connection report CSV and outputs a temporary CSV to ingest into Excel, from which you can produce a pivot and then a chart showing how many licenses were in use at a given minute of an hour of a month. Appologies to those who know python, this was my first real effort.

You'll need to import datetime timedelta and csv if I recall correctly

with open(r't.csv','wt') as o:
	with open(r'connectionreport.csv') as f:
		f_csv = csv.reader(f)
		headers = next(f_csv)
		o.write('Date Time, Count, User\n')
		for row in f_csv:
			y = datetime.strptime(row[4], '%Y-%m-%d %H:%M')
			u = row[0]			   
			for n in range(0, int(row[6])):
				z = y + timedelta(minutes = n)
				s = z.strftime('%Y-%m-%d %H:%M')	   
				o.write(s + ", 1, " + u + "\n")

Katharina

Hi mbornestav,

Thank you for your post!

While we do not provide any specific statistics on channel use, there are several ways of evaluating whether you are using your channels to capacity and whether you would therefore benefit from expanding your licence.

You can always check how many of your channels are occupied at a given moment via "Help > About TeamViewer > Channel use" (available on Windows computers). This will open a new window which will display the IDs that are having a session at that moment. If you check this regularly, it should give you a good impression of how many of your channels are generally in use and which workstations/users are most active.

If you have created a company profile, you can also take a look at your connection reports. The connections established by the users who are part of your company profile are all stored in the connection reports. The reports will tell you who connected to whom and at which time. That is why they will also give you an overview of how many people are generally connecting at the same time.

I hope this information will help you with your calculations.

If you have any further questions, please don't hesitate to let me know.

All the best,

Katharina