Jump to content

Search the Community

Showing results for tags 'calls'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • Hornbill Platform and Applications
    • Announcements
    • Blog Article Discussions
    • General Non-Product Discussions
    • Application Beta Program
    • Collaboration
    • Employee Portal
    • Service Manager
    • IT Operations Management
    • Project Manager
    • Supplier Manager
    • Customer Manager
    • Document Manager
    • Configuration Manager
    • Timesheet Manager
    • Live Chat
    • Board Manager
    • Mobile Apps
    • System Administration
    • Integration Connectors, API & Webhooks
    • Performance Analytics
    • Hornbill Switch On & Implementation Questions
  • About the Forum
    • Announcements
    • Suggestions and Feedback
    • Problems and Questions
  • Gamers Club's Games
  • Gamers Club's LFT

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


Organisation


Location


Interests


AIM


MSN


Website URL


ICQ


Yahoo


Jabber


Skype

Found 5 results

  1. I have written a widget for Aged calls I would like to know the Aged calls for 30-60 days, 60-90 days and 90+ days This is what I have for 30-60: (h_status = 'status.New' OR h_status = 'status.open' OR h_status = 'status.onhold') and h_requesttype = 'incident' and h_datelogged < DATE_SUB(CURDATE(), INTERVAL 30 DAY) AND (NOW() - INTERVAL 60 DAY) AND (h_fk_team_id = 'GOSH/DivFINICT/SubICT/ITSRV/AV/AVTEAM/' OR h_fk_team_id = 'GOSH/DivFINICT/SubICT/ITSRV/SDEP/ENPT/' OR h_fk_team_id = 'GOSH/DivFINICT/SubICT/ITSRV/SDEP/SERDSK/') for 60-90: (h_status = 'status.New' OR h_s
  2. Morning all, I am trying to create a widget to tell me the current calls logged this month so far. so from the 1st nov to current date, I don't want to have to change the query every month to keep up and want it to roll each month. So I have written this (I'm quite new to T-sql so it wont be right!): (h_requesttype = 'Service Request' OR h_requesttype = 'Incident') AND DATE(h_datelogged) BETWEEN dateadd(DAY,-(DATEPART(DAY,GETDATE())-1),GETDATE()) AND GETDATE()) however its not working, is this anywhere near right? Could someone point me in the correct direction with thi
  3. Afternoon, We have a 3rd party printer support contract with Xerox, so I have created a BPM and Pro cap that creates a email to Xerox with the iformation they need, Xerox then reply to the email with our reference number in the subject box of the email, these should then pull into the relevant call and update. However they are not doing this... as you can see from the screenshot - the subject clearly has the correct Call ref in it: as you can see from the timeline of the call...no email has pulled in: This is the routing rule I am using: Can anyone advise?
  4. Afternoon all, I just wondered if there is a way to report on the number of teams that have handled one call? Say a call went to Service Desk got reassigned to Business Applications then got sent to Application Delivery and finally back to Service Desk. Is there a report that shows this? Thanks Hayley.
  5. Hello, We haven't released the Self Service portal to our customers and are now starting to look at it in more detail... is it possible to have a setting somewhere which allows you to specify a date to hide calls in retrospect of it? This would be the date we would release it to our customers. We are actively looking at improving everything we currently do in preparation for the Self Service Portal so it would be a great help to keep the calls that customers have raised prior to going live hidden from them. These are the calls that would've been raised by email or by calling the Serv
×
×
  • Create New...