JSON
We can convert kismet log files to JSON format
using the kismetdb_dump_devices tool.
Let’s try it out.
We’ll use the kismetdb_dump_devices command,
and the in flag to specify our kismet log file,
the out flag to set our output file,
and skip-clean to skip the SQL vacuum command.
Many of the Kismet export tools run the SQL VACUUM command
to optimize the sqlite database before exporting data from it.
This process involves rewriting the log file
and therefore requires write access to that log file.
If we don’t have write access, we can run the export tool with sudo
or with the skip-clean flag.
Normally the command would return with no output.
Verbose mode displays the progress and the total devices processed.
With our captured data in JSON format, we can perform further post-processing
or data aggregation on it with other tools, such as Elastic Stack,
custom Python scripts, or jq, a sed-like tool for JSON.