Ad Widget

Collapse

How to export monthly report only weekday and working hours

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • darklord20k
    Member
    • Dec 2017
    • 32

    #1

    How to export monthly report only weekday and working hours

    Hi everyone,

    I'm using zabbix 4.2.1, MySQL MariaDB 15.
    I want to creat report about bandwidth utilization (min, max, average, 90th percentile) of whole month but only calculate in working hours (8h-18h, monday to saturday, 1-30).
    I just expect collecting data to creat excel table below, but graph is awesome!
    I think it possible to do by query direct from database but I'm newbie with Database and MySQL so I don't know how to do, please help me!

    Thank you for any support!

    Click image for larger version

Name:	2019-06-19_17-49-48.png
Views:	416
Size:	6.0 KB
ID:	380980
  • darklord20k
    Member
    • Dec 2017
    • 32

    #2
    please help me!

    Comment

    • vireak
      Junior Member
      • May 2024
      • 11

      #3
      Hi mate, do you already found the answer yet? i am also looking for this

      Comment

      Working...