07-07-2021 12:59 PM
I've got some experience writing a SQL query to check for Workflow Timers in Error Status but I'm not finding the table that records the User Groups associated with the task. For example:
07-07-2021 01:04 PM
Roger,
Looks like that would be USERGSCHEDULERTASK joined to USERGROUP and SCHEDULERTASK.
07-07-2021 01:04 PM
Roger,
Looks like that would be USERGSCHEDULERTASK joined to USERGROUP and SCHEDULERTASK.
07-07-2021 02:46 PM
Hi Larissa.
I accepted your answer to give you credit because you're so helpful to this group. 😄
I gave up checking tables that started with hsi.schedule (Scheduled Tasks Service) before I got to hsi.scheduler. I checked my other script and was clued into the right table name and since I didn't find the cross reference table there I started looking for hsi.userg.
07-07-2021 02:41 PM
I found it: hsi.usergschedulertask.
SELECT usergroupname AS 'Usergroup Name', schedtaskname AS 'Task Name'
FROM hsi.usergschedulertask AS ugst
INNER JOIN hsi.usergroup AS ug ON ugst.usergroupnum = ug.usergroupnum
INNER JOIN hsi.schedulertask AS st ON ugst.schedtasknum = st.schedtasknum
ORDER BY 'Task Name'
05-05-2023 09:21 AM
Where is this information on error state? I'm trying to find the information in the database where I can see a Workflow Timer in an Error State, like all in an error state.
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.