Views [dbo].[NonHealthLastDayView]
(local) > mdb > Views > dbo.NonHealthLastDayView
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created11:10:07 AM Wednesday, March 07, 2007
Last Modified5: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
TypeActionOwning Principal
GrantSelectuniadmin
SQL Script
CREATE VIEW NonHealthLastDayView AS
SELECT * FROM NonHealthHourView WHERE IntervalTime >= DATEADD(dd, DATEDIFF(dd,1,getdate()), 0) AND IntervalDateTime < DATEADD(dd, DATEDIFF(dd,0,getdate()), 0)
GO
GRANT SELECT ON  [dbo].[NonHealthLastDayView] TO [uniadmin]
GO
Uses
Created 03 June 2010 08:02
Copyright 2010 by CA Technologies, Inc. - All Rights Reserved