ITMS Administrator Group

Hello community,

Maybe you can help. I need to report the actual exit codes from the running tasks. While the report in Reports\Task Server\Status\Job/Task Status Detail is ok, it reports only the status. I have to have the actual exit codes. For example, when you run Windows 10 compatibility scan, it exits with -1047526896 code.
It translates into (0xC1900210) in hex, that stands for "it does not find any compat issue". According to https://docs.microsoft.com/en-us/windows-hardware/manufacture/desktop/windows-setup-command-line-options there are few more codes that need to have a track of:

• If it finds Actionable compat issues, like Apps, it will return MOSETUP_E_COMPAT_INSTALLREQ_BLOCK (0xC1900208)
• If it finds that the Mig-Choice selected is not available, it will return MOSETUP_E_COMPAT_MIGCHOICE_BLOCK (0xC1900204)
• If it finds that machine is not eligible for Windows 10, it will return MOSETUP_E_COMPAT_SYSREQ_BLOCK (0xC1900200)
• If it finds that machine does not have enough free space to install, it will return MOSETUP_E_INSTALLDISKSPACE_BLOCK (0xC190020E)

I have a custom sql code, that returns output of the task, but not the exit code.

Any ideas ?

Thanks

Tomasz

Hello,

I have amended the existing report and I managed to throw 2 birds with one stone. For reference I paste the report for script task execution. It reports both the output as well as the exit code.

select 
vc.name,
vc.Domain,
vc.[OS Name],
i.Name as 'Task Name',
eti.Result,
ti.ExecutedBy, 
ti.StartTime,
replace(replace(replace(replace(cast(to2.Value as NVarchar(max)), '/',''), 'string', ''), 'int', ''),'<>','') as [Output],
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 = 'Windows 10 Setup with Compatibility Scan'
and to2.Name = 'scriptoutput'

order by ti.StartTime desc 

I hope it helps others having the same dilema.

regads,

Tomasz