Views [dbo].[LSYLanUtilizationPSDayView]
(local) > mdb > Views > dbo.LSYLanUtilizationPSDayView
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created11:10:06 AM Wednesday, March 07, 2007
Last Modified5:37:12 PM Monday, May 04, 2009
Columns
Name
server_addr
probe_addr
intervaldatetime
intervalduration
probeindex
utilcount
utilsum
utilsos
utilhist1
utilhist2
utilhist3
utilhist4
utilhistover
utilhist1ctl
utilhist2ctl
utilhist3ctl
utilhist4ctl
utilthreshold
utilsamplesize
utilavgeobs
utilburstobs
utilcrossingsctr
utilpeakrate
utilburstmax
sizehist1
sizehist2
sizehist3
sizehist4
sizehistover
sizehist1ctl
sizehist2ctl
sizehist3ctl
sizehist4ctl
totalframes
totalbytes
broadcastframes
broadcastbytes
multicastframes
multicastbytes
frameslostprobe
frameslostbuf
frameslosthard
IntervalTime
Permissions
TypeActionOwning Principal
GrantSelectuniadmin
SQL Script
CREATE VIEW LSYLanUtilizationPSDayView AS
SELECT LSYLanUtilization.*, IntervalTime=DATEADD(day, DATEDIFF(day,0,getdate()), 0) FROM LSYLanUtilization WHERE datepart(weekday, IntervalDateTime) BETWEEN 2 AND 6 AND datepart(hour, IntervalDateTime) BETWEEN 8 AND 18
GO
GRANT SELECT ON  [dbo].[LSYLanUtilizationPSDayView] TO [uniadmin]
GO
Uses
Created 03 June 2010 08:02
Copyright 2010 by CA Technologies, Inc. - All Rights Reserved