Search the Community
Showing results for tags 'logged'.
Found 2 results
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
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.