Incoming User Assignments

Owned by Devan Robertson
Last updated: Jul 23, 2024
1 min read
Description:Provides a list 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 
    *
from
    assignment as a
where
	a.tenantid = 'YOURTENANTIDHERE'    
	and a.assignmentstate = 'Created'
    and a.workgroup NOT IN ('System', 'Pending')
	and a.createdatetime=:daterange
order by a.createdatetime desc

Change Log

DateDescription
7/23/2024Added create date filer