create view uapm_v_netdiscdata_l1 as
    select i.object_uuid hw_uuid,
    i.ITEM_TYPE value_type,
    i.ITEM_FORMAT value_format,
    i.ITEM_VALUE_TEXT value_text,
    i.ITEM_VALUE_LONG value_long,
        i.ITEM_VALUE_DOUBLE value_double,
        n.item_name value_name,
        tn.tree_name parent_name,
                   tnp.tree_name pparent_name,
                   ip.domain_uuid domain_uuid,
                    ip.tenant_id
                   from ((((inv_networkdiscovery_tree ip join inv_tree_name_id tnp
                   on tnp.tree_name_id=ip.item_parent_name_id
                   and tnp.domain_uuid=ip.domain_uuid)
                   join inv_tree_name_id tn on tn.tree_name_id=ip.item_name_id
                   and tn.domain_uuid=ip.domain_uuid)
                   join inv_networkdiscovery_item i on ip.item_id=i.item_parent_id
                   and ip.object_uuid=i.object_uuid
                   and i.domain_uuid=ip.domain_uuid
                   and i.tenant_id=ip.tenant_id)
                                      join inv_item_name_id n on i.item_name_id=n.item_name_id
                   and n.domain_uuid=ip.domain_uuid)
GO
GRANT SELECT ON  [dbo].[uapm_v_netdiscdata_l1] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[uapm_v_netdiscdata_l1] TO [ca_itrm_group_ams]
GO