/************************************************************************
    view     usd_v_targets_os
    displays the usd relavant target systems
    and their OS
    
    view     usd_v_targets_os_s
    is used for security impacts

************************************************************************/




/************************************************************************
    view

************************************************************************/




CREATE view usd_v_targets_os_a_s
(    uri, user_uuid,
    agent_name, agent_type, agent_uuid,
    proc_os_name,
        is_boot_server, is_staging_server, is_user, is_computer, server_label)

as
select     uri, user_uuid,
    agent_name, agent_type, agent_uuid,
    proc_os_name,
        is_boot_server, is_staging_server, is_user, is_computer, server_label

from     usd_v_user_dhw_area_sec, usd_v_targets_os

where    usd_v_user_dhw_area_sec.dhw_uuid
        = usd_v_targets_os.agent_uuid
GO
GRANT SELECT ON  [dbo].[usd_v_targets_os_a_s] TO [ams_group]
GRANT SELECT ON  [dbo].[usd_v_targets_os_a_s] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[usd_v_targets_os_a_s] TO [ca_itrm_group_ams]
GO