Systems Management Question
Service Desk Report with LDAP label
I have service desk report that I run every month and would like to add ldap query to differentiate users by what ldap label they belong to. So I created a new ldap label named "Sites - Users" and imported users so they can get associated with the label I created. Now I need to add the label on to the report I already have.
Any help would be appreciated.
HD_CATEGORY.NAME AS CATEGORY,
HD_STATUS.NAME AS STATUS_NAME,
S.FULL_NAME AS SUBMITTER_NAME,
O.FULL_NAME AS OWNER_NAME,
MONTH(HD_TICKET.CREATED) AS 'Month',
HD_TICKET JOIN HD_PRIORITY ON (HD_PRIORITY.ID = HD_TICKET.HD_PRIORITY_ID)
JOIN HD_STATUS ON (HD_STATUS.ID = HD_TICKET.HD_STATUS_ID) LEFT JOIN USER S ON (S.ID = HD_TICKET.SUBMITTER_ID) LEFT JOIN USER O ON (O.ID = HD_TICKET.OWNER_ID) JOIN HD_CATEGORY ON (HD_CATEGORY.ID = HD_TICKET.HD_CATEGORY_ID) WHERE (HD_TICKET.HD_QUEUE_ID = 1) AND (HD_TICKET.CREATED between '2019/01/01' and '2019/01/31') ORDER BY CREATED
Be the first to answer this question