Querying with Winston

query-with-winston.sh

node winston.query.js | tr "[{:,'" '    ' | tr -s " " | awk '/country/ { print $2 }' | sort | uniq | wc -l | tr -s " "

Assuming a log entry of the following, retrieved with node winston.query.js:

{ file: 
   [ { timestamp: '2015-03-03T10:35:07.445Z',
       employment: 'Freelance Technical Writer',
       country: 'Germany',
       languages: [Object] },
     { timestamp: '2015-03-03T10:34:52.387Z',
       employment: 'Freelance Technical Writer',
       country: 'Germany',
       languages: [Object] } ] }

This script firsts strips out the initial [{:,, and passes the remaining text to awk, which strips out everything, except for lines containing ‘country’, and returns the country name. Finally, the list of countries is sorted, the duplicates removed, and the count of each country tallied.