create view uapm_v_netdisc_inv as
select
v1.hw_uuid, v1.value_name, v1.value_text, v1.value_long, v1.value_double
from     
            uapm_v_netdiscdata_l1 v1
where  
            v1.pparent_name='NetworkDiscovery' and v1.parent_name='$Network'
and v1.value_name in ('Domain', 'Host Name', 'IP Address',
'MAC Address', 'Switch Name', 'Port Name', 'Port Type',
'Port Description', 'Switch IP Address', 'Switch Location',
'Vendor', 'Site', 'Customer Name', 'Function', 'Scan Date' )
GO
GRANT SELECT ON  [dbo].[uapm_v_netdisc_inv] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[uapm_v_netdisc_inv] TO [ca_itrm_group_ams]
GO