Hi @Harsh3842 

This AssetCiSynchronization process is not that simple. 

Until and and unless customization which has strong business justification is there then you can modify this process.

Because here if the change is not done carefully , it can break the synchronization process (bidirectional ASSET & CI sync process) and you will not get any support due to your customization until you are reverting to OOB.

Next coming to your requirement - " updating record in the Hardware (alm_hardware) state field to "Retired" then in configuration item (cmdb_ci) table the Operational status needs to be changed to Retired and vice versa"

Using BR  on the CI table - you can achieve it  , why you are changing syncing process?