Subversion Repositories computer_asset_manager_v1

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
77 rodolico 1 
create or replace view view_current_client_systems as
2 
select
3 
   client.client_id client_id,
4 
   client.name client,
5 
   site.site_id site_id,
6 
   site.name site,
7 
   device.device_id device_id,
8 
   device.name device_name,
9 
   concat(device.name,' (',client.name, ' - ',ifnull( site.name,'None'), ')') Device,
10 
   device_type.device_type_id device_type_id,
11 
   device_type.name device_type
12 
from
13 
   client
14 
   join site using ( client_id )
15 
   join device using (site_id )
16 
   join device_type using (device_type_id)
17 
where
18 
   client.removed_date is null
19 
   and site.removed_date is null
20 
   and device.removed_date is null
21 
   and device_type.removed_date is null
22 
   and device_type.show_as_system = 'Y'
23 
;