- Find the open activity IDs by running this SQL query against the ECE eGActiveDb database in MSSQL Management Studio:
SELECT * FROM egpl_casemgmt_activity
WHERE activity_status !=9000
AND assigned_to= (SELECT user_id FROM egpl_user WHERE user_name LIKE 'georgmcc')