/build/static/layout/Breadcrumb_cap_w.png

K1000: All Queue Default Owners

The below SQL report will return all the default queue owners of all your helpdesk desk categories along with the settings.

SELECT 
USER.FULL_NAME AS OWNER_NAME,
USER.EMAIL,
HC.NAME AS QUEUE_NAME,
HC.ORDINAL,
HC.DEFAULT_OWNER_ID,
HC.CC_LIST,
HC.USER_SETTABLE,
HC.HD_QUEUE_ID
FROM
HD_CATEGORY HC
LEFT JOIN
USER ON HC.DEFAULT_OWNER_ID = USER.ID
ORDER BY HC.HD_QUEUE_ID

And the results look like the below


Comments

This post is locked
 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ