[dbo].[NonHealthDayView]

(local) > mdb > Views > dbo.NonHealthDayView

Properties
Columns
Permissions
SQL Script
Uses
Used By

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

Columns

Name
server_addr
intervaldatetime
intervallength
nprobesmonitoredperformance
ninterfacesmonitoredperformance
nprobesmonitoredavailability
ninterfacesmonitoredavailability
criticalduration
majorduration
minorduration
warningduration
criticalnumber
majornumber
minornumber
warningnumber
ntotalprobesnonavail
ntotalinterfacesnonavail
nsecondsprobesnonavail
nsecondsinterfacesnonavail
IntervalTime

Permissions

Type	Action	Owning Principal
Grant	Select	uniadmin

SQL Script

CREATE VIEW NonHealthDayView AS
SELECT NonHealth.*, IntervalTime=DATEADD(day, DATEDIFF(day,0,getdate()), 0) FROM NonHealth
GO
GRANT SELECT ON [dbo].[NonHealthDayView] TO [uniadmin]
GO

Uses

[dbo].[nonhealth]
dbo

Used By

[dbo].[NonHealthLastWeekView]