Report to Capture Work Log Details

Report to Capture Work Log Details

Can you send me the SQL query to generate this report:

- Request ID
- Subject
- Description
- Status
- Created Date
- Resolved Date
- Work Log Details under the Tasks Tab
  - Owner
  - Time Taken
  - Start Time
  - End Time
  - Description

where I can put in the value for a custom field called "Project"

Thanks.

Build version: 8.2.0 Build 8217
Database: MSSQL 




















              New to ADManager Plus?

                New to ADSelfService Plus?