Subversion Repositories computer_asset_manager_v1

select device.name Device,
       pci_device.slot  "PCI Slot",
       date(pci_attribute.added_date) "Attr Added",
       attrib.name "Attribute",
       description "Value"
from pci_device join pci_attribute using (pci_device_id) 
     join device using (device_id) 
     join attrib using (attrib_id)
where pci_attribute.removed_date is null
      and pci_device.removed_date is null

/* get list of pci devices for a system */
'select device_attrib.value Slot,
       device.name Card
from device join device_attrib using (device_id)
     join attrib using (attrib_id)
where part_of = <device_id>
      and attrib.name = \'Slot\'
      and device.removed_date is null
order by device_attrib.value'