Subversion Repositories computer_asset_manager_v1

select 
   device.name 'Device',
   attrib.name 'Attribute',
   device_attrib.value 'Value'
from 
   device_attrib 
   join attrib using (attrib_id) 
   join device using (device_id) 
   join device_type using (device_type_id)
where 
   device_type.show_as_system = 'Y'
   and device_attrib.removed_date is null 
   and device.removed_date is null 
   and attrib.removed_date is null
order by 
   device.name,
   attrib.name
limit 100;