Subversion Repositories computer_asset_manager_v1

Rev

Rev 31 | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
31 rodolico 1 
select
2 
   network_id,
3 
   network.device_id,
4 
   device.name 'Server',
5 
   interface,
6 
   address,
7 
   netmask,
8 
   mac
9 
from
10 
   network join device using (device_id)
11 
where
12 
   network.removed_date is null
13 
   and device.removed_date is null
14 
   and network.interface not in ('lo')
15 
   and interface not like 'tun%'
16 
order by
17 
   device.name,
18 
   interface
19 
;