CREATE VIEW WatchView AS
select s.server_addr
    ,s.probe_addr
    ,s.rsrcIndex
    ,s.rsrcOtherIndex
    ,s.rsrcType
    ,s.fieldIndex
    ,t.fieldDescShort
    ,s.IntervalDateTime
    ,value=t.displayScaleFactor*s.value
    ,average=t.displayScaleFactor*s.average
    ,s.severity
    ,type=CASE WHEN value > average THEN 'Value Over'
        else 'Value Under'
    end
FROM Watch s, ThresholdDesc t
WHERE s.fieldIndex=t.fieldIndex
GO
GRANT SELECT ON  [dbo].[WatchView] TO [uniadmin]
GO