Views [dbo].[RMONetherStatsStatsPSDayView]
(local) > mdb > Views > dbo.RMONetherStatsStatsPSDayView
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created12:32:04 PM Sunday, December 05, 2010
Last Modified7:19:32 PM Friday, January 07, 2011
Columns
Name
server_addr
probe_addr
intervaldatetime
intervalduration
etherstatsindex
etherstatsdropevents
etherstatsoctets
etherstatspkts
etherstatsbroadcastpkts
etherstatsmulticastpkts
etherstatscrcalignerrors
etherstatsundersizepkts
etherstatsoversizepkts
etherstatsfragments
etherstatsjabbers
etherstatscollisions
etherstatspkts64octets
etherstatspkts65to127octets
etherstatspkts128to255octets
etherstatspkts256to511octets
etherstatspkts512to1023octets
etherstatspkts1024to1518octets
etherstatsstatus
IntervalTime
Permissions
TypeActionOwning Principal
GrantSelectuniadmin
SQL Script
CREATE VIEW RMONetherStatsStatsPSDayView AS
SELECT RMONetherStatsStats.*, IntervalTime=DATEADD(day, DATEDIFF(day,0,getdate()), 0) FROM RMONetherStatsStats WHERE datepart(weekday, IntervalDateTime) BETWEEN 2 AND 6 AND datepart(hour, IntervalDateTime) BETWEEN 8 AND 18
GO
GRANT SELECT ON  [dbo].[RMONetherStatsStatsPSDayView] TO [uniadmin]
GO
Uses
Created 01 August 2011 11:36
Copyright  CA Technologies, Inc. 2011  - All Rights Reserved