Device Event Count report data in GB
I'm running report in logger for device Event Count. I want the count to be in GB just like the option totaleventcount_GB but I'm error if I'm using the same option in logger report.
In esm we have totaleventlength_GB option to get the count in GB but in logger I cant able to find that kind of option to get the count in GB.
Query is like this.
SELECT DATE(events.arc_eventTime) "Time",
events.arc_deviceAddress "Device Address",
events.arc_deviceHostName "Device Hostname",
events.arc_deviceVendor!='ArcSight' AND events.arc_deviceVendor IS NOT NULL
GROUP BY DATE(events.arc_eventTime), events.arc_deviceProduct, events.arc_deviceAddress,events.arc_deviceHostName
ORDER BY DATE(events.arc_eventTime)
Can someone help me in getting event count in GB for report or any other option we can try in logger to get the same results.
U Sai Prasad