Subversion Repositories computer_asset_manager_v1

select 
   network_id,
   network.device_id,
   device.name 'Server',
   interface,
   address,
   netmask,
   mac
from
   network join device using (device_id)
where
   network.removed_date is null
   and device.removed_date is null
   and network.interface not in ('lo')
   and interface not like 'tun%'
order by
   device.name,
   interface
;