Views [dbo].[M2ifStatsPSDayView]
(local) > mdb > Views > dbo.M2ifStatsPSDayView
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created11:10:05 AM Wednesday, March 07, 2007
Last Modified5:37:23 PM Monday, May 04, 2009
Columns
Name
server_addr
probe_addr
intervaldatetime
intervalduration
ifindex
ifadminstatus
ifoperstatus
iflastchange
ifinoctets
ifinucastpkts
ifinnucastpkts
ifindiscards
ifinerrors
ifinunknownprotos
ifoutoctets
ifoutucastpkts
ifoutnucastpkts
ifoutdiscards
ifouterrors
ifoutqlen
IntervalTime
Permissions
TypeActionOwning Principal
GrantSelectuniadmin
SQL Script
CREATE VIEW M2ifStatsPSDayView AS
SELECT M2ifStats.*, IntervalTime=DATEADD(day, DATEDIFF(day,0,getdate()), 0) FROM M2ifStats WHERE datepart(weekday, IntervalDateTime) BETWEEN 2 AND 6 AND datepart(hour, IntervalDateTime) BETWEEN 8 AND 18
GO
GRANT SELECT ON  [dbo].[M2ifStatsPSDayView] TO [uniadmin]
GO
Uses
Created 03 June 2010 08:02
Copyright 2010 by CA Technologies, Inc. - All Rights Reserved