[dbo].[USM_VW_STUCK_REQUEST]
create view USM_VW_STUCK_REQUEST as
select system_alert_id,tenant_id,user_name,rtrim(ltrim(replace(left(substring(OTHER_INFO3,charindex('RequestID:',OTHER_INFO3),len(OTHER_INFO3)),charindex('!',substring(OTHER_INFO3,charindex('RequestID:',OTHER_INFO3),len(OTHER_INFO3)))-1),'RequestID:',''))) request_id
from USM_SYSTEM_ALERT where (charindex('RequestID:',OTHER_INFO3) > 0) and MESSAGE_TYPE IN ('WFACTION_FAILED','ITPAMACTION_FAILED')
union
select system_alert_id,tenant_id,user_name,rtrim(ltrim(replace(left(substring(OTHER_INFO1,charindex('RequestID:',OTHER_INFO1),len(OTHER_INFO1)),charindex('!',substring(OTHER_INFO1,charindex('RequestID:',OTHER_INFO1),len(OTHER_INFO1)))-1),'RequestID:',''))) request_id
from USM_SYSTEM_ALERT where (charindex('RequestID:',OTHER_INFO1) > 0) and MESSAGE_TYPE IN ('WFCOMPLACT_FAILED','WFTERMINATEACTION_FAILED','ITPAMCOMPLACT_FAILED','ITPAMTERMINATEACTION_FAILED')
GO
GRANT SELECT ON [dbo].[USM_VW_STUCK_REQUEST] TO [usmgroup]
GRANT INSERT ON [dbo].[USM_VW_STUCK_REQUEST] TO [usmgroup]
GRANT DELETE ON [dbo].[USM_VW_STUCK_REQUEST] TO [usmgroup]
GRANT UPDATE ON [dbo].[USM_VW_STUCK_REQUEST] TO [usmgroup]
GO
