CREATE view usd_v_osim_targets_all(agent_name, agent_uuid, id, class, bootserver, mac_address)
as
select     c.dname,     /* readable name */
    c.uuid,     /* uuid of the computer */
    c.id,         
    c.class,
           bs.dname,     /* readable name */
           cp_mac.value

from  csm_object c,
    csm_property cp_bs, csm_property cp_mac,
    csm_link l, csm_object bs
where
    c.class=102         and /* computer */
    c.name = ''         and /* unnamed computer */

    cp_bs.object=c.id      and /* link property on computer */
    cp_bs.name='bootstatus' and /* unmanaged computer */
    cp_bs.value='7000'     and

    cp_mac.object=c.id      and /* link property on computer */
    cp_mac.name='macaddr'   and /* property mac address */

    l.child=c.id        and  /* link computer to parent */
    l.parent=bs.id      and
    bs.class=1000        /* parent is bs */
GO
GRANT SELECT ON  [dbo].[usd_v_osim_targets_all] TO [ams_group]
GRANT SELECT ON  [dbo].[usd_v_osim_targets_all] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[usd_v_osim_targets_all] TO [ca_itrm_group_ams]
GO