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.