[dbo].[CiscoStatsPSDayView]

(local) > mdb > Views > dbo.CiscoStatsPSDayView

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:05 PM Monday, May 04, 2009

Columns

Name
server_addr
probe_addr
intervaldatetime
intervalduration
freemem
bufferelfree
bufferelmax
bufferelhit
bufferelmiss
bufferelcreate
buffersmtotal
buffersmhit
buffersmmiss
buffermdtotal
buffermdhit
buffermdmiss
bufferbgtotal
bufferbghit
bufferbgmiss
bufferlgtotal
bufferlghit
bufferlgmiss
bufferfail
buffernomem
avgbusy1
avgbusy5
bufferhgtotal
bufferhghit
bufferhgmiss
IntervalTime

Permissions

Type	Action	Owning Principal
Grant	Select	uniadmin

SQL Script

CREATE VIEW CiscoStatsPSDayView AS
SELECT CiscoStats.*, IntervalTime=DATEADD(day, DATEDIFF(day,0,getdate()), 0) FROM CiscoStats WHERE datepart(weekday, IntervalDateTime) BETWEEN 2 AND 6 AND datepart(hour, IntervalDateTime) BETWEEN 8 AND 18
GO
GRANT SELECT ON [dbo].[CiscoStatsPSDayView] TO [uniadmin]
GO

Uses

[dbo].[ciscostats]
dbo