Export data (time interval) to table

RouterOS The Dude
1

Hi!

I am running DUDE just to make a simple SNMP query to some device by using data source. It works great - I am getting the graph.
I would like to ask if it is somehow possible to export the raw data to csv or some other table - for example for some time interval (like between 18:30 and 22:00)?

Thank you,
Luka

2

I managed to open DB with DB Browser for SQLLite and I am able to find data but:

Does anyone know how to get date/time from sourceIDandTime column? I have value like: 130899289405392 in this column and some value in column value (which is OK). But I would like to know how to “decrypt” sourceIDandTime to normal date/time value.

Thank you,
Luka

3

I think you need an Epoch converter or some formula that converts the number of second’s to a normal date / time.
In the below thread a formula is described.

https://stackoverflow.com/questions/46130132/converting-unix-time-into-date-time-via-excel

4

Hello. The field “SourceIDandTime” is a integer. When you convert to binary the number, the 20 first digits are the sourceID and the 32 second digits are the date in timestamp format.