SQL Query for User Group(s) Assigned to Unity Scheduler Workflow Timer Tasks

[Roger_Linhart]

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: 

[Larissa_Armand · Accepted solution]

Roger,

Looks like that would be USERGSCHEDULERTASK joined to USERGROUP and SCHEDULERTASK.

[Roger_Linhart]

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.

[Roger_Linhart]

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'

[Brian_Espinosa]

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.