/build/static/layout/Breadcrumb_cap_w.png

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)

Posted by: dchristian 13 years ago
Red Belt
0
jmcelvoy,

What should the report return?

Is it just a count of the tickets created in the last month by submitter location?
Posted by: jmcelvoy 13 years ago
Second Degree Blue Belt
0
Exactly. My boss just needs to see how many tickets where created by each branch/location. On my user import, I have Custom 4 set to physicaldeliveryofficename, which pulls from AD the Office field under the user properties. Does that make sense?
Posted by: dchristian 13 years ago
Red Belt
0
Jmcelvoy,

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
Posted by: jmcelvoy 13 years ago
Second Degree Blue Belt
0
Works perfect. Thank you very much.
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

View more:

Share

 
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