Hi,
use the better solution:
1. Stop Services: „Altiris Client Task Data Loader“ and „Altiris Support Service“
2. Run SQL:
SELECT ti.[TaskInstanceGuid]
,ti.[ResourceGuid]
,ti.[TaskVersionGuid]
,ti.[InstanceType]
,tis.Name
,tis.ExecutedBy
,tis.StartTime
FROM [Symantec_CMDB].[dbo].[TaskInstances] ti
left join TaskInstanceSummaries tis
on ti.TaskInstanceGuid = tis.TaskInstanceGuid
where ti.ResourceGuid like '0000%'
3. Run second SQL:
(copy the TaskInstanceGuid from previous sql)
delete from taskinstanceresults
where taskinstanceguid = 'put TaskInstanceGuid here'
delete from taskinstances
where taskinstanceguid = 'put TaskInstanceGuid here'
delete from taskinstanceparents
where taskinstanceguid = 'put TaskInstanceGuid here'
delete from taskinstancesstarted
where taskinstanceguid = 'put TaskInstanceGuid here'
delete from taskinstancestatus
where taskinstanceguid = 'put TaskInstanceGuid here'
4. Start services from Step 1
5. Start Update Summary Task manually for test
Finished.