Details |
Last modification |
View Log
| RSS feed
| Rev |
Author |
Line No. |
Line |
| 40 |
rodolico |
1 |
select
|
|
|
2 |
device.name,
|
|
|
3 |
network.interface,
|
|
|
4 |
network.mac,
|
|
|
5 |
network.address
|
|
|
6 |
from
|
|
|
7 |
network join device using (device_id)
|
|
|
8 |
where
|
|
|
9 |
network.removed_date is null
|
|
|
10 |
and device.removed_date is null
|
|
|
11 |
and mac <> 'fe:ff:ff:ff:ff:ff'
|
|
|
12 |
order by device.name
|