Views [dbo].[NonHealthMinuteView]
(local) > mdb > Views > dbo.NonHealthMinuteView
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created12:32:03 PM Sunday, December 05, 2010
Last Modified7:19:30 PM Friday, January 07, 2011
Columns
Name
server_addr
intervaldatetime
intervallength
nprobesmonitoredperformance
ninterfacesmonitoredperformance
nprobesmonitoredavailability
ninterfacesmonitoredavailability
criticalduration
majorduration
minorduration
warningduration
criticalnumber
majornumber
minornumber
warningnumber
ntotalprobesnonavail
ntotalinterfacesnonavail
nsecondsprobesnonavail
nsecondsinterfacesnonavail
IntervalTime
Permissions
TypeActionOwning Principal
GrantSelectuniadmin
SQL Script
CREATE VIEW NonHealthMinuteView AS
SELECT NonHealth.*, IntervalTime=DATEADD(minute, DATEDIFF(minute,0,getdate()), 0) FROM NonHealth
GO
GRANT SELECT ON  [dbo].[NonHealthMinuteView] TO [uniadmin]
GO
Uses
Created 01 August 2011 11:36
Copyright  CA Technologies, Inc. 2011  - All Rights Reserved