Subversion Repositories computer_asset_manager_v1

Rev

Rev 40 | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
40 rodolico 1 
select
75 rodolico 2 
   client.name 'Client',
3 
   site.name 'Site',
40 rodolico 4 
   hyper.name DOM0,
5 
   virt.name DOMU
6 
from
75 rodolico 7 
   device hyper
8 
   join device virt on ( virt.part_of = hyper.device_id )
40 rodolico 9 
   join device_type on (virt.device_type_id = device_type.device_type_id)
75 rodolico 10 
   join site on ( hyper.site_id = site.site_id )
11 
   join client on (site.client_id = client.client_id )
40 rodolico 12 
where
13 
   device_type.show_as_system = "Y"
14 
   and hyper.removed_date is null
15 
   and virt.removed_date is null
75 rodolico 16 
   and site.name = 'Colocation NOC'
40 rodolico 17 
order by
75 rodolico 18 
   client.name,
19 
   site.name,
40 rodolico 20 
   hyper.name,
21 
   virt.name
75 rodolico 22 
 
23