Report to track EPS spikes per device
Hi all, I need to create a report to track the spikes of the messages coming from the devices. In another post I've found the following Table - Category Counts Fields - ((DeviceAddress, DeviceHostName, sum(Count1)) SQL filter - CategoryType=200 Which is the meaning of CategoryType=200 ? Is there a list of all possible value of CategoryType ? Thanks Amelia
Hi Amelia, it's not exactly a report but more a command line usage that will answer your needs: lsdata –time day now –devices * -statistics TotalsByDeviceType > e:\statistics.txt will return a nice table stating the device statistics (ordered by device types), note that this is a 1 day statistics you can change it to -7d for example to get statistics of 1 week lsdata –time day now –devices * -statistics TotalsByDevice > e:\statistics_per_device.txt and this one is the same only it separates the data per device instead of per device type. run it from D-Srv if you have LS or from ES command line.