[dbo].[ProcStatusCompView]
create view ProcStatusCompView as SELECT definitions.name AS process_name, COUNT(instances.id) AS instance_count, instances.definitionid AS process_id FROM definitions INNER JOIN instances ON definitions.id = instances.definitionid, productidview WHERE (NOT (instances.completed = 0)) AND (instances.productid = productidview.productid) AND (definitions.productid = productidview.productid) GROUP BY instances.definitionid, definitions.name
GO
GRANT SELECT ON [dbo].[ProcStatusCompView] TO [aionadmin_group]
GO
