Views [dbo].[LSYFileServerStatsPSDayView]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created12:31:58 PM Sunday, December 05, 2010
Last Modified7:19:23 PM Friday, January 07, 2011
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
TypeActionOwning Principal
GrantSelectuniadmin
SQL Script
CREATE VIEW LSYFileServerStatsPSDayView AS
SELECT LSYFileServerStats.*, IntervalTime=DATEADD(day, DATEDIFF(day,0,getdate()), 0) FROM LSYFileServerStats WHERE datepart(weekday, IntervalDateTime) BETWEEN 2 AND 6 AND datepart(hour, IntervalDateTime) BETWEEN 8 AND 18
GO
GRANT SELECT ON  [dbo].[LSYFileServerStatsPSDayView] TO [uniadmin]
GO
Uses