CREATE VIEW ResourceNameBGP4View AS
SELECT server_addr=p.server_addr
    ,probe_addr=p.probe_addr
    ,rsrcIndex=bgpPeerRemoteAs
    ,rsrcOtherIndex=bgpPeerIdentifier
    ,rsrcType=20
    ,collect_flags=collect_flags
    ,rsrcName=b.bgpPeerIdentifierIP+' : ' +convert(varchar(10),bgpLocalAs)+' - '+ convert(varchar(10),bgpPeerRemoteAs)
    ,rsrcDescr=sysDescr
    ,IP_addr=IP_addr
    ,p.port
    ,community=community
    ,ifSpeed=0
    ,ifType=0
    ,agentName=b.bgpPeerIdentifierIP+' : ' +convert(varchar(10),bgpLocalAs)+' - '+ convert(varchar(10),bgpPeerRemoteAs)
    ,ifName=''
    ,ifIndex=0
    ,mibIndex=bgpPeerIdentifierIP
    ,mibId=0
    ,monitored=p.monitored
    ,bypassAvail=(p.collect_flags & 0x80000)/0x80000
    ,viewType=8
    ,rsrcId=convert(varchar(10),20)+':'+convert(varchar(12),p.probe_addr)+':'+convert(varchar(10),bgpPeerRemoteAs)+':'+convert(varchar(10),bgpPeerIdentifier)
    ,userId=p.userId
FROM UserProbeView p, BGP4PeerEntry b
WHERE (collect_flags & 262144)=262144
    AND p.server_addr=b.server_addr
    AND p.probe_addr=b.probe_addr
GO
GRANT SELECT ON  [dbo].[ResourceNameBGP4View] TO [uniadmin]
GO