Computer Status value unexpectedly changes due to data replication

Article:TECH202999  |  Created: 2013-02-20  |  Updated: 2014-06-03  |  Article URL http://www.symantec.com/docs/TECH202999
Article Type
Technical Solution


Issue



A computer Status changes from a specific status, such as Retired or In Stock, to Active. This occurs on a re-curring basis such as once a day, an hour, etc.


Cause



A custom Stand-alone Replication Rule (Altiris 7.x) or Inventory Forwarding Rule (Altiris 6) is sending the parent computer's Status to the child, overwriting it with its Status.


Solution



This is working as the customer has configured their custom forwarding rules and does not occur with the out of the box settings. Disable the rule from sending a computer's status if this is not desired to be changed on the child server. Other work-arounds can include: delete the computer on the parent it if is no longer needed or create a custom CMDB Rule (which is not discussed further in this article) that resets the Status after the inventory is forwarded.

Note: A custom stand-alone replication rule when used with CMDB Solution 7.1 is an unsupported configuration. The following article describes how this works and doesn't work:

Does Asset Management or CMDB Solutions support hierarchy and stand-alone replication rules?
http://www.symantec.com/business/support/index?page=content&id=HOWTO26021

The user can also view what, when and who changed the status by reviewing the computer's Resource History. Other possible causes can be the following:
 

  • A user is manually changing the status.
  • A Data Connector Import Rule imports changes to the status.
  • A Barcode sync changes the status.
     

Also, the following SQL scripts can be run to help determine what the cause, user or task, resulted in the status change:

USE Symantec_CMDB
SELECT vi.Guid, vI.Name 'Asset', rahd.ChangeDate 'Date Changed', fas.Name 'Status'
FROM ResourceAssociationHistoryDelta rahd
JOIN vFixedAssetStatus fas
ON fas._ResourceGuid = rahd.ChildResourceGuid
JOIN vItem AS vi
ON vi.Guid = rahd.ParentResourceGuid
--WHERE RAHD.ParentResourceGuid = '<Computer GUID>' -- Enable this line and change "<Computer GUID>" to the GUID of a single computer to find only one computer.
ORDER BY 2, 3 DESC

-- Then, search Evt_NS_Item_Management for the approximate time (give or take several seconds or so, depending on what the NS state at the time).
SELECT *
FROM Evt_NS_Item_Management
WHERE ItemGuid = '<Computer GUID>' -- Enable this line and change "<Computer GUID>" to the GUID of the computer from the first SQL script.
ORDER BY _eventTime DESC

Related Articles

What reports offer a historical view of asset changes or deletions?
http://www.symantec.com/business/support/index?page=content&id=HOWTO92269

What can cause computers on a reporting server to be set to a non-Active status, such as Retired, during the Inventory Forwarding process?
http://www.symantec.com/business/support/index?page=content&id=HOWTO9336

How the Retired status for a computer works
http://www.symantec.com/business/support/index?page=content&id=HOWTO52993

Computer status changes from Retired back to Active
http://www.symantec.com/business/support/index?page=content&id=TECH160029

Computer's Manufacturer, Model, Serial Number or System Number are incorrect or missing
http://www.symantec.com/business/support/index?page=content&id=TECH209095

Random assets suddenly disappear from the Symantec Management Platform Console
http://www.symantec.com/business/support/index?page=content&id=TECH210362




Article URL http://www.symantec.com/docs/TECH202999


Terms of use for this information are found in Legal Notices