CREATE VIEW CriticalInterfaceView AS
SELECT
    server_addr
    ,probe_addr
    ,rsrcIndex
    ,rsrcOtherIndex
    ,rsrcType=-16
    ,collect_flags
    ,rsrcName
    ,rsrcDescr
    ,IP_addr
    ,port
    ,community
    ,ifSpeed
    ,ifType
    ,agentName
    ,ifName
    ,ifIndex
    ,mibIndex
    ,mibId
    ,monitored
    ,bypassAvail
    ,viewType=-16
    ,rsrcId=convert(varchar(10),-16)+':'+convert(varchar(12),probe_addr)+':'+convert(varchar(10),rsrcIndex)+':'+convert(varchar(10),0)
    ,userId
    FROM ResourceNameWANView p
    WHERE ifSpeed >= 1000000 and ifSpeed <> 4294967295
    AND monitored > 0
    AND (collect_flags & 1)=1
GO
GRANT SELECT ON  [dbo].[CriticalInterfaceView] TO [uniadmin]
GO