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