CREATE VIEW UserProbeView AS
SELECT p.server_addr
    ,p.probe_addr
    ,p.IP_addr
    ,p.port
    ,p.community
    ,p.collect_flags
    ,p.sysDescr
    ,p.class_name
    ,p.sysObjectId
    ,sysName=CASE
    WHEN p.user_descr IS NOT NULL AND p.user_descr <> '' THEN p.user_descr
    WHEN p.sysName IS NOT NULL AND p.sysName <> '' THEN p.sysName
    ELSE p.IP_addr END
    ,monitored= (CASE
    WHEN (p.collect_flags >=0 AND p.collect_flags < 536870912) THEN 1
    WHEN p.collect_flags & 0x20000000 = 0x20000000 THEN 2
    WHEN p.collect_flags & 0x40000000 = 0x40000000 THEN -1
    WHEN p.collect_flags & 0x80000000 = 0x80000000 THEN -2
    else 0
    END )
    ,bypassAvail=(p.collect_flags & 0x80000)/0x80000
,    rsrcId=convert(varchar(10),-1)+':'+convert(varchar(12),p.probe_addr)+':'+convert(varchar(10),0)+':'+convert(varchar(10),0)
,    userId=acl.userId
    FROM network_Probe p, ProbeAccessList acl
WHERE (p.probe_addr=acl.probe_addr OR acl.probe_addr IS NULL)
    AND p.server_addr=
(SELECT convert(int, parmValue) FROM CollectionParms
WHERE parmName='COLLECTION SERVER ID')
    AND p.collect_flags & 0x80000000 <> 0x80000000
GO
GRANT SELECT ON  [dbo].[UserProbeView] TO [uniadmin]
GO