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

CREATE VIEW "activitydistrcompview" ("item_id", "instance_id", "activity", "time_spent", "process_name")  AS
       SELECT "stats"."workitemid", "stats"."processid", "stats"."nodename", (stats.completed - stats.started) / 1000, "stats"."processname"
       FROM "stats", "productidview"
       WHERE (stats.completed IS NOT NULL) AND (stats.completed > 0) AND (stats.productid = productidview.productid)


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