Hello,

 

We've created an additonal field in the Helpdesk Incidents labelled Call Out, a pick list with choices Yes or No based on whether the incident requires On Call assistance. This is based on out of hours work.

 

I have created a query to run an SSRS report to show technician worklog times which is working fine but have new requirements.

 

Firstly how can I access this additonal field in the servicedesk database, which table, field? (using SQL Server 2008)

 

Secondly could I use this field to write a query to show technician worklog times seperated out into Call Out and Non Call Out. I've already used a query posted previously to extract all the worklog times from Requests, Changes, Projects etc.

 

Thanks