CREATE VIEW ResourceNameNPOFSView AS
SELECT server_addr=p.server_addr
    ,probe_addr=p.probe_addr
    ,rsrcIndex=lp.probeIndex
    ,rsrcOtherIndex=fid.fileServerKeyId
    ,rsrcType=11
    ,collect_flags=collect_flags
    ,rsrcName=lp.probeInterfaceName+ ' / '+sid.name+ ' / '+fid.fileServerName
    ,rsrcDescr=fid.fileServerNetAddr
    ,IP_addr=p.IP_addr
    ,p.port
    ,community=community
    ,ifSpeed=lp.probeNetworkSpeed
    ,ifType=lp.probeMediumType
    ,agentName=sid.name+' / '+fid.fileServerName
    ,ifName=lp.probeInterfaceName
    ,ifIndex=lp.probeIndex
    ,mibIndex=convert(varchar(2), fid.probeIndex) + '.' +
        CASE fileServerServiceType WHEN 2050 THEN '3'
        WHEN 2049 THEN '1' ELSE '2' END
    +'.$' + fileServerNetAddr + '$'
    ,mibId=0
    ,monitored=p.monitored
    ,bypassAvail=(p.collect_flags & 0x80000)/0x80000
    ,viewType=32
    ,rsrcId=convert(varchar(10),11)+':'+convert(varchar(12),p.probe_addr)+':'+convert(varchar(10),lp.probeIndex)+':'+convert(varchar(10),fid.fileServerKeyId)
    ,userId=p.userId
FROM UserProbeView p, LSYProbeId lp, LSYFileServerId fid, MonitorAppl sid
WHERE p.probe_addr=lp.probe_addr
    AND p.server_addr=lp.server_addr
    AND lp.server_addr=fid.server_addr
    AND lp.probe_addr=fid.probe_addr
    AND lp.probeIndex=fid.probeIndex
    AND fid.fileServerServiceType=sid.serviceType
    AND (collect_flags & 8192)=8192
GO
GRANT SELECT ON  [dbo].[ResourceNameNPOFSView] TO [uniadmin]
GO