CREATE view usd_v_osim_targets_deleted(uuid, id)
as
select     c1.uuid,     /* uuid of the computer */
    c1.id
from  csm_object c1,
    csm_link l1, csm_object p1
where
    c1.class=102     and /* computer */
    c1.name = ''     and /* unnamed computer */

    l1.child=c1.id    and  /* link computer to parent */
    l1.parent=p1.id and
    p1.class=103    /* parent is bs */
GO
GRANT SELECT ON  [dbo].[usd_v_osim_targets_deleted] TO [ams_group]
GRANT SELECT ON  [dbo].[usd_v_osim_targets_deleted] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[usd_v_osim_targets_deleted] TO [ca_itrm_group_ams]
GO