[dbo].[ProcStatusIncompView]
create view ProcStatusIncompView 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 (instances.completed = 0) AND (instances.productid = productidview.productid) AND (definitions.productid = productidview.productid) GROUP BY instances.definitionid, definitions.name
GO
GRANT SELECT ON [dbo].[ProcStatusIncompView] TO [aionadmin_group]
GO
