Subversion Repositories computer_asset_manager_v1

Rev

Go to most recent revision | Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
40 rodolico 1 
select
2 
   hyper.name DOM0,
3 
   virt.name DOMU
4 
from
5 
   device hyper join device virt
6 
   join device_type on (virt.device_type_id = device_type.device_type_id)
7 
where
8 
   device_type.show_as_system = "Y"
9 
   and hyper.device_id = virt.part_of
10 
   and hyper.removed_date is null
11 
   and virt.removed_date is null
12 
order by
13 
   hyper.name,
14 
   virt.name