CREATE VIEW ResourceNameNPOTSView AS
SELECT server_addr=p.server_addr
    ,probe_addr=p.probe_addr
    ,rsrcIndex=lp.probeIndex
    ,rsrcOtherIndex=tid.termServerKeyId
    ,rsrcType=12
    ,collect_flags=collect_flags
    ,rsrcName=lp.probeInterfaceName+' / '+
        case sid.mode
        WHEN 0 THEN sid.name
        WHEN 1 THEN sid.name
        WHEN 3 THEN 'User Defined Server'
        ELSE 'Unknown'
        END
    +' / '+tid.termServerName+
    CASE tid.termServerPort
    WHEN 0 THEN ''
    ELSE ':'+convert(varchar(6), tid.termServerPort)
    END
    ,rsrcDescr=tid.termServerNetAddr
    ,IP_addr=p.IP_addr
    ,p.port
    ,community=community
    ,ifSpeed=lp.probeNetworkSpeed
    ,ifType=lp.probeMediumType
    ,agentName=
        case sid.mode
        WHEN 0 THEN sid.name
        WHEN 1 THEN sid.name
        WHEN 3 THEN 'User Defined Server'
        ELSE 'Unknown'
        END
    +' / '+tid.termServerName+
    CASE tid.termServerPort
    WHEN 0 THEN ''
    ELSE ':'+convert(varchar(6), tid.termServerPort)
    END
    ,ifName=lp.probeInterfaceName
    ,ifIndex=lp.probeIndex
    ,mibIndex=
    convert(varchar(2), tid.probeIndex) + '.' +
    CASE serviceType
    WHEN 1025 THEN '2'
    WHEN 514 THEN  '5'
    WHEN 515 THEN '6'
    WHEN 516 THEN '3'
    ELSE '1' END
    + '.'+ convert(varchar(6), termServerServiceType) + '.'
    + convert(varchar(6), termServerPort)
    +'.$' + termServerNetAddr+ '$'
    ,mibId=0
    ,monitored=p.monitored
    ,bypassAvail=(p.collect_flags & 0x80000)/0x80000
    ,viewType=32
    ,rsrcId=convert(varchar(10),12)+':'+convert(varchar(12),p.probe_addr)+':'+convert(varchar(10),lp.probeIndex)+':'+convert(varchar(10),tid.termServerKeyId)
    ,userId=p.userId
FROM UserProbeView p, LSYProbeId lp,
    (LSYTermServerId tid left join MonitorAppl sid
    ON tid.termServerServiceType=sid.serviceType)
WHERE (collect_flags & 8192)=8192
    AND p.probe_addr=lp.probe_addr
    AND p.server_addr=lp.server_addr
    AND lp.server_addr=tid.server_addr
    AND lp.probe_addr=tid.probe_addr
    AND lp.probeIndex=tid.probeIndex
    AND tid.termServerServiceType<>1025
GO
GRANT SELECT ON  [dbo].[ResourceNameNPOTSView] TO [uniadmin]
GO