/* ************************** 11613 end **************/
/* ************************** 11614 begin **************/

CREATE view usd_vq_target
as
select agent_name as lanname, object_uuid as objectid, NULL as dis_hw_uuid, agent_type
from ca_agent a
where a.agent_type = 1 or a.agent_type = 4
GO
GRANT SELECT ON  [dbo].[usd_vq_target] TO [ams_group]
GRANT SELECT ON  [dbo].[usd_vq_target] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[usd_vq_target] TO [ca_itrm_group_ams]
GO