CREATE VIEW DeviceView AS
SELECT
    server_addr=p.server_addr
    ,probe_addr=p.probe_addr
    ,rsrcIndex=0
    ,rsrcOtherIndex=0
    ,rsrcType=-1
    ,collect_flags=p.collect_flags
    ,rsrcName = p.sysName
    ,rsrcDescr=sysDescr
    ,IP_addr=p.IP_addr
    ,port=p.port
    ,community=community
    ,ifSpeed=0
    ,ifType=0
    ,agentName=sysName
    ,ifName=''
    ,ifIndex=0
    ,mibIndex='0'
    ,mibId=0
    ,monitored= p.monitored
    ,bypassAvail=(p.collect_flags & 0x80000)/0x80000
    ,viewType=1
    ,rsrcId=convert(varchar(10),-1)+':'+convert(varchar(12),p.probe_addr)+':'+convert(varchar(10),0)+':'+convert(varchar(10),0)
    ,userId=p.userId
FROM UserProbeView p
WHERE p.server_addr=
(SELECT convert(int, parmValue) FROM CollectionParms
WHERE parmName='COLLECTION SERVER ID')
GO
GRANT SELECT ON  [dbo].[DeviceView] TO [uniadmin]
GO