CREATE view usd_v_sserver_clients
( server_name, agent_name, object_uuid )    
as

select DHW.agent_name, DAG.agent_name, DAG.object_uuid
from usd_v_agents DAG, usd_v_agents DHW,
    ca_server_component SC, ca_server SV,
    ca_agent_component CAC
where DHW.object_uuid=SV.dis_hw_uuid
    and SV.server_uuid=SC.server_uuid
    and SC.server_comp_id=41
    and CAC.server_uuid=SV.server_uuid
    and CAC.object_uuid=DAG.object_uuid
    and CAC.agent_comp_id=40
GO
GRANT SELECT ON  [dbo].[usd_v_sserver_clients] TO [ams_group]
GRANT REFERENCES ON  [dbo].[usd_v_sserver_clients] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[usd_v_sserver_clients] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[usd_v_sserver_clients] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[usd_v_sserver_clients] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[usd_v_sserver_clients] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[usd_v_sserver_clients] TO [ca_itrm_group_ams]
GO