Report by Location
I need to setup a report that I can run on a monthey basis that will show my how many Helpdesk tickets have been opened by Location. Under User Details, Custom 4 is setup with the users Location. I walked through the Report Wizard but didn't see any way to use Custom 4 as a query field. If someone has done this before, can you let me know the script you used to get the info? Of if someone can tell me how to use the Report Wizard and query the Custom 4 field? Thanks.
0 Comments
[ + ] Show comments
Answers (4)
Please log in to answer
Posted by:
dchristian
13 years ago
Posted by:
jmcelvoy
13 years ago
Posted by:
dchristian
13 years ago
Jmcelvoy,
Try these.
This should give you everything in the last 30 days:
You can use this for a specific time period:
Try these.
This should give you everything in the last 30 days:
SELECT Coalesce(U.CUSTOM_4, 'Unassigned') AS BRANCH,
COUNT(*)
FROM HD_TICKET H
LEFT JOIN USER U
ON H.SUBMITTER_ID = U.ID
WHERE H.CREATED >= DATE_SUB(Current_date(), INTERVAL 30 DAY)
GROUP BY BRANCH
You can use this for a specific time period:
SELECT Coalesce(U.CUSTOM_4, 'Unassigned') AS BRANCH,
COUNT(*)
FROM HD_TICKET H
LEFT JOIN USER U
ON H.SUBMITTER_ID = U.ID
WHERE ( H.CREATED >= '2010-12-01'
AND H.CREATED <= '2010-12-31' )
GROUP BY BRANCH
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.
so that the conversation will remain readable.