Views [dbo].[activitydistravgsview]
(local) > mdb > Views > dbo.activitydistravgsview
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created11:10:29 AM Wednesday, March 07, 2007
Last Modified11:10:29 AM Wednesday, March 07, 2007
Columns
Name
activity
avg_time_spent
process_name
Permissions
TypeActionOwning Principal
GrantSelectaionadmin_group
SQL Script

CREATE VIEW "activitydistravgsview" ("activity", "avg_time_spent", "process_name")  AS
       SELECT "activitydistrcompview"."activity", AVG(time_spent), "activitydistrcompview"."process_name"
       FROM "activitydistrcompview"
       GROUP BY activity, process_name


GO
GRANT SELECT ON  [dbo].[activitydistravgsview] TO [aionadmin_group]
GO
Uses
Created 03 June 2010 08:02
Copyright 2010 by CA Technologies, Inc. - All Rights Reserved