[dbo].[WatchView]

[dbo].[WatchView]

Properties
Columns
Permissions
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	11:10:04 AM Wednesday, March 07, 2007
Last Modified	5:37:38 PM Monday, May 04, 2009

Columns

Name
server_addr
probe_addr
rsrcIndex
rsrcOtherIndex
rsrcType
fieldIndex
fieldDescShort
IntervalDateTime
value
average
severity
type

Permissions

Type	Action	Owning Principal
Grant	Select	uniadmin

SQL Script

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

Uses

[dbo].[thresholddesc]
[dbo].[watch]
dbo