Subversion Repositories computer_asset_manager_v1

create or replace view view_current_client_systems as
select 
   client.client_id client_id,
   client.name client,
   site.site_id site_id,
   site.name site,
   device.device_id device_id,
   device.name device_name,
   concat(device.name,' (',client.name, ' - ',ifnull( site.name,'None'), ')') Device,
   device_type.device_type_id device_type_id,
   device_type.name device_type
from
   client
   join site using ( client_id )
   join device using (site_id )
   join device_type using (device_type_id)
where
   client.removed_date is null
   and site.removed_date is null
   and device.removed_date is null
   and device_type.removed_date is null
   and device_type.show_as_system = 'Y'
;