I need a query to show me how long you were a ticket without being assigned. Ideally that allows me to select a specific support group, select a time range and is the last month.

 

SDP Professional 8108

MSSQL

 

Fields:

 

request_id

Date / time create

Date / time assign

Hours / minutes without to assign

Group

Category

Subcategory

 

Thanks a lot!

 

Mauricio