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

Date	Description
7/23/2024	New

QFD Knowledgebase

Incoming User Assignments Summary

Analytics

SQL

Change Log

Related content