Incoming User Assignments Summary

Owned by Devan Robertson
Jul 23, 2024
1 min read
Description:Provides a count, by assignment name, of all user assignments created.
Sources:Assignment

It is important that you always include tenantID in your WHERE clause.  Not doing so will result in poor performance.  

WHERE tenantid = 'YOURTENANTIDHERE'

SQL

select
tasklabel as Assignment,
count(*) as Count
from
assignment as a
where
a.tenantid = 'YOURTENANTIDHERE'
and a.assignmentstate = 'Created'
and a.workgroup NOT IN ('System', 'Pending') 
and a.createdatetime=:daterange
group by tasklabel
order by tasklabel

Change Log

DateDescription
7/23/2024New