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