[dbo].[ActorBottleneckView]
SET QUOTED_IDENTIFIER OFF
GO
create view ActorBottleneckView as SELECT userlist_worklist.username AS actor, stats.NODENAME AS activity_name, AVG((stats.completed - stats.duedate) / 1000) AS avg_time_late, NODEDESC AS activity_description, stats.PROCESSNAME AS process_name, stats.PROCESSID AS instance_id
FROM stats, userlist_worklist, productidview
WHERE (stats.workitemid = userlist_worklist.workitemid) AND (stats.completed > stats.duedate) AND (stats.duedate > 0) AND (stats.productid = productidview.productid)
GROUP BY userlist_worklist.username, stats.NODENAME, NODEDESC, stats.PROCESSNAME, stats.PROCESSID
GO
GRANT SELECT ON [dbo].[ActorBottleneckView] TO [aionadmin_group]
GO
