SOTI Pulse Logo

Telecom Expense Management Rule - Data Usage

Solved
CR
Chris R.
SkyBitz - End User

Hi,

I have enabled a Telecom Expense Management Rule and have a question around the data produced.  I'm looking creating my own custom report for this and am querying the DB directly.  When I look at the DeviceStatNetTraffic table, there are Upload and Download columns.  Does anyone know what data storage type these numbers represent?  I'm assuming it would be either bytes or kilobytes.

For instance if I look at the query below, I have a piece of data for the Soti Surf app collected over an 8 hr period.  If I assume that the values in the Upload and Download columns are kilobytes of data, I would have a total of 22.4MB of upload and 324.6MB of download for an 8 hr period for just Soti Surf.  This seems high to me based on the websites that are allowed in our whitelist so I want to make sure I'm understanding this correctly.

DeviceId Application TimeStamp StatType Upload Download 100001227 net.soti.surf 3/9/201813:02    -16 757530 10979988 100001227 net.soti.surf 3/9/2018 14:32 -16 1767570 25619972 100001227 net.soti.surf 3/9/2018 15:03 -16 757530 10979988 100001227 net.soti.surf 3/9/2018 15:30 -16 1767570 25619972 100001227 net.soti.surf 3/9/2018 16:00 -16 505020 7319992 100001227 net.soti.surf 3/9/2018 17:00 -16 757530 10979988 100001227 net.soti.surf 3/9/2018 17:32 -16 1262550 18299980 100001227 net.soti.surf 3/9/2018 18:00 -16 252510 3659996 100001227 net.soti.surf 3/9/2018 18:32 -16 1262550 18299980 100001227 net.soti.surf 3/9/2018 19:01 -16 2777610 40259956 100001227 net.soti.surf 3/9/2018 19:30 -16 757530 10979988 100001227 net.soti.surf 3/9/2018 20:01 -16 2525100 36599960 100001227 net.soti.surf 3/9/2018 20:33 -16 5050200 73199920 100001227 net.soti.surf 3/9/2018 21:00 -16 3282630 47579948
database telecom
Edited 7 years ago
Android
ANSWERS
SS
Support Staff Account
7 years ago (edited 7 years ago)

Hi Chris, 

Your calculation of what has uploaded and downloaded looks to be correct from what was reported, as the data is in bits. 

*Correction* New information from our developers that this data is captured in bytes

However that being the case, inaccuracy's occur nonetheless as the Telecom Expense Data collection methods produce "best effort" results, when calculating actual device data usage.   See the actual verbiage from the help document below. 

Note: The telecom data collected by this rule may differ from the data collected by your telecommunications provider. Telecom expense management rules are intended only as supplementary tools.

If you feel that the data that has been collected, is grossly inaccurate, please submit a case at Support@soti.net.  That way we can work with you regarding the inconsistencies you may be experiencing with this TEM data.

                                                                                                                            

Regards, 

Solution

Similar Discussions