Views [dbo].[activitydistravgsview]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created12:38:42 PM Sunday, December 05, 2010
Last Modified12:38:42 PM Sunday, December 05, 2010
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