Query required - missing work logs on closed requests

Query required - missing work logs on closed requests

Dear Support,

Can I have a query to list all closed requests for a named technician group where no work log has been added to the request?

Where we have multiple technician groups we cannot make worklogs mandatory, but for one group they need to be - I would like to be able to list all requests where people have forgotten to add them and then get people to go back and add them in.

Fields to display in the report:

Request ID, Title, Date Completed, Assigned Technician

Query for MSSQL using build 8205

Many thanks,

Dean

                  New to ADSelfService Plus?