How to find a task's execution status

Products

IT Management Suite Inventory Solution for Unix/Linux Inventory Solution Inventory Solution for Mac

Issue/Introduction

Resolution

Overview of the relationships between the task item record and the tables showing the task execution status results:

The 'item' record contains the task name.
Each task (item) record may have one or more versions in the 'itemversions' table. If a change is made to a task, a new version record is is created. The most recent (max) version may need to be identified in any sql script.
Each 'itemversions' record is related to a 'taskinstances' record (the TaskInstances records contain a TaskVersionGuid). A task instance is created each time a task executes. The most recent instance may need to be identified in any sql script.
The taskinstances records contain the relationship to the 'taskinstancestatus' and 'taskinstanceresults', which indicate if a task succeeded, failed, etc.

============================================================

Relationships among the various task-related tables:

Item.Guid -> ItemVersions.ItemGuid

Item.Guid -> ItemClass.Guid

ItemClass.Guid -> Class.Guid

ItemVersions.VersionGuid -> TaskInstances.TaskVersionGuid

TaskInstances.ResourceGuid -> vcomputer.Guid

TaskInstances.ResourceGuid -> inv_aex_ac_identification._ResourceGuid

TaskInstances.TaskInstanceGuid -> TaskInstanceStatus.TaskInstanceGuid

TaskInstances.TaskInstanceGuid -> TaskInstanceResults.TaskInstanceGuid

============================================================

Sample SQL query to find task status for two specific classes of tasks:

***********************************

-- Find tasks by class type; show instances, versions, end times and statuses

Declare @TaskName varchar(255)

Declare @ComputerName varchar(255)

Set @TaskName = '%'

Set @ComputerName = '%'

select vc.guid 'Client GUID'

, vc.name 'Client Name'

, c.type 'Class Type'

, i.guid 'Task Guid'

, i.name 'Task name'

, ti.TaskInstanceGuid 'Instance Guid'

, iv.Version 'Instance Version'

, tir.endtime 'Instance EndTime'

, case tis.instancestatus

when 0 then 'Not started'

when 1 then 'Started'

when 2 then 'Completed'

when 3 then 'Failed'

when 4 then 'Stop Requested'

else 'unknown'

end 'Instance Status'

from ItemClass ic

join class c on ic.guid = c.guid

join item i on i.guid = ic.guid

join itemversions iv on iv.itemguid = i.guid

join taskinstances ti on ti.taskversionguid = iv.versionguid

join vcomputer vc on ti.resourceguid = vc.guid

left join taskinstancestatus tis on tis.taskinstanceguid = ti.taskinstanceguid

left join taskinstanceresults tir on tir.taskinstanceguid = ti.taskinstanceguid

where [classGuid] in

('3CB6424C-6B59-4C19-8ACE-1E12D265CEC3', -- Altiris.Inventory.InventoryTask

'4F1B9B32-B5C6-4D83-8992-F73582217AAC') -- Altiris.TaskServerTasks.ScriptTask.ScriptTask

and i.name like @TaskName

and vc.name like @ComputerName

order by i.name, vc.name, iv.version, tir.endtime

***********************************

============================================================

For Unix, Linux and Mac (ULM) tasks, the following commands will show the task version and instance IDs for use in SQL queries:

aex-cta list --show-task-id

--> This command returns the "Task Definition Version ID"

aex-cta list C34A7A27-AD28-4481-B1AB-24C62944F118

--> The guid here is the "Task Definition Version ID". This command returns each "Task Execution instance ID"

aex-cta info C34A7A27-AD28-4481-B1AB-24C62944F118 C164DDB0-FE90-4346-BC59-B543FAE235F1

--> The guids here are the "Task Definition Version ID" and one specific "Task Execution instance ID". This command returns task instance execution dates, statuses, etc.

The "Task Definition Version ID", from the output of the above commands, may be found in the ItemVersions.VersionGuid field in the database. The corresponding ItemVersions.ItemGuid is the actual task guid which corresponds to the Item.ItemGuid value.

Once the 'Task Definition Version ID" is found, the following query will show the task guid and name:

select i.guid, i.name

from item i

join itemversions iv on iv.itemguid = i.guid

where iv.versionguid = '<Task Definition Version ID>'