Forum Discussion

BSCHNEIDER's avatar
BSCHNEIDER
Regular Visitor
3 years ago

Connection Report - counting users at any given time

I have a list of users that are connecting to TeamViewer.  We have a limited number of lisences that is based on how many users are active at any given time.  I have the log on and log off times for ...
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

What's your sampling rate?  Do you need this by hour?  by minute?

 

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

BSCHNEIDER's avatar
BSCHNEIDER
Regular Visitor
3 years ago

Really appreciate your help/time on this one...  I'm not sure exactly...  I might need a bit of guidence on how I can/should display this.  In my head, I think maybe the max user count per day/week (at a given time) might be most appropriate.  Basically we have a limited number of licenses for an app.  We can see who is logged on and when.  We need to see how close we are to going over our alloted users at any given time (max 10).  We will required new group licenses if we go over our limit.  Here are examples of the data received:

 

IDSession typeStartEnd
1053809758Remote Control5/22/2023 8:305/25/2023 12:26
861936026Remote Control5/23/2023 14:085/26/2023 17:02
861329830Remote Control3/17/2023 7:333/20/2023 9:20
1531804798Remote Control3/17/2023 7:343/20/2023 9:07
861329830Remote Control5/12/2023 9:215/15/2023 8:00
1030018397Remote Control8/8/2023 9:338/11/2023 6:43
1531804798Remote Control7/14/2023 11:137/17/2023 8:02
1642777017Remote Control7/14/2023 11:177/17/2023 7:53
1897949114Remote Control8/4/2023 15:518/7/2023 8:55
1442553765Remote Control6/16/2023 13:116/18/2023 23:18
1053809758Remote Control5/15/2023 11:495/17/2023 13:59
1159315116Remote Control8/16/2023 15:198/18/2023 16:02
615316499Remote Control5/18/2023 20:485/20/2023 14:05
615316499Remote Control3/13/2023 1:593/14/2023 19:08
950952136Remote Control6/9/2023 14:156/11/2023 6:42
1413405182Remote Control6/16/2023 16:556/18/2023 5:14
1531804798Remote Control2/15/2023 7:102/16/2023 18:03
1053809758Remote Control8/3/2023 8:028/4/2023 16:59
1642777017Remote Control6/1/2023 7:456/2/2023 14:30
861329830Remote Control3/15/2023 7:153/16/2023 13:28
1531804798Remote Control3/15/2023 7:163/16/2023 13:28