CREATE VIEW ResourceNameNBarProtocolView AS
SELECT server_addr=p.server_addr
    ,probe_addr=p.probe_addr
    ,rsrcIndex=f.dbIndex
    ,rsrcOtherIndex=nbp.SupportedProtocolsIndex
    ,rsrcType=-8
    ,collect_flags=collect_flags
    ,rsrcName=p.sysName + ' / '+convert(varchar(5),f.ifIndex)+' : '+ISNULL(i.itfcDescr,f.ifDescr)+ ' (bw= ' + CASE
    WHEN ISNULL(itfcSpeed,ifSpeed)=4294967295 THEN 'Unknown'
    WHEN ISNULL(itfcSpeed,ifSpeed)=1 THEN 'Unknown'
    WHEN ISNULL(itfcSpeed,ifSpeed) BETWEEN 1000.0 AND 1000000 THEN convert(varchar(5),ISNULL(itfcSpeed,ifSpeed)/1000) + ' Kbps'
    WHEN ISNULL(itfcSpeed,ifSpeed)>1000000 THEN convert(varchar(12),convert(int,1.0*ISNULL(itfcSpeed,ifSpeed)/1000000))+' Mbps'
    ELSE  convert(varchar(6),ISNULL(itfcSpeed,ifSpeed))+' bps'
    END+') ' + nbp.SupportedProtocolsName
    ,rsrcDescr=sysDescr
    ,IP_addr=p.IP_addr
    ,p.port
    ,community=community
    ,ifSpeed=isnull(i.itfcSpeed,f.ifSpeed)
    ,ifType=f.ifType
    ,agentName=convert(varchar(5),f.ifIndex)+' : '+ISNULL(i.itfcDescr,f.ifDescr)+ ' (bw= ' + CASE
    WHEN ISNULL(itfcSpeed,ifSpeed)=4294967295 THEN 'Unknown'
    WHEN ISNULL(itfcSpeed,ifSpeed)=1 THEN 'Unknown'
    WHEN ISNULL(itfcSpeed,ifSpeed) BETWEEN 1000.0 AND 1000000 THEN convert(varchar(5),ISNULL(itfcSpeed,ifSpeed)/1000) + ' Kbps'
    WHEN ISNULL(itfcSpeed,ifSpeed)>1000000 THEN convert(varchar(12),convert(int,1.0*ISNULL(itfcSpeed,ifSpeed)/1000000))+' Mbps'
    ELSE  convert(varchar(6),ISNULL(itfcSpeed,ifSpeed))+' bps'
    END+') ' + nbp.SupportedProtocolsName
    ,ifName=f.ifDescr
    ,ifIndex=f.ifIndex
    ,mibIndex=convert(varchar(10), f.ifIndex)
    ,mibId=16
    ,monitored=CASE WHEN ((collect_flags & 67108864)=67108864 AND i.collReq IS NULL) THEN 0
    WHEN p.collect_flags < 0 THEN 0
    WHEN p.collect_flags >= 1073741824 THEN 0
    WHEN np.StatusPdEnable <> 1 THEN 0
    ELSE 1 END
    ,bypassAvail=(p.collect_flags & 0x80000)/0x80000
    ,viewType=32
    ,rsrcId=convert(varchar(10),-8)+':'+convert(varchar(12),p.probe_addr)+':'+convert(varchar(10),f.dbIndex)+':'+convert(varchar(10),0)
    ,userId=p.userId
FROM (UserProbeView p join M2if f
    ON p.server_addr=f.server_addr
    AND p.probe_addr=f.probe_addr)
    left join ItfcConfig i
    ON f.server_addr=i.server_addr
    AND f.probe_addr=i.probe_addr
    AND f.dbIndex=i.itfcIndex
    ,NBARProtocolStatus_cfg np
    ,NBARprotocol_cfg nbp
WHERE np.server_addr=f.server_addr
    AND np.probe_addr=f.probe_addr
    AND np.dbIndex=f.dbIndex
GO
GRANT SELECT ON  [dbo].[ResourceNameNBarProtocolView] TO [uniadmin]
GO