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