1[% USE CSV -%] 2[% USE date(format = '%Y-%m-%d %H:%M') %] 3[% IF opt %] 4 [% CSV.dump(['Domain' 'Node' 'Name' 'User' 'First Seen' 'Last Seen']) %] 5 6 [% FOREACH row IN results %] 7 [% mylist = [] %] 8 [% device = row.device.dns || row.device.name || row.device.ip %] 9 [% FOREACH col IN [ row.domain row.mac.upper row.nbname row.nbuser date.format(row.time_first) date.format(row.time_last) ] %] 10 [% mylist.push(col) %] 11 [% END %] 12 [% CSV.dump(mylist) %] 13 14 [% END %] 15[% ELSE %] 16 [% CSV.dump(['Domain' 'Count']) %] 17 18 [% FOREACH row IN results %] 19 [% mylist = [] %] 20 [% domain = row.domain || '(Blank Domain)' %] 21 [% FOREACH col IN [ domain row.count ] %] 22 [% mylist.push(col) %] 23 [% END %] 24 [% CSV.dump(mylist) %] 25 26 [% END %] 27[% END %] 28