Subversion Repositories computer_asset_manager_v1

select 
   device.name,
   network.interface,
   network.mac,
   network.address 
from 
   network join device using (device_id) 
where 
   network.removed_date is null 
   and device.removed_date is null 
   and mac <> 'fe:ff:ff:ff:ff:ff' 
order by device.name