CREATE view usd_v_osim_targets(agent_name, agent_uuid, id, class, bootserver, mac_address, nullid)
as
select     aa.agent_name,     /* readable name */
    aa.agent_uuid,     /* uuid of the computer */
    aa.id,         
    aa.class,
           aa.bootserver,     /* readable name */
           aa.mac_address,
    bb.id
from usd_v_osim_targets_all aa left join usd_v_osim_targets_deleted bb on  aa.id=bb.id
where bb.id is NULL
GO
GRANT SELECT ON  [dbo].[usd_v_osim_targets] TO [ams_group]
GRANT REFERENCES ON  [dbo].[usd_v_osim_targets] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[usd_v_osim_targets] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[usd_v_osim_targets] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[usd_v_osim_targets] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[usd_v_osim_targets] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[usd_v_osim_targets] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[usd_v_osim_targets] TO [upmuser_group]
GO