How to check the status (active, retired , etc) of a machine?

1. You change/view the status of a computer under Altiris Console, click the Resources tab > Resources > Defaults.

2. Import the attached report into the reports tab or create your own using SQL like the following. that can help to identify retired machines.
Run it against Altiris database. ( replace 'retired' to the status you want to check).

SELECT     i1.Name AS Asset, rt.Name AS [resource type], i2.Name AS
Status, i1.Guid
FROM         ResourceAssociation ra INNER JOIN
                      Item i1 ON i1.Guid = ra.ParentResourceGuid INNER
JOIN
                      Item i2 ON i2.Guid = ra.ChildResourceGuid INNER
JOIN
                      ItemResource ir ON ra.ParentResourceGuid = ir.Guid
INNER JOIN
                      ResourceType rt ON rt.Guid = ir.ResourceTypeGuid
WHERE     (ra.ResourceAssociationTypeGuid =
'3028166F-C0D6-41D8-9CB7-F64852E0FD01') AND (i2.Name LIKE 'retired')