Subversion Repositories computer_asset_manager_v1

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
65 rodolico 1 
select
2 
   device.name 'Device',
3 
   attrib.name 'Attribute',
4 
   device_attrib.value 'Value'
5 
from
6 
   device_attrib
7 
   join attrib using (attrib_id)
8 
   join device using (device_id)
9 
   join device_type using (device_type_id)
10 
where
11 
   device_type.show_as_system = 'Y'
12 
   and device_attrib.removed_date is null
13 
   and device.removed_date is null
14 
   and attrib.removed_date is null
15 
order by
16 
   device.name,
17 
   attrib.name
18 
limit 100;