Hi,
What I do when run a custom script is , in Advanced option I select '
select top 10000
vc.name,
i.Name as 'Task Name',
ti.ExecutedBy,
ti.StartTime,
replace(replace(replace(replace(cast(to2.Value as NVarchar(max)), '/',''), 'string', ''), 'int', ''),'<>','') as 'Task Output'
--eti._ResourceGuid,
--ti.TaskInstanceGuid,
--ti.Name as 'Task Instance Name',
from TaskInstanceSummaries ti
left join TaskInstanceParents tip on tip.ParentTaskInstanceGuid = ti.TaskInstanceGuid
left join TaskOutputPropertyValue to2 on to2.TaskInstanceGuid = tip.TaskInstanceGuid
join ItemVersions iv on iv.VersionGuid = ti.TaskVersionGuid -- Find the name of the task
join Item i on i.Guid = iv.ItemGuid
join Evt_Task_Instances eti on eti.TaskInstanceguid = tip.TaskInstanceGuid
join vComputer vc on vc.guid = eti._ResourceGuid
where i.Name = 'Task Name'
and to2.Name = 'scriptoutput'
order by ti.StartTime desc
I hope it helps.
Tomasz