Queue Items

SELECT * FROM dm_queue where name = 'dm_fulltext_index_user' order by date_sent

SELECT * FROM dmi_queue_item 

WHERE name = 'dm_fulltext_index_user' 

AND delete_flag = false

ORDER BY date_sent

SELECT * FROM dm_queue 

WHERE name = 'dm_fulltext_index_user' 

AND task_state IN ('warning','failed')

ORDER BY date_sent

SELECT * FROM dmi_queue_item 

WHERE name = 'dm_fulltext_index_user' 

AND delete_flag = false

AND task_state IN ('warning','failed')

ORDER BY date_sent

SELECT * FROM dm_queue WHERE name IN ('dm_mediaserver', 'dm_autorender_win31') AND event = 'rendition'

select * from dmi_queue_item

where name not in ( 'dm_fulltext_index_user','dm_mediaserver', 'dm_autorender_win31')

and delete_flag = 0

and r_object_id not in (select distinct r_queue_item_id from dmi_workitem)

SELECT event, count(*) FROM dmi_queue_item

WHERE name NOT IN ('dm_fulltext_index_user','dm_mediaserver', 'dm_autorender_win31')

AND delete_flag = 0

AND r_object_id NOT IN (SELECT distinct r_queue_item_id FROM dmi_workitem)

group by event