Subversion Repositories computer_asset_manager_v1

Rev

Go to most recent revision | Blame | Compare with Previous | Last modification | View Log | Download | RSS feed 

select 
   hyper.name DOM0,
   virt.name DOMU
from 
   device hyper join device virt
   join device_type on (virt.device_type_id = device_type.device_type_id)
where 
   device_type.show_as_system = "Y"
   and hyper.device_id = virt.part_of 
   and hyper.removed_date is null 
   and virt.removed_date is null
order by 
   hyper.name,
   virt.name