1[% USE CSV -%] 2[% IF opt %] 3 [% CSV.dump(['MAC' 'Company' 'Device' 'Port']) %] 4 5 [% FOREACH row IN results %] 6 [% mylist = [] %] 7 [% device = row.device.dns || row.device.name || row.switch %] 8 [% FOREACH col IN [ row.mac.upper row.oui.company device row.port ] %] 9 [% mylist.push(col) %] 10 [% END %] 11 [% CSV.dump(mylist) %] 12 13 [% END %] 14[% ELSE %] 15 [% CSV.dump(['Vendor' 'Count']) %] 16 17 [% FOREACH row IN results %] 18 [% mylist = [] %] 19 [% vendor = row.vendor || '(Unknown Vendor)' %] 20 [% FOREACH col IN [ vendor row.count ] %] 21 [% mylist.push(col) %] 22 [% END %] 23 [% CSV.dump(mylist) %] 24 25 [% END %] 26[% END %] 27