Views [dbo].[LSYTermServerClientsPSHourView]
(local) > mdb > Views > dbo.LSYTermServerClientsPSHourView
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created12:31:59 PM Sunday, December 05, 2010
Last Modified7:19:24 PM Friday, January 07, 2011
Columns
Name
server_addr
probe_addr
intervaldatetime
intervalduration
probeindex
addrtype
servicetype
servernetaddr
clientnetaddr
pktstoclient
bytestoclient
pktstoserver
bytestoserver
userrspcount
userrspsum
userrspcrossings
netrsptype
netrspcount
netrspsum
netrspcrossings
linkerrors
clientname
serverport
IntervalTime
Permissions
TypeActionOwning Principal
GrantSelectuniadmin
SQL Script
CREATE VIEW LSYTermServerClientsPSHourView AS
SELECT LSYTermServerClients.*, IntervalTime=DATEADD(hour, DATEDIFF(hour,0,getdate()), 0) FROM LSYTermServerClients WHERE datepart(weekday, IntervalDateTime) BETWEEN 2 AND 6 AND datepart(hour, IntervalDateTime) BETWEEN 8 AND 18
GO
GRANT SELECT ON  [dbo].[LSYTermServerClientsPSHourView] TO [uniadmin]
GO
Uses
Created 01 August 2011 11:36
Copyright  CA Technologies, Inc. 2011  - All Rights Reserved