Hot!VPN report hours per day

Author
gy14
New Member
  • Total Posts : 10
  • Scores: 0
  • Reward points: 0
  • Joined: 2020/03/23 10:14:00
  • Status: offline
2020/12/02 11:34:43 (permalink)
0

VPN report hours per day

I am not a query guy so this has been difficult to understand, and i haven't found a canned one to do what i want.
 
I'm trying to create a report that will show say a specific user over the last 30 days but instead of aggregate time, how much time spent connected each day.  Powers that be want to see, 8+ hrs each day or if they were skipping out early on fridays.
 
something like
user1      MM/DD/YY  07:59
user1      MM/DD/YY   08:00
user2      MM/DD/YY    04:30
 
I have searched google and these forums but haven't gotten anything to work, possibly my version is newer than the commands i'm trying.  6.2
 
am i missing a canned one that does this? and overthinking.  or i definitely need a new dataset?
any thoughts are appreciated.
 
#1

1 Reply Related Threads

    gy14
    New Member
    • Total Posts : 10
    • Scores: 0
    • Reward points: 0
    • Joined: 2020/03/23 10:14:00
    • Status: offline
    Re: VPN report hours per day 2020/12/03 09:48:45 (permalink)
    0
    This got me most of the way there.  showing multiple days for individual users and remote IP.  now i want to add the duration to those days.
     
     
    select from_dtime(dtime) as date, `user`, tunneltype, action , remip from $log where (tunneltype = 'ssl-tunnel') and action = 'tunnel-up' order by date desc
    #2
    Jump to:
    © 2021 APG vNext Commercial Version 5.5