[dbo].[M2ipStatsPSDayView]

(local) > mdb > Views > dbo.M2ipStatsPSDayView

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:24 PM Monday, May 04, 2009

Columns

Name
server_addr
probe_addr
intervaldatetime
intervalduration
ipforwarding
ipdefaultttl
ipinreceives
ipinhdrerrors
ipinaddrerrors
ipforwdatagrams
ipinunknownprotos
ipindiscards
ipindelivers
ipoutrequests
ipoutdiscards
ipoutnoroutes
ipreasmtimeout
ipreasmreqds
ipreasmoks
ipreasmfails
ipfragoks
ipfragfails
ipfragcreates
iproutingdiscards
IntervalTime

Permissions

Type	Action	Owning Principal
Grant	Select	uniadmin

SQL Script

CREATE VIEW M2ipStatsPSDayView AS
SELECT M2ipStats.*, IntervalTime=DATEADD(day, DATEDIFF(day,0,getdate()), 0) FROM M2ipStats WHERE datepart(weekday, IntervalDateTime) BETWEEN 2 AND 6 AND datepart(hour, IntervalDateTime) BETWEEN 8 AND 18
GO
GRANT SELECT ON [dbo].[M2ipStatsPSDayView] TO [uniadmin]
GO

Uses

[dbo].[m2ipstats]
dbo