CREATE VIEW ResourceNameServerView AS
SELECT server_addr=c.server_addr
    ,probe_addr=0
    ,rsrcIndex=0
    ,rsrcOtherIndex=0
    ,rsrcType=-1
    ,collect_flags=536870912
    ,rsrcName=c.server_name
    ,rsrcDescr='Collector'
    ,IP_addr=''
    ,port=0
    ,community='public'
    ,ifSpeed=0
    ,ifType=0
    ,agentName=c.server_name
    ,ifName=''
    ,ifIndex=0
    ,mibIndex=''
    ,mibId=0
    ,monitored=1
    ,bypassAvail=0
    ,viewType=-1
    ,rsrcId=convert(varchar(10),-1)+':'+convert(varchar(12),c.server_addr)+':'+convert(varchar(10),0)+':'+convert(varchar(10),0)
    ,userId=0
FROM CollectServer c
GO
GRANT SELECT ON  [dbo].[ResourceNameServerView] TO [uniadmin]
GO