[dbo].[ActorThroughputView]
SET QUOTED_IDENTIFIER OFF
GO
create view ActorThroughputView as SELECT userlist_worklist.username AS actor, stats.NODENAME AS activity_name, AVG((stats.completed - stats.started) / 1000) AS time_completed, 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.completed is not null) AND (stats.completed > 0) AND (stats.productid = productidview.productid)
GROUP BY userlist_worklist.username, stats.NODENAME, NODEDESC, stats.PROCESSNAME, stats.PROCESSID
GO
GRANT SELECT ON [dbo].[ActorThroughputView] TO [aionadmin_group]
GO
