straderw

Comments

  • Well I figured out the SQL Query to make the numbers match and I can adjust for the start/end of a week. Apparently I wasn't taking into account that the timestamps in the InterfaceTraffic table are in UTC. Then when SW reports, it semi adjusts to the Time Off Set... So this query works: SET DATEFIRST 7; -- 1=Monday,…
    in Help with how Network Volume Is Calculated Comment by straderw September 2022
  • Grrr... let me post this dagnabit.... Custom Custom Table baed2e37-b55d-4320-8ec3-c78d5f5adb66 00000000-0000-0000-0000-000000000000 Left Timestamp System.DateTime DateTime NotSpecified false false false true false true false Timestamp Interfaces.Traffic Interface Traffic History…
    in Help with how Network Volume Is Calculated Comment by straderw September 2022
  • Well in the end I will be using all of the fields I currently have in the query in my report. It is just the Total In Volume and Total Out Volume that isn't adding up correctly.
    in Help with how Network Volume Is Calculated Comment by straderw September 2022
Default Avatar