kwashington

Comments

  • Actually I think it does. If I have that asset # search box in there, I can input the asset # and it's attached to the ticket like we hoped it would be. I just don't like the other 2 fields on that asset search, or the way the asset # field is way off to the right.
  • Oh really? So there's no way to have them choose their computer or printer # when creating the ticket? We do currently have a custom field for them to enter their computer #. We were hoping to launch to that computer through dameware like you can if the asset is attached to the ticket.
  • If I uncheck the asset lookup for client box under tickets --> options, that asset # search box goes away.
  • No, we've only made a couple custom fields and asset isn't one of them. I'm not sure how it got there? I checked the box under tickets --> options to allow the client to search assets, and then under the request type I checked the model box. After those changes, those are the 3 fields I got. I'm not sure what SCCM is? We…
  • Here's what the final report looks like, with all the details blurred out.
  • Sure. This is the one we're using. It might be more difficult than you want it to be. I'm doing a data driven subscription that's unique to each tech, so it puts open tickets (unassigned) on the top, ones assigned to them under that, and assigned to anyone else under that. But I'm sure you can get what you need out of this…
  • Good morning. We have version 12.2.0 build #12.2.0.9011. I don’t see anywhere it lists what hot fixes we have, does the build give you that information? It was asked if this happens to all techs. So far only 3 of us have tried it, as we’re trying to figure it out so we can demo it to the rest of the group, but it’s done…
  • Ok I just found where you check the box for model in the request type. So I have the box coming up but it's less than ideal. Really we just want them inputting the asset # and moving on... In the asset search box there is a dropdown box for asset type and model on the left side. Then waaaaay over on the right is a search…
  • We had the same basic need, only we wanted a report of all open tickets emailed to the tech group every 2 hours throughout the day. I ran into the same thing you did - reporting giving summary type information but not ticket detail like we needed. I ended up creating a SQL query to get the data we need, and we have a…
  • JOB_TICKET.JOB_TICKET_ID, .SUBJECT, .QUESTION_TEXT, rtrim(CLIENT.FIRST_NAME) + ' ' + rtrim(CLIENT.LAST_NAME) AS CLIENT, .PHONE, rtrim(TECH.FIRST_NAME) + ' ' + rtrim(TECH.LAST_NAME) AS ASSIGNED_TO, .PRIORITY_TYPE_NAME, .PROBLEM_TYPE_NAME, .STATUS_TYPE_NAME, CONVERT(VARCHAR(10),JOB_TICKET.REPORT_DATE,101) AS DATE,…
  • We use SQL / SSRS for reporting