Subversion Repositories computer_asset_manager_v1

select 
   client.name 'Client',
   site.name 'Site',
   hyper.name DOM0,
   virt.name DOMU
from 
   device hyper 
   join device virt on ( virt.part_of = hyper.device_id )
   join device_type on (virt.device_type_id = device_type.device_type_id)
   join site on ( hyper.site_id = site.site_id )
   join client on (site.client_id = client.client_id )
where 
   device_type.show_as_system = "Y"
   and hyper.removed_date is null 
   and virt.removed_date is null
   and site.name = 'Colocation NOC'
order by 
   client.name,
   site.name,
   hyper.name,
   virt.name