[dbo].[LSYFileServerStatsDayView]

(local) > mdb > Views > dbo.LSYFileServerStatsDayView

Properties
Columns
Permissions
SQL Script
Uses
Used By

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

Columns

Name
server_addr
probe_addr
intervaldatetime
intervalduration
probeindex
fileserverkeyid
pktstoclient
bytestoclient
pktstoserver
bytestoserver
readsvccount
readsvcsum
readsvcsos
readbytes
writesvccount
writesvcsum
writesvcsos
writebytes
othersvccount
othersvcsum
othersvcsos
siocount
siosum
siosos
linkerrcount
fserrcount
fileopen
fileclose
filesearch
IntervalTime

Permissions

Type	Action	Owning Principal
Grant	Select	uniadmin

SQL Script

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

Uses

[dbo].[lsyfileserverstats]
dbo

Used By

[dbo].[LSYFileServerStatsLastWeekView]