[dbo].[RMONetherStatsStatsLastDayView]

(local) > mdb > Views > dbo.RMONetherStatsStatsLastDayView

Properties
Columns
Permissions
SQL Script
Uses

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

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

Type	Action	Owning Principal
Grant	Select	uniadmin

SQL Script

CREATE VIEW RMONetherStatsStatsLastDayView AS
SELECT * FROM RMONetherStatsStatsHourView WHERE IntervalTime >= DATEADD(dd, DATEDIFF(dd,1,getdate()), 0) AND IntervalDateTime < DATEADD(dd, DATEDIFF(dd,0,getdate()), 0)
GO
GRANT SELECT ON [dbo].[RMONetherStatsStatsLastDayView] TO [uniadmin]
GO

Uses