Subversion Repositories computer_asset_manager_v2

select

   attribute_category.name category,

   attribute.name attribute,

   attribute_value.value

from

   attribute_value

   join attribute using (attribute_id)

   join attribute_category using (attribute_category_id)

where 

   1=1

   and attribute.display_in_summary

   and attribute_value.removed is null

   and entity_id = 164

   and _base_class_id = 3

order by

   attribute_category.sort_order,

   attribute_category.name,

   attribute.sort_order,

   attribute.name,

   attribute_value.value

;

Block Devices

Memory

CPU

Physical

General (Note, Alias, Operating System, Location)

insert into attribute_category (name,sort_order) values ( 'General', 10 );

insert into attribute_category (name,sort_order) values ( 'Block Devices', 50 );

insert into attribute_category (name,sort_order) values ( 'Memory', 40 );

insert into attribute_category (name,sort_order) values ( 'Processor', 30  );

insert into attribute_category (name,sort_order) values ( 'Physical', 20 );

update attribute set attribute_category_id = (select attribute_category_id from attribute_category where name = 'Block Devices' ) where name like '/dev/%';

update attribute set attribute_category_id = (select attribute_category_id from attribute_category where name = 'Power' ) where name like 'Power%';

update attribute set attribute_category_id = (select attribute_category_id from attribute_category where name = 'Memory' ) where name like 'Memory%';

update attribute set attribute_category_id = (select attribute_category_id from attribute_category where name = 'Processor' ) where name like 'CPU%';

update attribute set attribute_category_id = (select attribute_category_id from attribute_category where name = 'Processor' ) where name like 'Enclosure%' or name like 'Firmware%' or name = 'Manufacturer' or name = 'Model' or name = 'Serial Number' or name = 'UUID';

alter table attribute add sort_order int unsigned not null default 100;

update attribute_category set sort_order = 10 where name = 'General';

update attribute_category set sort_order = 50 where name = 'Block Devices';

update attribute_category set sort_order = 40 where name = 'Memory';

update attribute_category set sort_order = 30 where name = 'Processor';

update attribute_category set sort_order = 20 where name = 'Physical';