| 1 |
rodolico |
1 |
select device.name Device,
|
|
|
2 |
pci_device.slot "PCI Slot",
|
|
|
3 |
date(pci_attribute.added_date) "Attr Added",
|
|
|
4 |
attrib.name "Attribute",
|
|
|
5 |
description "Value"
|
|
|
6 |
from pci_device join pci_attribute using (pci_device_id)
|
|
|
7 |
join device using (device_id)
|
|
|
8 |
join attrib using (attrib_id)
|
|
|
9 |
where pci_attribute.removed_date is null
|
|
|
10 |
and pci_device.removed_date is null
|
|
|
11 |
|
|
|
12 |
/* get list of pci devices for a system */
|
|
|
13 |
'select device_attrib.value Slot,
|
|
|
14 |
device.name Card
|
|
|
15 |
from device join device_attrib using (device_id)
|
|
|
16 |
join attrib using (attrib_id)
|
|
|
17 |
where part_of = <device_id>
|
|
|
18 |
and attrib.name = \'Slot\'
|
|
|
19 |
and device.removed_date is null
|
|
|
20 |
order by device_attrib.value'
|
|
|
21 |
|
|
|
22 |
|