I am searching the _internal index to find out how much data a universal forward is sending per day.
Here is my code (taken from settings>Monitor Console> Forwarders: Instance "Outgoing Data Rate" dashboard)
`dmc_get_forwarder_tcpin` hostname=SomeNAME
| `dmc_timechart_for_metrics_log` sum(eval(tcp_KBps)) as "KB/s", max(tcp_eps) as "Events/s"
Does anyone know the correct syntax to convert this to GB/day?
This is my attempt below, is this correct and accurate? I don't think so... looks like I need to sum all the data.
`dmc_get_forwarder_tcpin` hostname=SomeName
| `dmc_timechart_for_metrics_log` max(eval(tcp_KBps/1024/1024/60/60/24)) as "GB/day", max(tcp_eps) as "Events/s"
Thanks
Give this a try
`dmc_get_forwarder_tcpin` hostname=SomeNAME
| timechart span=1d sum(eval(tcp_KBps)) as "GB/day", max(tcp_eps) as "Events/s"
| eval "GB/day" = 'GB/day'/1024/1024
I'd be surprised if either of those was right.
In the first one, you are summing a tcp_KBps field across some time range (bin size unknown), so it's no longer in KB/s, its in KB/bin time. You probably want avg rather than sum, but if it's sum you want, then change legend to KB.
In the second one, your conversion looks okay, but it's not clear what information you want as "GB/day". Are you trying to find out how many GB you are actually forwarding per day, or how many you would forward if it maintained that rate round the clock?
As a general case, I would put multiplication to the left of the dividing slash, and division to the right. I would also get used to the numbers 86400 (24*60*60) and 2440 (24*60) , which you will be using a lot.
`dmc_get_forwarder_tcpin` hostname=SomeName
| `dmc_timechart_for_metrics_log` max(eval(tcp_KBps)) as Max_KBps, max(tcp_eps) as "Max Events/s"
| eval "Max GBpd (est)" = Max_KBps*86400/(1024*1024)
Yes I see Somesoni's reply. Thank you for your comments, and my code was completely off, but you have highlighted some concepts I need to keep in mind. Thank you.
See somesoni2's version also, which bins by day and calculates ACTUAL GB per day.
Give this a try
`dmc_get_forwarder_tcpin` hostname=SomeNAME
| timechart span=1d sum(eval(tcp_KBps)) as "GB/day", max(tcp_eps) as "Events/s"
| eval "GB/day" = 'GB/day'/1024/1024
Thank you, I believe you got it.
Actually, looks like something is still not quite right with the conversion. But | timechart span=1d is getting me closer.
Thank you
Its gotta be correct per your logic, its just hard to verify because I have so many fwdrs.