Hi Team
I need to build a report completed by assigned subtasks tail but can not find how. I would appreciate some guidance from you
I'm not exactly sure what you are looking for but I gather you are trying to pull in only subtasks and not all tasks. You can pull in just subtasks by checking the Name box under Tasks on the left of the report builder and setting it to "subtask" (without the quotes).
I'm looking for a report only for subtask.
Does anyone know if Service Desk IT Analytics' cubes has a cube, report, o dashboard showing reports per subtasks??
Thanks
Officially Workflow doesn't have any indicators to distinguish between a normal process task or a sub task. ServiceDesk however will add the word Subtask to the title when it creates any subtasks. You will have to simply run a report keying on the Task title. ITA doesn't have any reports/cubes by default for this.
Hi,
You can create a report in Servicedesk, choose sql and put this query:
select CompletedBy, name, description,CompletedOn, * from Task where [Name] like '%subtask%' and [IsCompleted] = '1'
I dont know if this is everything you need