I want to analyze FW logs on separate machine, but, cannot convert SQLite format into CSV for some columns.
My method is:
Download the cislogs.sbd from web server into my machine by FTP, convert the SQLite format into CSV, cook the string and make my own string adding some other information or merging lines by some rule, by my program.
Now, I found that IP data of source and destination cannot be converted properly.
I used sqlite_export.exe for this, other programs show the same result.
Is there any way to convert the log data into CSV? It must be command line operation if application is used.