Subversion Repositories computer_asset_manager_v1

Rev

Rev 40 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

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