Jump to content

Search the Community

Showing results for tags 'logged'.



More search options

  • 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
    • Service Manager
    • 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 2 results

  1. 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 this query, also is there a easier way to do it? Thanks Hayley
  2. Hi - I am very new to this site so not sure of there is a list anywhere of possible answers to my query anyway! I need to find a way of producing a accurate first time fix percentage for my staff - currently we report on calls closed divided by calls logged. But the calls logged include calls that are assigned to other teams whereas I want calls that my team log and close within the Service Desk. Ie someway of capturing only calls that do not go out of the Service Desk group. Not sure if I am making much sense here - but anyone have any ideas? Thanks in advance.
×
×
  • Create New...