CREATE VIEW "resourcenamebgp4asview" ("server_addr", "probe_addr", "rsrcIndex", "rsrcOtherIndex", "rsrcType", "collect_flags", "rsrcName", "rsrcDescr", "IP_addr", "port", "community", "ifSpeed", "ifType", "agentName", "ifName", "ifIndex", "mibIndex", "mibId", "monitored", "bypassAvail", "viewType", "rsrcId", "userId")  AS
       SELECT DISTINCT "b"."server_addr", 0, "b"."bgplocalas", "b"."bgppeerremoteas", - 20, 0, 'AS Pair ' + dbo.varchar(bgpLocalAs) + ' - ' + dbo.varchar(bgpPeerRemoteAs), '', '', 0, '', 0, 0, dbo.varchar(bgpLocalAs) + ' - ' + dbo.varchar(bgpPeerRemoteAs), '', 0, '', 0, 1, 1, 8, dbo.varchar(20) + ':' + dbo.varchar(server_addr) + ':' + dbo.varchar(bgpLocalAs) + ':' + dbo.varchar(bgpPeerRemoteAs), 0
       FROM "bgp4peerentry" "b"
GO
GRANT SELECT ON  [dbo].[resourcenamebgp4asview] TO [uniadmin]
GO