CREATE VIEW ResourceNameEchoPathView AS
SELECT server_addr=p.server_addr
    ,probe_addr=p.probe_addr
    ,rsrcIndex=0
    ,rsrcOtherIndex=re.CtrlAdminIndex
    ,rsrcType=132
    ,collect_flags=collect_flags
    ,rsrcName=ra.CtrlAdminTag+' ('+p.IP_addr+':' + convert(varchar(8),EchoAdminSourcePort)+' - ' + dbo.StrToIP(EchoAdminTargetAddress)+':'+convert(varchar(8), EchoAdminTargetPort)+') TOS ('+convert(varchar(2),echoadmintos)+')'
    ,rsrcDescr=sysDescr
    ,IP_addr=p.IP_addr
    ,p.port
    ,community=community
    ,ifSpeed=0
    ,ifType=0
    ,agentName=ra.CtrlAdminTag+' ('+p.IP_addr+':' + convert(varchar(8),EchoAdminSourcePort)+' - ' + dbo.StrToIP(EchoAdminTargetAddress)+':'+convert(varchar(8), EchoAdminTargetPort)+') TOS ('+convert(varchar(2),echoadmintos)+')'
    ,ifName=ra.CtrlAdminTag
    ,ifIndex=0
    ,mibIndex=''
    ,mibId=18
    ,monitored=p.monitored
    ,bypassAvail=(p.collect_flags & 0x80000)/0x80000
    ,viewType=8
    ,rsrcId=convert(varchar(10),132)+':'+convert(varchar(12),p.probe_addr)+':'+convert(varchar(10),0)+':'+convert(varchar(10),re.CtrlAdminIndex)
    ,userId=p.userId
FROM RTTEchoAdmin_cfg re, RTTCtrlAdmin_cfg ra, UserProbeView p
WHERE re.probe_addr = p.probe_addr
    AND re.probe_addr=ra.probe_addr
    AND re.CtrlAdminIndex=ra.CtrlAdminIndex
    AND ra.CtrlAdminRttType=1
GO
GRANT SELECT ON  [dbo].[ResourceNameEchoPathView] TO [uniadmin]
GO