How to check the status (active, retired, disposed, In stock , 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
FROM ResourceAssociation ra INNER JOIN
Item i1 ON i1.Guid = ra.ParentResourceGuid INNER
Item i2 ON i2.Guid = ra.ChildResourceGuid INNER
ItemResource ir ON ra.ParentResourceGuid = ir.Guid
ResourceType rt ON rt.Guid = ir.ResourceTypeGuid
WHERE (ra.ResourceAssociationTypeGuid =
'3028166F-C0D6-41D8-9CB7-F64852E0FD01') AND (i2.Name LIKE 'retired')