Worklog Report across all modules with Account

Worklog Report across all modules with Account



Hi,

We need a report that provides all worklogs from all modules (requests, changes etc.). We have found reports that do more or less what we need from other forum posts, but they do not include the 'Account' field which we require as we use the MSP edition.

Does anyone have an MSSQL query that will provide us with this information?

The columns we would need would be as follows as an example:

Module ID
Module
Account
Title
Created Time
Technician
Time Spent
1
Request
Company
Remote session with customer blah...blah
01/12/2016
J.Bloggs
1hr 30min

Any help would be much appreciated.


                New to ADSelfService Plus?