Community discussions

MikroTik App
 
manojlovicl
Frequent Visitor
Frequent Visitor
Topic Author
Posts: 50
Joined: Mon Aug 18, 2014 11:48 pm

Export data (time interval) to table

Sun Oct 13, 2019 10:53 am

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
 
manojlovicl
Frequent Visitor
Frequent Visitor
Topic Author
Posts: 50
Joined: Mon Aug 18, 2014 11:48 pm

Re: Export data (time interval) to table

Tue Oct 15, 2019 12:43 pm

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
 
zandhaas
Frequent Visitor
Frequent Visitor
Posts: 73
Joined: Tue Dec 11, 2018 11:02 pm
Location: The Netherlands

Re: Export data (time interval) to table

Tue Oct 15, 2019 1:31 pm

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/461 ... -via-excel
 
fjhdez
just joined
Posts: 1
Joined: Tue Nov 24, 2020 8:42 pm

Re: Export data (time interval) to table

Tue Jul 13, 2021 2:20 pm

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.

Who is online

Users browsing this forum: No registered users and 14 guests